@supabase/mcp-server-supabase
MCP ServerFreeMCP server for interacting with Supabase
Capabilities8 decomposed
postgresql table crud operations via mcp protocol
Medium confidenceExposes Supabase PostgreSQL tables as MCP resources with standardized read, create, update, and delete operations. Implements a schema-aware abstraction layer that translates MCP tool calls into parameterized SQL queries, handling type coercion and constraint validation at the protocol boundary. Uses Supabase's JavaScript client library to maintain connection pooling and authentication state.
Bridges MCP protocol semantics directly to Supabase's JavaScript client, avoiding raw SQL exposure while maintaining schema awareness through Supabase's introspection APIs. Implements request/response translation at the protocol layer rather than requiring custom tool definitions per table.
Simpler than building custom OpenAI function schemas for each table, and more secure than exposing raw SQL execution to LLMs, because it enforces schema contracts through the MCP protocol itself.
real-time database change subscriptions via mcp resources
Medium confidenceExposes Supabase Realtime subscriptions as MCP resources, allowing MCP clients to subscribe to PostgreSQL table changes (INSERT, UPDATE, DELETE) and receive streaming notifications. Implements WebSocket connection management through Supabase's Realtime client, translating change events into MCP resource updates that clients can poll or stream.
Leverages Supabase's native Realtime service (built on Elixir/Phoenix) rather than polling, reducing latency to sub-100ms for change notifications. Integrates WebSocket lifecycle management directly into MCP resource semantics, allowing clients to subscribe/unsubscribe through standard MCP calls.
More efficient than polling-based alternatives because it uses server-push semantics; more integrated than generic webhook solutions because it maintains stateful subscriptions within the MCP session.
authentication and authorization context propagation
Medium confidenceManages Supabase authentication tokens and row-level security (RLS) context within MCP tool execution. Implements token refresh logic and passes user identity through to PostgreSQL via Supabase's JWT claims, ensuring database operations respect RLS policies defined at the table/row level. Handles both service-role (unrestricted) and user-scoped (RLS-enforced) authentication modes.
Propagates Supabase JWT claims directly into PostgreSQL session context via the `Authorization` header, allowing RLS policies to evaluate user identity at query time. Implements token lifecycle management (refresh, expiry) within the MCP server, not delegating to the client.
More secure than application-level filtering because RLS is enforced at the database layer; more integrated than generic auth middleware because it uses Supabase's native JWT and claims model.
supabase storage file operations (upload, download, delete)
Medium confidenceExposes Supabase Storage buckets as MCP resources with file management capabilities. Implements multipart upload handling for large files, signed URL generation for secure access, and metadata tracking. Uses Supabase's Storage API client to abstract S3-compatible operations, handling bucket policies and public/private access control.
Integrates Supabase Storage's S3-compatible API with MCP semantics, providing bucket-level isolation and signed URL generation without exposing raw storage credentials. Handles multipart uploads transparently, abstracting S3 complexity from the MCP client.
Simpler than direct S3 integration because it uses Supabase's managed buckets and RLS-compatible access control; more secure than exposing storage keys to agents because it uses signed URLs with time-limited access.
vector similarity search via pgvector integration
Medium confidenceExposes Supabase's pgvector extension as MCP tools for semantic search and similarity queries. Implements vector embedding storage in PostgreSQL and provides cosine/L2 distance-based search through MCP tool calls. Integrates with embedding providers (OpenAI, Hugging Face) or accepts pre-computed embeddings, storing them in vector columns and querying via SQL operators.
Leverages PostgreSQL's native pgvector extension for vector operations, avoiding external vector databases and keeping embeddings co-located with relational data. Implements similarity search through standard SQL, enabling hybrid queries that combine vector distance with traditional WHERE clauses.
More integrated than separate vector databases (Pinecone, Weaviate) because vectors live in the same PostgreSQL instance as relational data; more flexible than embedding-only services because it supports arbitrary metadata filtering alongside similarity search.
edge function invocation and result streaming
Medium confidenceExposes Supabase Edge Functions as MCP tools, allowing agents to invoke serverless functions deployed on Supabase's edge network. Implements HTTP request/response translation through the MCP protocol, handling function authentication, timeout management, and streaming responses. Supports both synchronous calls and long-running operations with status polling.
Wraps Supabase Edge Functions (Deno-based serverless) as MCP tools, translating HTTP semantics into the MCP protocol. Handles authentication and timeout management transparently, allowing agents to invoke functions without knowing HTTP details.
More integrated than generic HTTP tools because it uses Supabase's native authentication and edge network; more flexible than embedding all logic in the MCP server because functions can be deployed and updated independently.
schema introspection and capability discovery
Medium confidenceAutomatically discovers Supabase database schema (tables, columns, types, relationships) and exposes them as MCP resource definitions. Implements schema caching with optional refresh, generating tool descriptions and parameter schemas dynamically from PostgreSQL information_schema. Enables agents to understand available data structures without hardcoded tool definitions.
Queries PostgreSQL information_schema to generate MCP tool definitions at runtime, avoiding hardcoded tool lists. Implements schema caching with optional refresh, balancing startup performance against schema staleness.
More maintainable than manual tool definition because schema changes are reflected automatically; more flexible than static tool lists because it adapts to per-tenant or per-environment schema variations.
transaction management and multi-step operations
Medium confidenceProvides MCP tools for managing PostgreSQL transactions, allowing agents to group multiple database operations into atomic units. Implements transaction lifecycle management (BEGIN, COMMIT, ROLLBACK) through MCP calls, with support for savepoints and isolation level configuration. Ensures consistency for complex workflows that require all-or-nothing semantics.
Exposes PostgreSQL transaction semantics (ACID guarantees, savepoints, isolation levels) through MCP tools, allowing agents to reason about consistency without raw SQL. Implements transaction state tracking within the MCP server to prevent accidental commits or rollbacks.
More reliable than application-level consistency checks because it leverages PostgreSQL's ACID guarantees; more explicit than implicit transactions because agents can see and control transaction boundaries.
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-supabase, ranked by overlap. Discovered automatically through the match graph.
SchemaCrawler
** - Connect to any relational database, and be able to get valid SQL, and ask questions like what does a certain column prefix mean.
@benborla29/mcp-server-mysql
MCP server for interacting with MySQL databases with write operations support
user-postgresql-mcp
A PostgreSQL MCP server built with @modelcontextprotocol/sdk.
@iflow-mcp/garethcott_enhanced-postgres-mcp-server
Enhanced PostgreSQL MCP server with read and write capabilities. Based on @modelcontextprotocol/server-postgres by Anthropic.
mysql_mcp_server
A Model Context Protocol (MCP) server that enables secure interaction with MySQL databases
Teradata
** - A collection of tools for managing the platform, addressing data quality and reading and writing to [Teradata](https://www.teradata.com/) Database.
Best For
- ✓AI agent developers building autonomous workflows against Supabase backends
- ✓Teams integrating Supabase with Claude via MCP for data-driven decision making
- ✓Developers wanting to sandbox database access through protocol-level constraints
- ✓Real-time AI agents that need to respond to live data changes
- ✓Collaborative applications where multiple agents need synchronized state
- ✓Event-driven workflows triggered by database mutations
- ✓Multi-tenant applications where agents must respect user isolation
- ✓Security-sensitive workflows where RLS enforcement is non-negotiable
Known Limitations
- ⚠No built-in query optimization — complex joins or aggregations may require custom SQL tools
- ⚠Row-level security (RLS) policies are enforced at the Supabase level but not explicitly surfaced in capability descriptions
- ⚠Batch operations are sequential, not bulk-optimized — each mutation is a separate transaction
- ⚠No support for stored procedures or custom functions through the standard CRUD interface
- ⚠Realtime subscriptions require Supabase Realtime service to be enabled and configured
- ⚠WebSocket connections are stateful — reconnection logic must handle network interruptions
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.
Package Details
About
MCP server for interacting with Supabase
Categories
Alternatives to @supabase/mcp-server-supabase
Are you the builder of @supabase/mcp-server-supabase?
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 →