
Supabase
The Supabase MCP Server enables AI-powered IDEs to execute SQL queries, manage database schema changes, call the Supabase Management API, and use the Auth Admin SDK with built-in safety controls. It provides a three-tier safety system for SQL operations (safe, write, and destructive), runtime query validation with risk assessment, and transaction handling for both direct and pooled database connections. The server solves the problem of safely integrating database operations into AI-assisted development workflows while maintaining control over data access and modification permissions.
- GitHub stars
- 821
- tools
- 12
- last updated
- Mar 4, 2026
Tools
12 toolsPublic tool metadata for what this MCP can expose to an agent.
get_schemasLists schemas with sizes and table counts.
Lists schemas with sizes and table counts.
No parameter schema in public metadata yet.
get_tablesLists tables, foreign tables, and views with metadata.
Lists tables, foreign tables, and views with metadata.
No parameter schema in public metadata yet.
get_table_schemaGets detailed table structure (columns, keys, relationships).
Gets detailed table structure (columns, keys, relationships).
No parameter schema in public metadata yet.
execute_postgresqlExecutes SQL statements against your database.
Executes SQL statements against your database.
No parameter schema in public metadata yet.
confirm_destructive_operationExecutes high-risk operations after confirmation.
Executes high-risk operations after confirmation.
No parameter schema in public metadata yet.
retrieve_migrationsGets migrations with filtering and pagination options.
Gets migrations with filtering and pagination options.
No parameter schema in public metadata yet.
live_dangerouslyToggles between safe and unsafe modes.
Toggles between safe and unsafe modes.
No parameter schema in public metadata yet.
send_management_api_requestSends arbitrary requests to Supabase Management API with auto-injection of project ref.
Sends arbitrary requests to Supabase Management API with auto-injection of project ref.
No parameter schema in public metadata yet.
get_management_api_specGets the enriched API specification with safety information.
Gets the enriched API specification with safety information.
No parameter schema in public metadata yet.
get_management_api_safety_rulesGets all safety rules with human-readable explanations.
Gets all safety rules with human-readable explanations.
No parameter schema in public metadata yet.
get_auth_admin_methods_specRetrieves documentation for all available Auth Admin methods.
Retrieves documentation for all available Auth Admin methods.
No parameter schema in public metadata yet.
call_auth_admin_methodDirectly invokes Auth Admin methods with proper parameter handling.
Directly invokes Auth Admin methods with proper parameter handling.
No parameter schema in public metadata yet.
Sponsors
Readme
Query | MCP server for Supabase
🌅 More than 17k installs via pypi and close to 30k downloads on Smithery.ai — in short, this was fun! 🥳 Thanks to everyone who has been using this server for the past few months, and I hope it was useful for you. Since Supabase has released their own official MCP server, I've decided to no longer actively maintain this one. The official MCP server is as feature-rich, and many more features will be added in the future. Check it out!
Query MCP is an open-source MCP server that lets your IDE safely run SQL, manage schema changes, call the Supabase Management API, and use Auth Admin SDK — all with built-in safety controls.
Details
- Repository
- github.com/alexander-zuev/supabase-mcp-server
- Categories
- Databases, Communication & Messaging