Supabase MCP Server 3mh

🚀 Supabase MCP Server

An MCP server that connects to a Supabase PostgreSQL database, exposes database table schemas as resources, and provides data analysis tools.

✨ Features

• Connect to a Supabase PostgreSQL database.
• Expose table schemas as resources.
• Provide a read-only SQL query tool.
• Offer common data task prompts.

📦 Installation and Configuration

1. Clone this repository.
2. Install dependencies:

   npm install
   

3. Copy .env.example to .env and update it with your Supabase credentials:

   cp .env.example .env
   

4. Edit the .env file with your actual Supabase connection information.

🚀 Quick Start

Using stdio (Command-line Integration)

npm start

Using HTTP with SSE (For Web Integration)

npm run start:http

💻 Usage Examples

This server can be used with any compatible MCP client, including Claude.app and MCP Inspector for testing.

Available Resources

• schema://tables - List all tables in the database.
• schema://table/{tableName} - Show the schema of a specific table.

Available Tools

• query - Execute read-only SQL queries against the database.
• analyze-table - Get basic statistics for a table.
• find-related-tables - Discover tables related to a given table.

Available Prompts

• table-exploration - Guide the exploration of a specific table.
• data-summary - Create a summary of table data.
• relationship-analysis - Analyze relationships between tables.