mcp-supabase

# 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