Supabase MCP Server
by supabase-community
The Supabase MCP Server connects your Supabase projects to AI assistants like Cursor and Claude. It allows these assistants to interact with your Supabase project, performing tasks such as managing tables and querying data.
Last updated: N/A
What is Supabase MCP Server?
The Supabase MCP Server is an implementation of the Model Context Protocol (MCP) that enables Large Language Models (LLMs) to interact with Supabase projects. It acts as a bridge, allowing AI assistants to perform various tasks on your Supabase database and project.
How to use Supabase MCP Server?
To use the server, you need to generate a personal access token (PAT) from your Supabase account. Then, configure your MCP client (e.g., Cursor) with the server's command and arguments, including the PAT. You can also set the SUPABASE_ACCESS_TOKEN environment variable. Ensure Node.js is installed and accessible. For Windows, prefix the command with cmd /c or wsl if using WSL.
Key features of Supabase MCP Server
Connects Supabase projects to LLMs
Enables AI assistants to manage tables and query data
Supports project management operations (create, pause, restore)
Provides database operation tools (list tables, execute SQL, apply migrations)
Offers project configuration access (API URL, anon key)
Supports branching operations (experimental)
Includes development tools like TypeScript type generation
Offers cost confirmation for new projects and branches
Supports read-only mode for database queries
Use cases of Supabase MCP Server
Allowing AI assistants to generate SQL queries for your Supabase database.
Enabling AI to manage your Supabase project, such as creating new projects or branches.
Using AI to apply database migrations.
Integrating Supabase data into AI-powered applications.
Automating database management tasks with AI.
FAQ from Supabase MCP Server
What is the Model Context Protocol (MCP)?
What is the Model Context Protocol (MCP)?
MCP standardizes how Large Language Models (LLMs) talk to external services like Supabase.
How do I get a personal access token (PAT)?
How do I get a personal access token (PAT)?
Go to your Supabase settings and create a personal access token.
How do I configure my MCP client?
How do I configure my MCP client?
Most MCP clients store the configuration as JSON, including the command and arguments for the Supabase MCP server.
Can I restrict the server to read-only queries?
Can I restrict the server to read-only queries?
Yes, set the --read-only flag on the CLI command.
What tools are available to the LLM?
What tools are available to the LLM?
The server provides tools for project management, database operations, project configuration, branching, development, and cost confirmation.