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