alexander-zuev avatar

Supabase

alexander-zuev/supabase-mcp-server

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 tools

Public 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.


View the full README on GitHub

Details

Repository
github.com/alexander-zuev/supabase-mcp-server
Categories
Databases, Communication & Messaging

Related Databases MCP servers

View all
1timescale avatarTiger MCPtimescale/tiger-cliProvides programmatic access to Tiger Cloud services, databases, and documentation.127stars
2wgong avatarWgong Sqlite Mcp Serverwgong/sqlite-mcp-serverExplore, query, and inspect SQLite databases with ease. List tables, preview results, and view det…1stars
3rosch100 avatarMcp Encrypted Sqliterosch100/mcp-encrypted-sqliteMCP server for encrypted SQLite databases (SQLCipher 4) - Works with MoneyMoney, KeePass and more0stars
4supabase avatarSupabasesupabase/mcpMCP server for interacting with the Supabase platform0stars
5mongodb-js avatarMongodb Mcp Servermongodb-js/mongodb-mcp-serverMongoDB Model Context Protocol Server1.2Kstars
6unmateria avatarMicrosoft Access Databaseunmateria/mcp-accessRead and edit Microsoft Access databases (.accdb/.mdb) - forms, VBA, tables, queries. Windows.61stars