This is the initial release for the Supabase MCP server. The following tools are available:
Project Management
list_projects: Lists all Supabase projects for the user.get_project: Gets a project by ID.create_project: Creates a new Supabase project.list_organizations: Lists all organizations for the user.get_organization: Gets an organization by ID.
Database Operations
list_tables: Lists all tables within the specified schemas.list_extensions: Lists all extensions in the database.list_migrations: Lists all migrations in the database.apply_migration: Applies a SQL migration to the database. SQL passed to this tool will be tracked within the database, so LLMs should use this for DDL operations (schema changes).execute_sql: Executes raw SQL in the database. LLMs should use this for regular queries that don't change the schema.
Project Configuration
get_project_url: Gets the API URL for a project.get_anon_key: Gets the anonymous API key for a project.
Development Tools
generate_typescript_types: Generates TypeScript types based on the database schema. LLMs can save this to a file and use it in their code.
Full Changelog: https://github.com/supabase-community/mcp-supabase/commits/v0.1.0