Supabase 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