MCP Supabase Server
v0.x (supabase/mcp monorepo, pre-1.0)Supabase
Official Supabase MCP server: SQL execution, schema/migrations, type generation, Edge Function deploys, logs, storage, branching. Primarily a hosted remote at https://mcp.supabase.com/mcp with OAuth 2.1 dynamic client registration (PAT only for CI/CD), plus stdio and self-hosted modes. After 2025 prompt-injection/data-leak research, Supabase added mitigations: read-only mode, project_ref scoping, feature-group tool restrictions, and wrapping SQL results to deter embedded commands.
Trust Vector Analysis
Dimension Breakdown
๐Performance & Reliability+
API stability and uptime analysis
Query execution testing
Schema management testing
Type generation testing
Real-time functionality testing
๐ก๏ธSecurity+
Authentication mechanism review
RLS implementation review
Prompt-injection and SQL execution risk assessment; lowered from 78 because the attack class was demonstrated in practice โ mitigations reduce but do not eliminate the risk when the agent reads untrusted data with write or broad read access
Encryption review
Key management review; raised from 75 as the default auth path no longer places a full-access service role key in client configuration
๐Privacy & Compliance+
Data residency review
GDPR compliance review
Data flow analysis
Self-hosting options review
๐๏ธTrust & Transparency+
Documentation completeness review
Source code review; minor adjustment from 95 โ previous evidence cited the platform repo rather than the MCP server, which remains pre-1.0
Logging capabilities assessment
Community engagement analysis
โ๏ธOperational Excellence+
Setup complexity assessment; small raise from 90 as the hosted OAuth flow removed manual key handling
Developer experience assessment
Scalability testing
Cost analysis
Integration ecosystem review
- +Full PostgreSQL power with AI-assisted query building, migrations, and type generation
- +Hosted remote server with OAuth 2.1 dynamic client registration โ no manual key handling
- +Layered security controls: read-only mode, project scoping, and feature-group tool restrictions
- +Prompt-injection mitigations wrap SQL results to discourage the LLM from obeying embedded commands
- +Development-branch workflow lets agents work against non-production data
- +Fully open source (Apache 2.0) with outstanding documentation and active community
- !Demonstrated 2025 prompt-injection/data-leak attack class: instructions hidden in database rows can subvert agents given broad SQL access
- !Query results and schema exposed to LLM provider
- !AI can execute potentially destructive SQL unless read-only mode is enabled
- !Supabase recommends avoiding production data: use development branches, project scoping, and manual tool-call approval
- !Pre-1.0 server: breaking changes possible between versions
- !OAuth hosted mode has limited functionality for CLI/self-hosted environments
Use Case Ratings
code generation
Excellent for full-stack development with auto-generated types
customer support
Good for building support ticket systems and user management
content creation
Great for CMS backends and content management
data analysis
Full SQL power for complex data analysis queries
research assistant
Good for building research databases and knowledge bases
legal compliance
RLS and audit logging support compliance requirements
healthcare
Self-hosted option needed; requires careful RLS configuration
financial analysis
Strong for financial data storage with proper access controls
education
Excellent for learning SQL and building educational apps
creative writing
Good for storing and organizing creative content