This project provides an MCP (Machine Code Protocol) server for Supabase, enabling users to interact with their Supabase projects via chat interfaces within IDEs. It targets developers and researchers who need to manage databases, execute queries, and utilize Supabase's Management API and Auth Admin SDK safely and efficiently. The primary benefit is streamlined, secure, and integrated project management directly from development environments.

How It Works

The server acts as a bridge between MCP-compatible clients (like Cursor, Windsurf) and Supabase. It parses and validates SQL queries, categorizing them into 'safe' (read-only), 'write' (data modification), and 'destructive' (schema changes) tiers, with escalating confirmation requirements. It also interfaces with the Supabase Management API and Auth Admin SDK, applying a universal safety mode across all operations. This approach ensures data integrity and prevents accidental destructive actions through multi-stage confirmations and risk-based access controls.

Quick Start & Requirements

• Install: pipx install supabase-mcp-server or uv pip install supabase-mcp-server
• Prerequisites: Python 3.12+, thequery.dev API key. Local Supabase development requires PostgreSQL.
• Configuration: Requires environment variables like SUPABASE_PROJECT_REF, SUPABASE_DB_PASSWORD, SUPABASE_REGION, and QUERY_API_KEY.
• Docs: https://github.com/alexander-zuev/supabase-mcp-server

Highlighted Details

• Supports SQL query execution with runtime validation and a three-tier safety system.
• Integrates with Supabase Management API and Auth Admin SDK for project and user management.
• Features automatic versioning of database schema changes.
• Provides access to Supabase logs across various services (Postgres, API Gateway, Auth, etc.).

Maintenance & Community

The project is no longer actively maintained by the original author, who recommends using the official Supabase MCP server. A roadmap is available via a GitHub discussion.

Licensing & Compatibility

The repository does not explicitly state a license in the README. Compatibility for commercial use or closed-source linking is not specified.

Limitations & Caveats

This server is not actively maintained and is superseded by an official Supabase MCP server. It does not support self-hosted Supabase projects or session pooling for database connections. Management API and Auth Admin SDK features are only compatible with remote Supabase projects.