MCP HubMCP Hub
alexander-zuev

supabase-mcp-server

by: alexander-zuev

Query MCP enables end-to-end management of Supabase via chat interface: read & write query executions, management API support, automatic migration versioning, access to logs and much more.

508created 15/02/2025
Visit
Supabase
chat

📌Overview

Purpose: The framework aims to enhance database management and interaction with Supabase by providing a secure environment for executing SQL queries and managing user authentication.

Overview: The Supabase MCP Server, evolving into Query MCP, is designed for seamless integration with various IDEs for safe execution of SQL queries while controlling user access and project management effectively. It emphasizes built-in safety controls to mitigate risks during database operations.

Key Features:

  • Safety Controls: Implements a three-tier safety system for SQL operations, ensuring only authorized actions are performed, categorized into safe, write, and destructive operations.

  • Management API Access: Provides secure integration with the Supabase Management API, allowing for comprehensive project management and user authentication tasks using Python SDK methods.

Query MCP (Supabase MCP Server)

Enable your favorite IDE to safely execute SQL queries, manage your database end-to-end, access Management API, and handle user authentication with built-in safety controls.

🎉 The Future of Supabase MCP Server -> Query MCP

I'm thrilled to announce that Supabase MCP Server is evolving into thequery.dev!

Commitments

  • The core tool will stay free forever - free & open-source software is how I got into coding.
  • Premium features will be added on top - enhancing capabilities without limiting existing functionality.
  • First 2,000 early adopters will get special perks - join early for an exclusive treat!

🚀 BIG v4 Launch Coming Soon!

👉 Join Early Access at thequery.dev

Table of contents

✨ Key features

  • Compatible with various MCP clients supporting the stdio protocol.
  • Control read-only and read-write modes of SQL query execution.
  • Runtime SQL query validation with risk level assessment.
  • Three-tier safety system for SQL operations: safe, write, and destructive.
  • Robust transaction handling for both direct and pooled database connections.
  • Automatic versioning of database schema changes.
  • Manage your Supabase projects with Supabase Management API.
  • Manage users with Supabase Auth Admin methods via Python SDK.
  • Easy installation via package manager.

Getting Started

Prerequisites

  • Python 3.12+

Installation

To install the server, use the following commands:

# if pipx is installed (recommended)
pipx install supabase-mcp-server

# if uv is installed
uv pip install supabase-mcp-server

You can also install the server manually by cloning the repository.

Configuration

The Supabase MCP server requires configuration for connecting to your Supabase database and using the Management API.

Environment Variables

VariableRequiredDefaultDescription
SUPABASE_PROJECT_REFYes127.0.0.1:54322Your Supabase project reference ID (or local host:port)
SUPABASE_DB_PASSWORDYespostgresYour database password
SUPABASE_REGIONYes*us-east-1AWS region of your Supabase project
SUPABASE_ACCESS_TOKENNoNonePersonal access token for Supabase Management API
SUPABASE_SERVICE_ROLE_KEYNoNoneService role key for Auth Admin SDK

Note: For remote Supabase projects, correctly specify the region using SUPABASE_REGION.

Connection Types

  • Database Connection: Uses transaction pooling. Connection strings follow specific formats for local and remote projects.
  • Management API Connection: Requires a token to connect.
  • Auth Admin SDK Connection: Also requires specific keys for local or remote connections.

Step 3: Usage

Any MCP client supporting the stdio protocol will work with this server. Configurations for popular clients can be found within the documentation.

Troubleshooting

  • Run supabase-mcp-server directly from the terminal to debug the installation.
  • Ensure configuration settings in your MCP client match your server setup.
  • Check for connection and path issues if tools are not available.

Feature Overview

Database Query Tools

  • Execute SQL queries with a three-tier safety system: safe, write, and destructive.
  • Analyze SQL operations with PostgreSQL's parser for safety requirements.

Management API Tools

  • Access secure features of the Supabase Management API with built-in safety controls.

Auth Admin Tools

  • Access Supabase Auth Admin methods via Python SDK to easily manage user operations.

Logs & Analytics

Access Supabase logs for various services, simplifying debugging across your stack.

Automatic Versioning of Database Changes

Automatically creates migration scripts for database changes, reducing the risk of irreversible modifications.

Universal Safety Mode

Standardized safety controls across all services ensure consistent risk management.

Changelog

  • Simplified installation via package manager (v0.2.0)
  • Support for different Supabase regions (v0.2.2)
  • Programmatic access to Supabase Management API with safety controls (v0.3.0)

For a more detailed roadmap, please see the discussion on GitHub.

Enjoy! ☺️