Query MCP (Supabase MCP Server)
About
Query MCP (Supabase MCP Server) is an MCP server that enables your favorite IDE to safely execute SQL queries, manage your Supabase database end-to-end, access the Supabase Management API, and handle user authentication with built-in safety controls.
Details
- Author
- MCP-Mirror
- Downloads
- 334
- Categories
- Cloud Service
Jump to
- SQL execution with read-only and read-write modes
- Runtime SQL validation with risk level assessment
- Three-tier safety system: safe, write, destructive
- Robust transaction handling for direct/pooled connections
- Automatic versioning of database schema changes
- Supabase Management API and Auth Admin SDK integration
Setting up with Highlight
This MCP is not yet compatible with Highlight’s one-click setup. However, you can still use it with Highlight by following these steps:
- Download and install Highlight from highlightai.com/download
- Navigate to the plugins tab and select "Add Custom Plugin"
-
Configure the plugin with the settings below
Plugin Name
Query MCP (Supabase MCP Server)Command (node, npx, python, etc.)Please refer to the README for specific instructions on how to obtain API keys or other required environment variables.
- Enable "Start Automatically" if you want the plugin to start when Highlight launches
From the repository
Install via pipx or uv with pipx install supabase-mcp-server (recommended) or uv pip install supabase-mcp-server. Configure required environment variables (SUPABASE_PROJECT_REF, SUPABASE_DB_PASSWORD, SUPABASE_REGION) in your MCP client settings, a global config file, or a local .env file. Then connect your MCP client (Cursor, Windsurf, Cline, etc.) to the server.
Claude Desktop / Cursor
Paste into your MCP client config file to install this server.
{
"mcpServers": {
"query mcp (supabase mcp server)": {
"medieage_supabase-mcp-server": {
"command": "uv",
"args": [
"pip",
"install",
"supabase-mcp-server"
]
}
}
}
}McpServers
{
"medieage_supabase-mcp-server": {
"command": "uv",
"args": [
"pip",
"install",
"supabase-mcp-server"
]
}
}Query MCP (Supabase MCP Server)
<p align="center">
<picture>
<source media="(prefers-color-scheme: dark)" srcset="https://github.com/user-attachments/assets/4a363bcd-7c15-47fa-a72a-d159916517f7" />
<source media="(prefers-color-scheme: light)" srcset="https://github.com/user-attachments/assets/d255388e-cb1b-42ea-a7b2-0928f031e0df" />
</picture>
<picture>
<source media="(prefers-color-scheme: dark)" srcset="https://github.com/user-attachments/assets/38db1bcd-50df-4a49-a106-1b5afd924cb2" />
<source media="(prefers-color-scheme: light)" srcset="https://github.com/user-attachments/assets/82603097-07c9-42bb-9cbc-fb8f03560926" />
</picture>
</p>
<p align="center">
<strong>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.</strong>
</p>
<p align="center">
<a href="https://thequery.dev"></a>
</p>
<p align="center">
<a href="https://pypi.org/project/supabase-mcp-server/">
</a>
<a href="https://github.com/alexander-zuev/supabase-mcp-server/actions">
</a>
<a href="https://codecov.io/gh/alexander-zuev/supabase-mcp-server">
</a>
<a href="https://www.python.org/downloads/">
</a>
<a href="https://github.com/astral-sh/uv">
<a href="https://pepy.tech/project/supabase-mcp-server">
<a href="https://smithery.ai/server/@alexander-zuev/supabase-mcp-server"></a>
<a href="https://modelcontextprotocol.io/introduction">
<a href="LICENSE">
</a>
</p>
🎉 The Future of Supabase MCP Server -> Query MCP
I'm thrilled to announce that Supabase MCP Server is evolving into thequery.dev!
While I have big plans for the future, I want to make these commitments super clear:
- 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
<p align="center"> <a href="#getting-started">Getting started</a> • <a href="#feature-overview">Feature overview</a> • <a href="#troubleshooting">Troubleshooting</a> • <a href="#changelog">Changelog</a> </p>✨ Key features
- 💻 Compatible with Cursor, Windsurf, Cline and other MCP clients supportingstdio 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.)
Getting Started
Prerequisites
Installing the server requires the following on your system: - Python 3.12+If you plan to install via uv, ensure it's installed.
PostgreSQL Installation
PostgreSQL installation is no longer required for the MCP server itself, as it now uses asyncpg which doesn't depend on PostgreSQL development libraries.However, you'll still need PostgreSQL if you're running a local Supabase instance:
MacOS
brew install postgresql@16
Windows
- Download and install PostgreSQL 16+ from https://www.postgresql.org/download/windows/
- Ensure "PostgreSQL Server" and "Command Line Tools" are selected during installation
Step 1. Installation
Since v0.2.0 I introduced support for package installation. You can use your favorite Python package manager to install the server via:
```bash
Sign in to leave a review
Use Google, GitHub, or an email account so ratings stay tied to real people.
No reviews posted yet.
