MCP Supabase

Supabase MCP Server is a tool that connects Supabase projects with AI assistants (such as Cursor, Claude, etc.), enabling AI assistants to directly manage database tables, query data, and perform other functions through the Model Context Protocol standard.

Developer tools Database #Database connection #AI integration #Project management .TypeScript

rating : 2 points

downloads : 8.9K

update time : 2025-04-28

Open Site

What is Supabase MCP Server?

Supabase MCP Server is a middleware service based on the Model Context Protocol (MCP), which allows AI assistants (such as Cursor/Claude) to interact securely with your Supabase projects. Through standardized interfaces, AI can perform operations such as database queries, table structure management, and edge function deployment without directly exposing database credentials.

How to use Supabase MCP Server?

Simply configure the server startup command in the AI client and provide your Supabase personal access token. The server supports multiple security modes, including project isolation and read-only mode, ensuring that AI assistants can only operate within the authorized scope.

Applicable scenarios

Suitable for scenarios such as development assistance (automatically generating SQL/type definitions), production environment monitoring (log queries), and team collaboration (branch management). It is particularly suitable for teams that require AI assistance in database development.

Main features

Project management

View/create/pause Supabase projects and obtain organization information (account-level permissions required).

Database operations

Execute SQL queries, manage table structure changes, and view extension and migration records.

Edge functions

Deploy and manage edge functions, supporting JavaScript/TypeScript code.

Branch management (experimental)

Create development branches, merge changes, and resolve migration conflicts (paid plan required).

Type generation

Automatically generate TypeScript type definitions for front-end development.

Advantages

Standardized interface: Unify the interaction between AI and Supabase through the MCP protocol.

Fine-grained permission control: Support project isolation and read-only mode to ensure security.

Development efficiency: AI can automatically complete repetitive database operations.

Multi-client support: Compatible with mainstream AI development tools such as Cursor/Claude.

Limitations

Pre-release stage: Interface changes may occur before version 1.0.

Windows compatibility: Additional configuration of the PATH environment variable is required.

Branch function: Experimental features require a paid plan.

How to use

Get an access token

Create a personal access token (PAT) on the [Account Settings → Tokens] page of the Supabase dashboard.

Configure the client

Add the MCP server startup command to the AI assistant configuration (see the example on the right).

Security mode (optional)

Add --project-ref to limit the project scope, or --read-only to enable read-only mode.

Usage examples

Database design assistance

AI automatically creates database table structures based on natural language descriptions.

Production problem diagnosis

Query recent error logs to analyze API performance issues.

Type-safe development

Automatically generate front-end TypeScript type definitions.

Frequently asked questions

What if the access token is leaked?

Can't start the server on Windows?

How to confirm the change cost?

What SQL operations can AI perform?

Related resources

MCP Protocol official website

Learn about the standard specifications of the Model Context Protocol.

Supabase Token Management

Create and manage personal access tokens.

PostgREST MCP Server

A REST API solution for connecting users' own applications.

🚀 Supabase MCP Server

The Supabase MCP Server enables Large Language Models (LLMs) to interact directly with Supabase projects without human intervention. Through the Model Context Protocol (MCP), LLMs can securely perform complex database operations, manage edge functions, configure project settings, etc.

🚀 Quick Start

📦 Installation

Install Dependencies

Ensure you have Node.js and npm installed:

npm install -g node

Obtain API Keys

Get the anon public key and management key from your Supabase project.

Start the Server

Run the following command in the terminal to start the MCP server:

npx supabase-mcp-server --anon-key=your_anon_key --api-key=your_api_key

⚠️ Important Note

Pre-release Version: This server is in the pre-1.0 stage, and there may be some breaking changes. Since LLMs automatically adapt to available tools, this has little impact on most users.
Generate TypeScript Types: The generate_typescript_types tool can generate TypeScript types based on the database schema. LLMs can save these types to a file and use them in the code.

✨ Features

Here is a list of Supabase tools available for LLMs:

Project Management

Note: The following tools are unavailable if the server is [scoped to a specific project](#Project Scope Mode).

list_projects: List all the user's Supabase projects.
get_project: Get detailed information about a specified project.
create_project: Create a new Supabase project.
pause_project: Pause a specified project.
restore_project: Restore a paused project.
list_organizations: List all the organizations the user belongs to.
get_organization: Get detailed information about a specified organization.

Database Operations

list_tables: List all tables in a specific schema.
list_extensions: List all extensions in the database.
list_migrations: List all migrations in the database.
apply_migration: Migrate SQL to the database. LLMs should use this tool for DDL operations (schema changes).
execute_sql: Execute raw SQL queries on the database. LLMs should use this tool for regular queries without changing the schema.
get_logs: Get the logs of a Supabase project based on the service type (api, postgres, edge functions, authentication, storage, real-time). LLMs can use this tool to help debug and monitor service performance.

Edge Function Management

list_edge_functions: List all edge functions in a project.
deploy_edge_function: Deploy a new edge function to a Supabase project. LLMs can use this tool to deploy new features or update existing ones.