Query MCP for Supabase
Query MCP server facilitates comprehensive management of Supabase projects through a chat interface, supporting SQL queries, API calls, schema migrations, and logs with safety controls, aiming for seamless database and API operations.
Added on:
Created by:
Apr 17 2025
...
Ads
What is Query MCP for Supabase?
Query MCP is an open-source server designed to enable efficient management of Supabase projects through chat. It supports executing SQL queries with safety levels, managing APIs via the Management API, and handling authentication tasks with the Auth Admin SDK. The server provides automatic migration versioning, detailed logs, and safety modes for all operations, ensuring secure and reliable database and API management. It allows target users to perform schema changes, run queries, monitor logs, and manage users—all through a conversational interface, streamlining workflows and reducing manual errors.
Who will use Query MCP for Supabase?
- Developers managing Supabase projects
- Database administrators
- API and backend engineers
- QA/test engineers
- Data analysts
How to use the Query MCP for Supabase?
- Step 1: Install the server via pipx, uv, or clone the repository.
- Step 2: Configure environment variables for your Supabase project, including project reference, password, region, and API keys.
- Step 3: Launch the server and set it up with your MCP client (Cursor, Windsurf, Cline, Claude Desktop).
- Step 4: Connect the client to the server with correct configuration details.
- Step 5: Use the chat or commands to execute SQL queries, manage schemas, call management APIs, or access logs.
- Step 6: Confirm high-risk operations explicitly and monitor logs for activities.
Query MCP for Supabase's Core Features & Benefits
The Core Features
- SQL query execution with safety tiers
- Management API support
- Auth Admin SDK methods
- Automatic schema migration versioning
- Comprehensive logs and analytics
- Unified safety control for all operations
- Support for multiple clients (Cursor, Windsurf, Cline, Claude)
The Benefits
- Streamlined database and API management via chat
- Enhanced safety with risk assessment and confirmation
- Reduced manual errors and increased efficiency
- Centralized log access for troubleshooting
- Automated schema versioning for better control
- Supports multiple operation modes and safety levels
Query MCP for Supabase's Main Use Cases & Applications
- Managing and executing SQL queries safely in development and production
- Automating database schema migrations
- Monitoring logs and activities across the Supabase stack
- Performing secure API requests to the Management API
- Managing users via Auth Admin SDK
- Streamlining team collaboration through chat-based management
FAQs of Query MCP for Supabase
Developer
- alexander-zuev