# 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