Official Supabase MCP server for database management
## Supabase MCP Server: The Open Source Firebase Alternative The **Supabase MCP Server** provides seamless integration between Google Antigravity and Supabase, the popular open-source Firebase alternative. Execute SQL queries, manage authentication, interact with real-time subscriptions, and handle storage—all through natural language commands from your IDE. ### Why Supabase MCP? Supabase has become the go-to backend-as-a-service for modern applications, offering: - **PostgreSQL Database**: Full SQL database with Row Level Security - **Authentication**: Built-in auth with 20+ providers - **Real-time Subscriptions**: Live data updates via WebSockets - **Edge Functions**: Serverless TypeScript functions - **Storage**: S3-compatible file storage - **Vector Search**: AI embeddings and similarity search The Supabase MCP brings all these capabilities directly into your development workflow. ### Key Features #### 1. SQL Query Execution Run SQL queries with natural language: ``` "Show me all users who signed up this week" "Create a table for blog posts with title, content, and author" "Add an index on the email column for faster lookups" "Update the user's subscription status to premium" ``` The MCP handles: - Query execution with proper parameterization - Result formatting for easy reading - Error handling with helpful messages - Transaction support for complex operations #### 2. Schema Management Manage your database schema: - Create and modify tables - Define relationships and foreign keys - Set up Row Level Security policies - Manage indexes and constraints ``` "Add a foreign key from posts to users" "Enable RLS on the profiles table" "Create a policy that lets users only see their own data" ``` #### 3. Authentication Operations Interact with Supabase Auth: - List and manage users - Configure auth providers - Handle password resets - Manage user metadata ``` "Show me all users with unverified emails" "Disable the user with email john@example.com" "List all configured auth providers" ``` #### 4. Storage Management Work with Supabase Storage: - Create and manage buckets - Upload and download files - Generate signed URLs - Set access policies ``` "Create a public bucket for user avatars" "List all files in the documents bucket" "Generate a download URL for report.pdf" ``` #### 5. Edge Functions Deploy and manage serverless functions: - List deployed functions - View function logs - Check function performance - Manage environment variables ### Configuration Set up the Supabase MCP: ```json { "mcpServers": { "supabase": { "command": "npx", "args": ["-y", "@supabase/mcp-server"], "env": { "SUPABASE_URL": "https://your-project.supabase.co", "SUPABASE_SERVICE_ROLE_KEY": "your-service-role-key" } } } } ``` ### Security Best Practices #### Use Service Role Carefully The service role key bypasses RLS. Use it only when necessary: - **Development**: Service role for schema management - **Production**: Anon key for client operations - **Testing**: Separate test project with service role #### Row Level Security Always enable RLS on sensitive tables: ``` "Enable RLS on the orders table" "Create a policy: users can only read their own orders" ``` #### Secure Your Keys - Store keys in environment variables - Never commit keys to version control - Rotate keys if compromised - Use separate keys for dev/staging/prod ### Common Workflows #### Setting Up a New Feature ``` 1. "Create a tasks table with id, user_id, title, completed, created_at" 2. "Add a foreign key from tasks.user_id to auth.users.id" 3. "Enable RLS on tasks" 4. "Create policies for users to manage their own tasks" 5. "Create an index on user_id for faster queries" ``` #### Data Analysis ``` 1. "Show me signup trends by day for the last month" 2. "What's the average order value by user tier?" 3. "Find all inactive users who haven't logged in for 30 days" ``` #### Debugging Issues ``` 1. "Show me the recent error logs from edge functions" 2. "List all failed authentication attempts today" 3. "Find duplicate entries in the users table" ``` ### Advanced Features #### Real-time Subscriptions Monitor data changes: ``` "Set up a listener for new orders" "Subscribe to changes in the inventory table" ``` #### Database Functions Create and call PostgreSQL functions: ``` "Create a function to calculate order totals" "Call the cleanup_old_sessions function" ``` #### Full-text Search Leverage PostgreSQL full-text search: ``` "Search blog posts containing 'machine learning'" "Add a full-text search index on the articles table" ``` ### Integration with Development The Supabase MCP integrates with your workflow: - **Type Generation**: Generate TypeScript types from schema - **Migrations**: Create and apply database migrations - **Seed Data**: Insert test data for development - **Backup**: Export and restore data ### Performance Optimization Use the MCP to optimize your database: - Analyze query performance - Identify missing indexes - Monitor connection usage - Review slow query logs ``` "Analyze the performance of this query" "Suggest indexes for the products table" "Show me the slowest queries from the last hour" ``` ### Troubleshooting Common issues: - **Connection Failed**: Check URL and keys - **Permission Denied**: Verify RLS policies - **Timeout**: Optimize slow queries - **Rate Limited**: Check API usage limits The Supabase MCP Server transforms database management into a conversational experience, making backend development faster and more intuitive than ever.
{
"mcpServers": {
"supabase": {
"mcpServers": {
"supabase": {
"env": {
"SUPABASE_ACCESS_TOKEN": "YOUR_SUPABASE_ACCESS_TOKEN"
},
"args": [
"-y",
"@supabase/mcp-server-supabase@latest",
"--read-only"
],
"command": "npx"
}
}
}
}
}