Database · Developer Tools

Supabase MCP Server logo

Supabase MCP Server

alexander-zuev/supabase-mcp-server

Query MCP is an open-source MCP server that lets your IDE safely run SQL, manage schema changes, call the Supabase Management API, and use Auth Admin SDK — all with built-in safety controls.

Install

pipx install supabase-mcp-server

Client configuration

{
  "mcpServers": {
    "supabase": {
      "command": "/Users/username/.local/bin/supabase-mcp-server",
      "env": {
        "QUERY_API_KEY": "<QUERY_API_KEY>",
        "SUPABASE_PROJECT_REF": "<SUPABASE_PROJECT_REF>",
        "SUPABASE_DB_PASSWORD": "<SUPABASE_DB_PASSWORD>",
        "SUPABASE_REGION": "<SUPABASE_REGION>",
        "SUPABASE_ACCESS_TOKEN": "<SUPABASE_ACCESS_TOKEN>",
        "SUPABASE_SERVICE_ROLE_KEY": "<SUPABASE_SERVICE_ROLE_KEY>"
      }
    }
  }
}

Environment variables

QUERY_API_KEYSUPABASE_PROJECT_REFSUPABASE_DB_PASSWORDSUPABASE_REGIONSUPABASE_ACCESS_TOKENSUPABASE_SERVICE_ROLE_KEY
GitHub stars
677
Category
Database, Developer Tools
License
Apache-2.0
Updated
Oct 6, 2026

About Supabase MCP Server

More than 17k installs via pypi and close to 30k downloads on Smithery.ai — in short, this was fun! Thanks to everyone who has been using this server for the past few months, and I hope it was useful for you. Since Supabase has released their own official MCP server, I've decided to no longer actively maintain this one. The official MCP server is as feature-rich, and many more features will be added in the future. Check it out!

Features

  • Compatible with Cursor, Windsurf, Cline and other MCP clients supporting 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

  • Pre-built tools to help Cursor & Windsurf work with MCP more effectively

  • Dead-simple install & setup via package manager (uv, pipx, etc.)

Tools (12)

  • get_auth_admin_methods_spec

    to retrieve documentation for all available Auth Admin methods

  • call_auth_admin_method

    to directly invoke Auth Admin methods with proper parameter handling

  • get_user_by_id

    Retrieve a user by their ID

  • create_user

    Create a new user

  • delete_user

    Delete a user by their ID

  • invite_user_by_email

    Send an invite link to a user's email

  • generate_link

    Generate an email link for various authentication purposes

  • update_user_by_id

    Update user attributes by ID

  • delete_factor

    Delete a factor on a user (currently not implemented in SDK)

  • Functionality

    Enables operations not possible with SQL alone (invites, magic links, MFA)

  • Accuracy

    More reliable then creating and executing raw SQL queries on auth schemas

  • Simplicity

    Offers clear methods with proper validation and error handling

Details on this page are taken from the project's README. Open README

Supported clients

Clients mentioned in this server's README:

View all
Claude Desktop logo

Claude Desktop

Desktop · Freemium · Proprietary

Anthropic's official Claude AI desktop application. Supports MCP servers to extend functionality.

WindowsMacOS
Cline logo

Cline

Desktop · Free · MIT

An AI coding assistant integrated into the IDE. Supports MCP servers for enhanced functionality.

WindowsMacOSLinux
Cursor logo

Cursor

Desktop · Freemium · Proprietary

The first agentic IDE. The Cursor editor truly merges how developers and AI work together, delivering a magical coding experience.

WindowsMacOSLinux
Windsurf logo

Windsurf

Desktop · Freemium · Proprietary

The first agentic IDE. The Windsurf editor truly merges how developers and AI work together.

WindowsMacOSLinux

Related MCP servers

More servers
Supabase MCP logo

Supabase MCP

supabase-community/supabase-mcp

1.3k

The Model Context Protocol (MCP) standardizes how Large Language Models (LLMs) talk to external services like Supabase. It connects AI assistants directly with your Supabase project and allows them to perform tasks like managing tables, fetching config, and querying data. See the full list of tools.

Database
Genai Toolbox logo

Genai Toolbox

googleapis/genai-toolbox

769

MCP Toolbox for Databases is an open source Model Context Protocol (MCP) server that connects your AI agents, IDEs, and applications directly to your enterprise databases.

Database
Awesome MCP List logo

Awesome MCP List

MobinX/awesome-mcp-list

645

This is a continuously updated curated list of MCP servers, covering categories such as browser control, arts and culture, cloud platforms, command line, communication, customer data platforms, databases, developer tools, data science tools, file systems, finance and fintech, gaming, knowledge and memory, location services, marketing, monitoring, search and utilities. Each project includes a GitHub link and star count for quick reference and use.

Database
PostgreSQL Model Context Protocol (PG MCP) Server logo

PostgreSQL Model Context Protocol (PG MCP) Server

stuzero/pg-mcp-server

440

PG-MCP is a server implementation of the Model Context Protocol for PostgreSQL databases. It provides a comprehensive API for AI agents to discover, connect to, query, and understand PostgreSQL databases through MCP's resource-oriented architecture.

Database
dbhub logo

dbhub

bytebase/dbhub

332

[!NOTE] If you need an enterprise-level database MCP server with built-in guardrails like approval flow, access control, data masking, and audit logging beyond what DBHub offers, check out Bytebase.

Database
mcp_server_mysql logo

mcp_server_mysql

benborla/mcp-server-mysql

312

Using mcp-server-mysql to let your AI query MySQL? Bloome brings that to your whole team — an AI-agent IM platform where AI agents are members of the chat. Connect your MCP tools and have agents inspect schemas, run queries, and answer data questions for everyone in one thread.

Database