Supabase MCP Server

What it does

The Supabase MCP Server provides your AI coding assistant with direct access to the Supabase management API and your project databases. It can list projects, execute SQL queries, inspect table schemas, and apply database migrations -- making it a powerful tool for full-stack development with Supabase.

This is Supabase's official MCP server, designed to work seamlessly with their platform. It goes beyond simple database access by supporting project management operations like listing projects, checking configurations, and applying schema migrations.

Use cases

• Execute SQL queries to explore your database schema and data during development
• Apply database migrations as part of your development workflow
• List and inspect tables to inform AI-generated data access code
• Manage multiple Supabase projects from your editor
• Generate TypeScript types based on your actual database schema
• Debug data issues by querying production data directly

Getting started

1. Generate a Supabase Access Token at supabase.com/dashboard/account/tokens. This token provides access to all projects in your account.
2. Set the SUPABASE_ACCESS_TOKEN environment variable to your token value.
3. The server provides access to all Supabase projects associated with your account. Specify project references when executing queries or managing specific projects.
4. For database migrations, ensure your local Supabase CLI is configured and your migration files are in the standard supabase/migrations directory.