Loading...
brew install postgresql@16{
"mcpServers": {
"supabase": {
"command": "/Users/username/.local/bin/supabase-mcp-server", // update path
"env": {
"QUERY_API_KEY": "your-api-key", // Required - get your API key at thequery.dev
"SUPABASE_PROJECT_REF": "your-project-ref",
"SUPABASE_DB_PASSWORD": "your-db-password",
"SUPABASE_REGION": "us-east-1", // optional, defaults to us-east-1
"SUPABASE_ACCESS_TOKEN": "your-access-token", // optional, for management API
"SUPABASE_SERVICE_ROLE_KEY": "your-service-role-key" // optional, for Auth Admin SDK
}
}
}
}SQL Query ExecutionExecutes SQL queries against the Supabase database.
Allows arbitrary SQL execution, potentially leading to data modification or deletion.
Schema ManagementManages database schema changes, including creating, altering, and dropping tables.
Modifying the database schema can have significant impact on application functionality and data integrity.
Supabase Management API AccessProvides access to the Supabase Management API for managing Supabase projects.
Allows administrative actions on the Supabase project, such as managing users and settings.
Auth Admin SDK MethodsProvides access to Supabase Auth Admin SDK for managing users.
Allows administrative actions on user accounts, such as creating, deleting, and modifying users.
Database Schema VersioningAutomatically versions database schema changes.
Primarily a read operation to track schema changes.
This MCP server provides a degree of safety through its tiered system and query validation. However, the ability to perform write operations and access administrative functions introduces risk, especially if the API key and other credentials are not properly secured.