Supabase MCP Server 🚀

What is Supabase MCP Server?

Supabase MCP Server is a Model Context Protocol server that provides full administrative control over a Supabase PostgreSQL database through natural language commands. It integrates with Cursor’s Composer and Codeium’s Cascade, enabling developers to manage tables, records, indexes, functions, security policies, storage, and more directly from their IDE.

How to use Supabase MCP Server?

Install dependencies with npm install && npm run build, then configure the server in Cursor’s MCP settings or in Codeium’s ~/.codeium/windsurf/mcp_config.json. The command uses a PostgreSQL connection string in the format postgresql://postgres.[PROJECT-ID]:[PASSWORD]@aws-0-eu-central-1.pooler.supabase.com:5432/postgres. Once set up, describe database tasks in natural language (e.g., "list all tables") and the AI will execute the corresponding tools.

Key features of Supabase MCP Server

• Full suite of database management tools (tables, records, indexes, constraints, functions, triggers, policies, roles)
• Storage bucket and file management
• Realtime features: policies, channels, messages, status
• User authentication management (list, create, update, delete)
• Direct SQL query execution
• Works with both Cursor Composer and Codeium Cascade

Use cases of Supabase MCP Server

• Quickly create or modify database tables without leaving the IDE
• Add indexes and constraints to optimize query performance
• Manage row-level security policies and user roles
• Handle Supabase Storage buckets and files
• Send realtime messages and manage channels

FAQ from Supabase MCP Server

What are the prerequisites to use Supabase MCP Server?

Node.js >= 16.x, npm >= 8.x, a Supabase project with its Project ID, database password, and PostgreSQL connection string, and either Cursor IDE or Codeium’s Cascade (paying users only for Cascade).

How do I install and configure Supabase MCP Server?

Clone the repository, run npm install and npm build, then add the server command to Cursor’s MCP settings or Windsurf’s mcp_config.json. The command includes the full path to Node.js, the built dist/index.js, and your Supabase connection string.

Is Supabase MCP Server secure?

Yes, but keep your database connection string secure and never commit credentials to version control. Use appropriate access controls and sanitize all inputs to prevent SQL injection.

What transport and auth does Supabase MCP Server use?

It uses stdio transport (command-line) and authenticates via the PostgreSQL connection string you provide. No additional authentication or environment variables are required beyond the connection string.

Which IDEs or editors are supported?

Cursor (with Composer) and Codeium’s Cascade (Windsurf). For Cascade, only paying individual users can use the MCP integration; Teams and Enterprise are not supported.