Supabase MCP Integration Guide

The Supabase MCP server lets your AI assistant manage Supabase projects, databases, authentication, and storage directly.

Capabilities

• List and manage projects
• View project details
• Manage database tables
• Configure authentication
• Monitor storage

Setup

Generate a Supabase access token from your Supabase dashboard.

Visit our Supabase MCP page or use:

{"mcpServers":{"supabase":{"command":"npx","args":["-y","@modelcontextprotocol/server-supabase"],"env":{"SUPABASE_ACCESS_TOKEN":"sbp_..."}}}}

Usage

“Show me all my Supabase projects” or “Get details on my production project.” Your AI becomes a Supabase admin.

Supercharging Your BaaS Workflow

Supabase provides an incredible backend-as-a-service, and tying it to an MCP server gives your local AI direct access to your database, edge functions, and authentication logs. This setup excels for rapid prototyping. You can instruct your AI to define a new table schema, apply the Postgres policies, and instantly generate the corresponding TypeScript types for your frontend.

When configuring the connection, utilize the Supabase service role key with extreme caution. The service role key bypasses Row Level Security (RLS) entirely. A safer approach for daily development is to use a standard authenticated user session or to explicitly define database functions that the MCP server is allowed to execute, thereby enforcing RLS even when the AI is driving the queries.