use Auth Admin SDK — all with built-in safety controls.

## Table of contents

Getting started • Feature overview • Troubleshooting • Changelog

## ✨ Key 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.) ## 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](https://docs.astral.sh/uv/getting-started/installation/#__tabbed_1_1). ### 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** ```bash 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 # if pipx is installed (recommended) pipx install supabase-mcp-server # if uv is installed uv pip install supabase-mcp-server ``` `pipx` is recommended because it creates isolated environments for each package. You can also install the server manually by cloning the repository and running `pipx install -e .` from the root directory. #### Installing from source If you would like to install from source, for example for local development: ```bash uv venv # On Mac source .venv/bin/activate # On Windows .venv\Scripts\activate # Install package in editable mode uv pip install -e . ``` #### Installing via Smithery.ai You can find the full instructio

Query | MCP server for Supabase

评论