medieage_supabase-mcp-server
Query MCP is a robust server designed to enable a variety of IDEs to interact with databases through SQL queries, while ensuring safety with a three-tier system for risk assessment. It also offers integration with Supabase management and authentication APIs via a Python SDK, providing a comprehensive solution for database and project management.
Query MCP (Supabase MCP Server)
Query MCP is a powerful server enabling IDEs to execute SQL queries, manage databases, access management APIs, and handle user authentication. Key features include support for multiple MCP clients, runtime SQL validation, robust transaction handling, and automatic versioning of database schema changes. It also facilitates managing Supabase projects through the Supabase Management API and provides user management via the Supabase Auth Admin methods using Python SDK. The server is easy to install using various package managers and offers extensive configuration options for connecting to databases and APIs. Notably, safety features categorize operations into various risk levels to prevent unwanted database changes.
Key Features
- Compatible with multiple MCP clients
- SQL query execution with runtime validation
- Three-tier safety system for SQL operations
- Transaction handling for database connections
- Manage Supabase projects and users through APIs and SDK
- Automatic versioning of database schema changes
Usage
Any MCP client supporting the stdio protocol can work with this server. It has specific setup guides for popular clients like Cursor and Windsurf.