Supabase MCP
by Supabase
AI-powered Supabase project management with database, functions, and storage
database Node.js Intermediate Verified
⭐ 2.5k stars 📅 Updated: 1mo ago
Description
MCP server for AI assistants to interact with Supabase projects. Provides comprehensive tools for database queries, schema management, SQL migrations, Edge Functions deployment, TypeScript type generation, and storage bucket management. Available as a remote endpoint at mcp.supabase.com using OAuth 2.1 authentication. Includes safety features like read-only mode for production databases, project scoping to limit access, and prompt injection protections. Enables AI assistants to manage the full Supabase stack — from Postgres queries to deploying serverless functions and managing file storage.
✅ Best for
Teams using Supabase who want AI assistants to manage their backend infrastructure
⏭️ Skip if
You need a generic Postgres client or use a different backend-as-a-service
💡 Use cases
- Querying and managing Postgres databases from AI assistants
- Running SQL migrations and managing database schemas with AI guidance
- Deploying and managing Supabase Edge Functions via natural language
- Generating TypeScript types from database schema for frontend development
👍 Pros
- ✓ Full Supabase stack coverage — database, functions, storage, and types
- ✓ Read-only mode and project scoping for production safety
- ✓ OAuth 2.1 remote endpoint — no local installation required
- ✓ Prompt injection protections for secure AI interactions
👎 Cons
- ✗ Remote-only — no local STDIO package available
- ✗ Requires OAuth 2.1 setup which adds initial configuration steps
- ✗ Limited to Supabase platform — not a generic Postgres MCP server
🔧 Exposed tools (9 tools)
| Tool | Category | Description |
|---|---|---|
| execute_sql | database | Execute SQL queries against a Supabase Postgres database |
| manage_schema | database | View and modify database schema, tables, and columns |
| deploy_edge_functions | deployment | Deploy serverless Edge Functions to Supabase |
| generate_types | development | Generate TypeScript types from the database schema |
| search_docs | documentation | Search Supabase documentation for reference |
| list_projects | management | List all Supabase projects accessible to the user |
| create_project | management | Create a new Supabase project |
| get_logs | monitoring | Retrieve logs from Supabase services |
| manage_storage | storage | Manage storage buckets and files |
⚡ Installation
Prerequisites:
- • Node.js v18+
- • Supabase access token (OAuth 2.1)
- • API key required
Check Claude Code documentation to configure this MCP server.
💡 Tips & tricks
Enable read-only mode when connecting to production databases to prevent accidental writes. Use project scoping to restrict which Supabase projects the AI can access. The search_docs tool is great for finding Supabase documentation while working.
🔄 Alternatives
Quick info
- Author
- Supabase
- License
- Apache-2.0
- Runtime
- Node.js 18+
- Transport
- —
- Category
- database
- Difficulty
- Intermediate
- Self-hostable
- ❌
- Auth
- —
- Docker
- —
- Version
- latest
- Updated
- Feb 28, 2026
Client compatibility
- ✅ Claude Code
- ✅ Cursor
- ✅ VS Code Copilot
- ❓ Gemini CLI
- ❓ Windsurf
- ❓ Cline
- ❓ JetBrains AI
- ❓ Warp
Platforms
🍎 macOS 🐧 Linux 🪟 Windows