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 Supabase MCP Server is evolving into thequery.dev! The core tool will stay free forever, with premium features added on top. Early adopters will get special perks.

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

The server requires Python 3.12+. Installation is simplified via pipx or uv. Configuration involves setting environment variables for Supabase project details, database password, and region. The server supports database connections, Management API (requires access token), and Auth Admin SDK (requires service role key). Configuration can be set via environment variables, a local .env file (source installation only), or a global config file.

Feature Overview

Key features include database query tools with SQL parsing, validation, and automatic migration versioning. It also offers Management API tools with safety controls and Auth Admin tools for user management via Python SDK. The server provides access to Supabase logs and analytics data. Automatic versioning of database changes and a universal safety mode are also supported.