Supabase MCP Server
remote-capable server
The server can be hosted and run remotely because it primarily relies on remote services or has no dependency on the local environment.
Integrations
Enables read-only SQL queries against a PostgreSQL database, with tools for analyzing table statistics and relationships between tables
Connects to a Supabase PostgreSQL database, exposing table schemas as resources and providing tools for data analysis, SQL querying, and relationship exploration
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:
- Copy
.env.example
to.env
and update with your Supabase credentials: - Edit the
.env
file with your actual Supabase connection details
Running the Server
Using stdio (command line integration)
Using HTTP with SSE (for web integration)
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
This server cannot be installed
An MCP server that connects to Supabase PostgreSQL databases, exposing table schemas as resources and providing tools for data analysis through SQL queries.