supabase-mcp-server
The Supabase MCP Server is a feature-rich system designed for safely managing Supabase databases through SQL queries, API access, and user authentication. It offers tools for integration with MCP clients and includes robust safety controls for operation management.
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.
Key Features
- Compatible with Cursor, Windsurf, Cline, and other MCP clients.
- Control read-only and read-write modes of SQL query execution with runtime validation.
- Robust transaction handling and automatic versioning of database schema changes.
- Pre-built tools for better MCP client integration and easy installation via package managers.
Installation and Configuration
Prerequisites include Python 3.12+ and optional PostgreSQL for local development. The server can be installed using various package managers, and requires configuration through environment variables, .env files, or a global config file.
Usage
Various MCP clients can connect to the server via the stdio protocol. The server works with tools such as Cursor, Windsurf, Claude Desktop, and Cline, providing step-by-step configuration instructions for each tool.
Troubleshooting
Debugging tips are provided, including checking installation, correct configuration settings, and accessing detailed logs.
Safety and Security
The server implements a comprehensive safety management system, categorizing operations by risk level and requiring explicit confirmation for high-risk operations.
Additional Features
- Universal Safety Mode across database, API, and SDK operations.
- Auth Admin tools for user management via Python SDK.