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

Clone this repository
Install dependencies:
npm install
Copy .env.example to .env and update with your Supabase credentials:
cp .env.example .env
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

This server cannot be installed

security - not tested

license - permissive license

quality - not tested

remote-capable server

The server can be hosted and run remotely because it primarily relies on remote services or has no dependency on the local environment.

An MCP server that connects to Supabase PostgreSQL databases, exposing table schemas as resources and providing tools for data analysis through SQL queries.

Related Resources

Reddit Discussion about this server

Related MCP Servers

supabase-mcp
DynamicEndpoints
A
security
A
license
A
quality
An MCP server that provides tools for interacting with Supabase databases, storage, and edge functions.
Last updated -
14
41
JavaScript
MIT License
PostgREST
supabase-community
-
security
A
license
-
quality
This is an MCP server for PostgREST. It allows LLMs perform database queries and operations on Postgres databases via PostgREST. This server works with both Supabase projects (which use PostgREST) and standalone PostgREST servers.
Last updated -
301
1,487
TypeScript
Apache 2.0
Supabase MCP Server
alexander-zuev
A
security
A
license
A
quality
This server enables interaction with Supabase PostgreSQL databases through the MCP protocol, allowing seamless integration with Cursor and Windsurf IDEs for secure and validated database management.
Last updated -
11
699
Python
Apache 2.0
Yazdani-Supabase-MCP Server
byazdani9
-
security
A
license
-
quality
An MCP server that enables natural language querying of Supabase PostgreSQL databases using Claude 3.7, allowing users to inspect schemas, execute SQL, manage migrations, and convert natural language to SQL queries.
Last updated -
Python
MIT License

View all related MCP servers

Supabase MCP Server