Self-Hosted Supabase MCP Server
Overview
This project provides a Model Context Protocol (MCP) server designed specifically for interacting with self-hosted Supabase instances. It bridges the gap between MCP clients (like IDE extensions) and your local or privately hosted Supabase projects, enabling database introspection, management, and interaction directly from your development environment.
This server was built from scratch, drawing lessons from adapting the official Supabase cloud MCP server, to provide a minimal, focused implementation tailored for the self-hosted use case.
Purpose
The primary goal of this server is to enable developers using self-hosted Supabase installations to leverage MCP-based tools for tasks such as:
- Querying database schemas and data.
- Managing database migrations.
- Inspecting database statistics and connections.
- Managing authentication users.
- Interacting with Supabase Storage.
- Generating type definitions.
It avoids the complexities of the official cloud server related to multi-project management and cloud-specific APIs, offering a streamlined experience for single-project, self-hosted environments.
Features (Implemented Tools)
Tools are categorized by privilege level:
- Regular tools are accessible by any authenticated Supabase JWT (
authenticated or service_role role).
- Privileged tools require a
service_role JWT (HTTP mode) or direct database/service-key access (stdio mode).
Schema & Migrations
| Tool | Description | Privilege |
|------|-------------|-----------|
| list_tables | Lists tables in the database schemas | Regular |
| list_extensions | Lists installed PostgreSQL extensions | Regular |
| list_available_extensions | Lists all available (installable) extensions | Regular |
| list_migrations | Lists applied migrations from supabase_migrations.schema_migrations | Regular |
| apply_migration | Applies a SQL migration and records it in supabase_migrations.schema_migrations | Privileged |
| list_table_columns | Lists columns for a specific table | Regular |
| list_indexes | Lists indexes for a specific table | Regular |
| list_constraints | Lists constraints for a specific table | Regular |
| list_foreign_keys | Lists foreign keys for a specific table | Regular |
| list_triggers | Lists triggers for a specific table | Regular |
| list_database_functions | Lists user-defined database functions | Regular |
| get_function_definition | Gets the source definition of a function | Regular |
| get_trigger_definition | Gets the source definition of a trigger | Regular |
Database Operations & Stats
| Tool | Description | Privilege |
|------|-------------|-----------|
| execute_sql | Executes an arbitrary SQL query | Privileged |
| explain_query | Runs EXPLAIN ANALYZE on a query | Privileged |
| get_database_connections | Shows active connections (pg_stat_activity) | Regular |
| get_database_stats | Retrieves database statistics (pg_stat_*) | Regular |
| get_index_stats | Shows index usage statistics | Regular |
| get_vector_index_stats | Shows pgvector index statistics | Regular |
Security & RLS
| Tool | Description | Privilege |
|------|-------------|-----------|
| list_rls_policies | Lists Row-Level Security policies for a table | Regular |
| get_rls_status | Shows RLS enabled/disabled status for tables | Regular |
| get_advisors | Retrieves security and performance advisory notices | Regular |
Project Configuration
| Tool | Description | Privilege |
|------|-------------|-----------|
| `get_
... View full README on GitHub
