Supabase Mcp Server
About
# 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)"…
Details
- Author
- medieage
- Downloads
- 365
- Categories
- Cloud Service
Jump to
- Compatible with Cursor, Windsurf, Cline, and other MCP clients
- Read-only and read-write SQL execution modes
- Runtime SQL query validation with risk level assessment
- Three-tier safety system: safe, write, and destructive
- Robust transaction handling for direct and pooled connections
- Automatic versioning of database schema changes
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
Supabase Mcp ServerCommand (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 the server via pipx install supabase-mcp-server or uv pip install supabase-mcp-server, then configure it with environment variables or a global .env file. The server requires a Supabase project reference, database password, and optionally an access token and service role key for Management API and Auth Admin features.
Claude Desktop / Cursor
Paste into your MCP client config file to install this server.
{
"mcpServers": {
"supabase mcp server": {
"supabase-mcp-server-medieage": {
"command": "uv",
"args": [
"pip",
"install",
"supabase-mcp-server"
]
}
}
}
}McpServers
{
"supabase-mcp-server-medieage": {
"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.
