Supabase MCP Server
MCP ServerFreeManage Supabase databases, auth, and storage via MCP.
Capabilities14 decomposed
mcp-standardized supabase api tool registration and schema exposure
Medium confidenceImplements the Model Context Protocol specification to expose Supabase operations as discoverable tools with JSON Schema definitions. The server uses a platform abstraction layer that maps Supabase Management API endpoints to MCP tool schemas, enabling any MCP-compatible client (Claude Desktop, Cursor, VS Code Copilot, Windsurf) to dynamically discover and invoke Supabase operations without custom integration code. Tool definitions are generated from the platform interface and include input/output schemas for type-safe invocation.
Uses a platform abstraction layer (Platform interface + API Platform implementation) that decouples MCP tool definitions from underlying Supabase API changes, enabling single-source-of-truth tool registration across multiple transport mechanisms (HTTP, stdio, SSE). This differs from monolithic integrations that hardcode API mappings.
Provides protocol-standard tool exposure vs proprietary integrations, enabling use across any MCP-compatible client without vendor lock-in or duplicate integration work
postgresql database query execution with postgrest api abstraction
Medium confidenceExecutes SQL queries and performs CRUD operations against Supabase PostgreSQL databases through a dedicated PostgREST MCP server (@supabase/mcp-server-postgrest). The server translates MCP tool invocations into PostgREST HTTP requests, handling query parameter construction, response parsing, and error translation. Supports parameterized queries to prevent SQL injection and returns results as structured JSON with metadata about affected rows and query execution.
Separates PostgREST operations into a dedicated MCP server package, allowing independent scaling and feature development. Uses parameter binding to prevent SQL injection while maintaining query expressiveness, and integrates RLS enforcement at the database layer rather than application layer.
Safer than raw SQL execution because it enforces Supabase RLS policies and uses parameterized queries, while more flexible than ORM-based approaches because it supports arbitrary SQL and PostgREST filtering syntax
shared utility abstractions for mcp server development
Medium confidenceProvides reusable TypeScript utilities and abstractions (@supabase/mcp-utils package) for building MCP servers, including platform interface definitions, tool schema builders, and common patterns for API integration. The utilities package defines the Platform interface that abstracts Supabase API differences, allowing multiple MCP server implementations (Management API, PostgREST) to share common patterns. Includes mock system for testing and development without live API access.
Provides platform abstraction pattern that allows multiple MCP server implementations to share common infrastructure while supporting different underlying APIs (Management API vs PostgREST). Includes mock system for testing without external dependencies.
Reduces duplication across multiple MCP server packages vs monolithic single-server approach, while providing testing utilities that eliminate need for live API credentials during development
oauth 2.1 dynamic client registration for secure credential exchange
Medium confidenceImplements OAuth 2.1 Dynamic Client Registration protocol for HTTP transport, enabling secure credential exchange without storing long-lived API keys. When an MCP client connects via HTTP, the server initiates OAuth registration to obtain temporary access tokens scoped to specific operations. This eliminates the need to embed Supabase API keys in client configuration files, improving security for multi-user deployments. The implementation handles token refresh and credential lifecycle management.
Uses OAuth 2.1 Dynamic Client Registration instead of static API keys, enabling credential-less client configuration and per-session token management. Handles token lifecycle (issuance, refresh, revocation) transparently to clients.
More secure than API key-based authentication because tokens are temporary and scoped, and more flexible than static credentials because multiple users can access the same server with different permissions
monorepo workspace management with pnpm and biome tooling
Medium confidenceOrganizes the Supabase MCP project as a TypeScript monorepo using pnpm workspaces for dependency management and Biome for code formatting and linting. The monorepo structure enables shared utilities (@supabase/mcp-utils) to be used by multiple server implementations (@supabase/mcp-server-supabase, @supabase/mcp-server-postgrest) while maintaining independent versioning and publishing. Biome provides fast, unified linting and formatting across all packages without external tool dependencies.
Uses pnpm workspaces with explicit workspace protocol for dependency management, enabling efficient sharing of utilities while maintaining independent package versioning. Biome provides unified linting/formatting without external tool dependencies.
More efficient than npm workspaces because pnpm uses symlinks and hoisting, and faster than ESLint+Prettier because Biome is a single unified tool written in Rust
mock system for testing mcp servers without live api access
Medium confidenceProvides a testing framework and mock API system that allows MCP server implementations to be tested without requiring live Supabase API credentials or network access. The mock system (@supabase/mcp-utils) includes predefined mock responses for common operations and allows custom mock configurations for testing edge cases. Tests can verify tool behavior, error handling, and response formatting without external dependencies.
Provides mock system integrated into @supabase/mcp-utils, allowing all MCP server implementations to share testing infrastructure. Mocks are TypeScript-based, enabling type-safe test configurations.
Eliminates need for live API credentials in tests vs integration testing, while providing more realistic behavior than simple stub responses because mocks include error scenarios and edge cases
supabase management api operations for project administration
Medium confidenceExposes Supabase Management API endpoints through MCP tools for administrative operations including account management, project configuration, database branching, and cost tracking. The @supabase/mcp-server-supabase package implements a platform abstraction layer that translates MCP tool invocations into authenticated Management API HTTP requests, handling OAuth 2.1 authentication via Dynamic Client Registration and managing API response parsing. Supports feature groups that can be selectively enabled/disabled to control which operations are available.
Implements feature groups (selectively enabled tool categories) and platform abstraction that allows the same MCP server to support multiple Supabase deployment modes (cloud, local CLI, self-hosted) with different API endpoints. Uses OAuth 2.1 Dynamic Client Registration for secure credential handling without storing long-lived tokens.
Provides unified MCP interface to Management API vs scattered CLI commands and web UI, enabling programmatic infrastructure automation while maintaining security through OAuth and feature group controls
database branching and preview deployment orchestration
Medium confidenceManages Supabase database branching workflows through MCP tools that create, list, and manage preview deployments. The implementation coordinates with the Management API to provision isolated database branches for development/testing, track branch metadata, and trigger deployments. Supports branching workflows where an LLM can create a branch, apply migrations, run tests, and merge changes back to production through a sequence of MCP tool invocations.
Integrates branching operations as part of the broader MCP tool ecosystem, allowing LLMs to orchestrate multi-step workflows (create branch → migrate schema → test → merge) through sequential tool calls. Abstracts async operations and polling complexity from the LLM caller.
Enables programmatic branching workflows vs manual CLI usage, integrating with LLM reasoning to automate complex database development scenarios
authentication user and session management through auth api
Medium confidenceProvides MCP tools for managing Supabase Auth users, sessions, and authentication policies. Integrates with Supabase Auth API to create users, reset passwords, manage MFA, list active sessions, and configure authentication settings. The implementation handles Auth API authentication and translates MCP tool parameters into Auth API requests, returning user objects and session metadata in structured JSON format.
Separates Auth operations into dedicated MCP tools with explicit safety considerations (rate limiting awareness, token lifetime management). Integrates with Supabase Auth's built-in security features (password hashing, MFA) rather than reimplementing them.
Provides safe, rate-limited user management through MCP vs direct Auth API access, with built-in error handling for common auth scenarios (invalid tokens, rate limits, user conflicts)
cloud storage bucket and object management with signed urls
Medium confidenceManages Supabase Storage buckets and objects through MCP tools that support uploading, downloading, listing, and deleting files. The implementation generates signed URLs for secure temporary access, handles multipart uploads for large files, and manages bucket policies and access controls. Integrates with Supabase Storage API to perform operations and returns file metadata, signed URLs, and operation status in structured format.
Generates signed URLs through MCP tools, allowing LLMs to create temporary access tokens without exposing long-lived credentials. Handles multipart upload complexity internally, presenting simple upload interface to callers.
Safer than exposing Storage API keys directly because it generates time-limited signed URLs, and more flexible than static file serving because it supports dynamic access control and programmatic file organization
edge function invocation and deployment management
Medium confidenceInvokes Supabase Edge Functions and manages their deployment through MCP tools. The implementation handles function discovery, parameter passing, and response parsing for both synchronous and asynchronous function invocations. Supports deploying new functions, updating existing functions, and managing function environment variables and secrets through Management API integration.
Separates function invocation (runtime) from function deployment (management), allowing LLMs to both trigger functions and manage their lifecycle. Handles async deployment operations transparently through polling abstraction.
Enables programmatic function invocation and deployment vs manual CLI usage, allowing LLMs to orchestrate serverless workflows and manage function configuration as code
multi-transport mcp server with http, stdio, and sse support
Medium confidenceImplements the Model Context Protocol across multiple transport mechanisms (HTTP with OAuth, stdio for local CLI, Server-Sent Events for streaming) through a unified server implementation. The core server creation logic (@supabase/mcp-server-supabase) abstracts transport details, allowing the same tool definitions and business logic to be exposed through different channels. HTTP transport includes OAuth 2.1 Dynamic Client Registration for secure credential exchange, while stdio and SSE transports support local development and streaming scenarios.
Uses a platform abstraction layer that decouples tool definitions from transport implementation, enabling single codebase to support HTTP (with OAuth), stdio (for local CLI), and SSE (for streaming) without duplicating business logic. Transport selection is configurable at server initialization.
More flexible than single-transport implementations because it supports diverse deployment scenarios (cloud HTTP, local CLI, self-hosted), while maintaining consistent tool definitions across all transports
cost tracking and usage analytics through management api
Medium confidenceExposes Supabase project cost and usage metrics through MCP tools that query the Management API for billing information, resource consumption, and cost projections. The implementation retrieves metrics for database operations, storage usage, function invocations, and other billable resources, presenting them in structured format for analysis and reporting. Supports filtering by time period and resource type.
Integrates cost and usage data from Management API into MCP tools, enabling LLMs to analyze spending patterns and make optimization recommendations. Handles API rate limiting and data aggregation transparently.
Provides programmatic cost analysis vs manual dashboard inspection, enabling AI-driven cost optimization and automated alerting based on usage thresholds
feature group-based capability control and safety gating
Medium confidenceImplements selective tool availability through feature groups that can be enabled/disabled at server initialization. The server configuration allows operators to control which MCP tools are exposed (e.g., enable database operations but disable destructive Management API operations), providing safety gating for different deployment scenarios. Feature groups are defined in server configuration and enforced at tool registration time, preventing unauthorized operations without requiring runtime checks.
Implements feature groups as first-class configuration concept rather than runtime permission checks, enabling static analysis of available capabilities and preventing accidental exposure of dangerous operations. Feature groups are enforced at tool registration time, not invocation time.
Safer than runtime permission checks because dangerous operations are not registered at all, and more flexible than hardcoded tool lists because feature groups can be configured per deployment
Capabilities are decomposed by AI analysis. Each maps to specific user intents and improves with match feedback.
Related Artifactssharing capabilities
Artifacts that share capabilities with Supabase MCP Server, ranked by overlap. Discovered automatically through the match graph.
@supabase/mcp-server-postgrest
MCP server for PostgREST
user-postgresql-mcp
A PostgreSQL MCP server built with @modelcontextprotocol/sdk.
@supabase/mcp-server-supabase
MCP server for interacting with Supabase
Supabase
** - Connects to Supabase platform for database, auth, edge functions and more.
@supabase/mcp-server-supabase
MCP server for interacting with Supabase
@iflow-mcp/garethcott_enhanced-postgres-mcp-server
Enhanced PostgreSQL MCP server with read and write capabilities. Based on @modelcontextprotocol/server-postgres by Anthropic.
Best For
- ✓AI assistant users (Claude, Cursor, Windsurf) wanting native Supabase integration
- ✓Teams building LLM agents that need backend-as-a-service capabilities
- ✓Developers migrating from custom REST integrations to standardized MCP protocol
- ✓Developers building LLM agents that need read/write database access
- ✓Data analysts using AI assistants to explore and transform Supabase data
- ✓Teams automating database operations through AI-driven workflows
- ✓MCP server developers building Supabase integrations
- ✓Teams extending Supabase MCP with custom tools
Known Limitations
- ⚠Requires MCP-compatible client — not usable with standard REST API clients
- ⚠Tool discovery is static per server initialization — dynamic tool registration not supported
- ⚠Schema generation depends on Supabase API stability — breaking API changes require server updates
- ⚠PostgREST API limitations apply — complex joins and aggregations may require raw SQL
- ⚠Row-level security (RLS) policies are enforced — LLM cannot bypass database-level access controls
- ⚠Large result sets may exceed MCP message size limits — pagination required for bulk queries
Requirements
Input / Output
UnfragileRank
UnfragileRank is computed from adoption signals, documentation quality, ecosystem connectivity, match graph feedback, and freshness. No artifact can pay for a higher rank.
About
Community MCP server for Supabase backend-as-a-service. Provides tools for database queries, table management, auth user operations, storage bucket access, and edge function invocation.
Categories
Alternatives to Supabase MCP Server
Are you the builder of Supabase MCP Server?
Claim this artifact to get a verified badge, access match analytics, see which intents users search for, and manage your listing.
Get the weekly brief
New tools, rising stars, and what's actually worth your time. No spam.
Data Sources
Looking for something else?
Search →