# 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