Supabase MCP Server

What is Supabase MCP Server?

Supabase MCP Server is an MCP server that connects to a Supabase PostgreSQL database, exposing table schemas as resources and providing tools for data analysis. It is designed for users who want to interact with their Supabase database through MCP-compatible clients.

How to use Supabase MCP Server?

Clone the repository, install dependencies with npm install, copy .env.example to .env and update with Supabase credentials. Run with npm start for stdio integration or npm run start:http for HTTP with SSE. Use with any MCP-compatible client.

Key features of Supabase MCP Server

• Connects to Supabase PostgreSQL database
• Table schemas exposed as resources
• Read-only SQL query tools
• Prompts for common data analysis tasks
• Supports both stdio and HTTP/SSE transports

Use cases of Supabase MCP Server

• Exploring table schemas in a Supabase database
• Running read-only queries for data analysis
• Analyzing relationships between database tables
• Generating data summaries via prompts

FAQ from Supabase MCP Server

Is the SQL query tool read-only?

Yes, the query tool runs read-only SQL queries against the database.

What transport options are available?

It supports stdio (command line) with npm start and HTTP with SSE (web integration) with npm run start:http.

How are credentials configured?

Copy .env.example to .env and edit with your actual Supabase connection details.

What resources are provided?

Resources include schema://tables (lists all tables) and schema://table/{tableName} (schema for a specific table).