medieage_supabase-mcp-server
If you are the rightful owner of medieage_supabase-mcp-server and would like to certify it and/or have it hosted online, please leave a comment on the right or send an email to henry@mcphub.com.
Query MCP (Supabase MCP Server) is a tool that enables IDEs to execute SQL queries, manage databases, access Management API, and handle user authentication with safety controls.
Query MCP, formerly known as Supabase MCP Server, is a robust tool designed to enhance database management and user authentication through a secure and efficient interface. It allows developers to execute SQL queries, manage database schemas, and interact with the Supabase Management API using a three-tier safety system. The server supports various MCP clients like Cursor, Windsurf, and Cline, providing a seamless integration experience. With features like runtime SQL query validation, robust transaction handling, and automatic versioning of database changes, Query MCP ensures a safe and efficient database management process. The server is open-source and offers premium features for enhanced capabilities. It is compatible with Python 3.12+ and can be installed via package managers like pipx and uv.
Features
- Compatible with various 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
- Robust transaction handling for direct and pooled database connections
Tools
get_schemas
Lists schemas in the database, their size and number of tables
get_tables
List tables, foreign key tables, and views and their metadata
get_table_schema
Get the detailed structure of the table (columns, keys, relationships)
execute_postgresql
Execute SQL statements
confirm_destructive_operation
Confirmation before performing high-risk operations
retrieve_migrations
Get migration records
live_dangerously
Switch safe mode
send_management_api_request
Send Supabase Management API Request
get_management_api_spec
Get API specifications
get_auth_admin_methods_spec
Get Auth Admin method documentation
call_auth_admin_method
Call the Auth Admin method
