mcp-supabase
0
The Supabase MCP Server is designed to connect with a Supabase PostgreSQL database, allowing users to expose table schemas as resources and utilize a suite of tools for data analysis. It supports integration with MCP-compatible clients, offering a robust solution for data management.
Supabase MCP Server
An MCP server connecting to a Supabase PostgreSQL database 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 the repository.
- Install dependencies.
- Configure environment variables for Supabase credentials.
Running the Server
- Command line: Use stdio with
npm start. - Web integration: Use HTTP with SSE using
npm run start:http.
Using with MCP Clients
Compatible with any MCP client, like Claude.app and MCP Inspector.
Available Resources
- List all tables:
schema://tables - Show schema for a table:
schema://table/{tableName}
Available Tools
- Run SQL query:
query - Get table statistics:
analyze-table - Discover related tables:
find-related-tables
Available Prompts
- Table exploration:
table-exploration - Data summary:
data-summary - Relationship analysis:
relationship-analysis