Supabase MCP Server
About
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.
Details
- Author
- stefanraath3
- Downloads
- 632
- Categories
- Cloud Service
Jump to
- 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
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.
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
1. Clone this repository
2. Install dependencies:
npm install
3. Copy
.env.example to .env and update with your Supabase credentials: cp .env.example .env
4. Edit the
.env file 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 database
- schema://table/{tableName} - Shows schema for a specific table
Available Tools
- query - Runs a read-only SQL query against the database
- analyze-table - Gets basic statistics about a table
- find-related-tables - Discovers tables related to a given table
Available Prompts
- table-exploration - Guides exploration of a specific table
- data-summary - Creates a summary of data in a table
- relationship-analysis - Analyzes relationships between tables
Sign in to leave a review
Use Google, GitHub, or an email account so ratings stay tied to real people.
No reviews posted yet.
