About Supabase MCP Server
Supabase MCP Server connects MCP clients to a Supabase PostgreSQL database for read-only analysis. It exposes table schemas, query and analysis tools, and prompts for exploring data and relationships.
Key features
- 01Connects to Supabase PostgreSQL
- 02Exposes table schemas as resources
- 03Runs read-only SQL queries
- 04Provides table analysis tools
- 05Includes data analysis prompts
Use cases
- 01Inspect table structures
- 02Query data without modifying it
- 03Summarize a table's data
- 04Explore relationships between tables
MCP support
It exposes database schemas as resources, read-only query and analysis tools, and data-analysis prompts to MCP clients.
Configuration
Local server config is the same for every client. Copy it into your client’s MCP config file.
We haven’t collected a package or remote endpoint for this server. Follow the instructions in the project README.
Tools
Local servers expose tools only once running on your machine, and the maintainer has not provided a tool list.
Details
From the project READMESupabase MCP Server
An MCP server that connects to a Supabase PostgreSQL database, exposing table schemas as resources and providing tools for data analysis.
Features
- Connection to Supabase PostgreSQL database
- Table schemas exposed as resources
- Read-only SQL query tools
- Prompts for common data analysis tasks
Setup
- Clone this repository
- Install dependencies:
npm install - Copy
.env.exampleto.envand update with your Supabase credentials:cp .env.example .env - Edit the
.envfile with your actual Supabase connection details
Running the Server
Using stdio (command line integration)
npm start
Using HTTP with SSE (for web integration)
npm run start:http
Using with MCP Clients
This server can be used with any MCP-compatible client, including Claude.app and the MCP Inspector for testing.
Available Resources
schema://tables- Lists all tables in the databaseschema://table/{tableName}- Shows schema for a specific table
Available Tools
query- Runs a read-only SQL query against the databaseanalyze-table- Gets basic statistics about a tablefind-related-tables- Discovers tables related to a given table
Available Prompts
table-exploration- Guides exploration of a specific tabledata-summary- Creates a summary of data in a tablerelationship-analysis- Analyzes relationships between tables
Comments
New to MCP?
From what the protocol is to installing your first server, these answers cover most first questions.
An open protocol that defines how AI applications connect to external tools and data in a uniform way. Clients talk to the model; MCP servers provide tools, resources and prompt templates. They exchange standard messages, so one server can be reused by many clients.