LogoSTMCP
Download
Supabase MCP Server

Supabase MCP Server

The Model Context Protocol (MCP) standardizes how Large Language Models (LLMs) talk to external services like Supabase. It connects AI assistants directly with your Supabase project and allows them to perform tasks like managing tables, fetching config, and querying data.

Tools

Account Tools
1. list_projects

Lists all Supabase projects for the user.

2. get_project

Gets details for a project.

3. create_project

Creates a new Supabase project.

4. pause_project

Pauses a project.

5. restore_project

Restores a project.

6. list_organizations

Lists all organizations that the user is a member of.

7. get_organization

Gets details for an organization.

8. get_cost

Gets the cost of a new project or branch for an organization.

9. confirm_cost

Confirms the user's understanding of new project or branch costs. This is required to create a new project or branch.

Knowledge Base Tools
10. search_docs

Searches the Supabase documentation for up-to-date information. LLMs can use this to find answers to questions or learn how to use specific features.

Database Tools
11. list_tables

Lists all tables within the specified schemas.

12. list_extensions

Lists all extensions in the database.

13. list_migrations

Lists all migrations in the database.

14. 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).

15. execute_sql

Executes raw SQL in the database. LLMs should use this for regular queries that don't change the schema.

Debug Tools
16. get_logs

Gets logs for a Supabase project by service type (api, postgres, edge functions, auth, storage, realtime). LLMs can use this to help with debugging and monitoring service performance.

17. get_advisors

Gets a list of advisory notices for a Supabase project. LLMs can use this to check for security vulnerabilities or performance issues.

Development Tools
18. get_project_url

Gets the API URL for a project.

19. get_anon_key

Gets the anonymous API key for a project.

20. generate_typescript_types

Generates TypeScript types based on the database schema. LLMs can save this to a file and use it in their code.

Edge Functions Tools
21. list_edge_functions

Lists all Edge Functions in a Supabase project.

22. deploy_edge_function

Deploys a new Edge Function to a Supabase project. LLMs can use this to deploy new functions or update existing ones.

Branching Tools (Experimental, requires a paid plan)
23. create_branch

Creates a development branch with migrations from production branch.

24. list_branches

Lists all development branches.

25. delete_branch

Deletes a development branch.

26. merge_branch

Merges migrations and edge functions from a development branch to production.

27. reset_branch

Resets migrations of a development branch to a prior version.

28. rebase_branch

Rebases development branch on production to handle migration drift.

Storage Tools
29. list_storage_buckets

Lists all storage buckets in a Supabase project.

30. get_storage_config

Gets the storage config for a Supabase project.

31. update_storage_config

Updates the storage config for a Supabase project (requires a paid plan).

JSON Config

{
  "mcpServers": {
    "supabase": {
      "command": "npx",
      "args": [
        "-y",
        "@supabase/mcp-server-supabase@latest",
        "--read-only",
        "--project-ref=<project-ref>"
      ],
      "env": {
        "SUPABASE_ACCESS_TOKEN": "<personal-access-token>"
      }
    }
  }
}

Information

Categories