# Supabase

> Supabase is an MCP server for databases. Let AI assistants query and manage your Supabase projects through OAuth-secured tools. It can run locally on your machine or as a hosted remote server.

- **Kind:** MCP server
- **Platforms:** API, CLI, self-hosted
- **Website:** https://supabase.com/mcp
- **Repository:** https://github.com/supabase/mcp/tree/HEAD/packages/mcp-server-supabase
- **MCP Registry name:** com.supabase/mcp
- **Categories:** [databases](https://ai-powered.com/categories/databases), [developer tools](https://ai-powered.com/categories/developer-tools)
- **Listing updated:** 2026-11-18

## About

Supabase groups its tools into feature groups that you can switch on or off in the connection URL: docs, account, database, debugging, development, functions, branching, feedback and notebooks, with Storage off by default. You can also scope the server to a single project; with no project selected, every project in the organization is reachable.

The database group lists tables, extensions and migrations, applies migrations and runs SQL. Debugging adds read-only SQL over project logs and security and performance advisors. Development returns the project URL, publishable keys and generated TypeScript types, and the functions group lists, reads and deploys Edge Functions.

The docs warn that connecting an LLM to a project carries security risks and point to a best-practices guide. Sign-in opens a browser to grant access to an organization, so no personal access token is needed, though the npm stdio package takes one. Local CLI and self-hosted setups expose only a limited tool subset and no OAuth.

## Features

- **Feature groups:** Enable only the tool groups you want through URL options.
- **Project scoping:** Limit the server to a single project.
- **Database tools:** List tables, apply migrations and run SQL.
- **Log and advisor queries:** Query logs and get security and performance advisors.
- **Edge Functions:** List, read and deploy functions.
- **Typed output:** Generate TypeScript types from the schema.

## Good for

- Ask what tables exist in a project
- Apply a migration from an AI editor
- Check security advisors before launch
- Deploy an Edge Function from a chat
- Generate TypeScript types after a schema change

## Install

### Claude Code (Terminal)

```sh
claude mcp add --transport http mcp https://mcp.supabase.com/mcp
```

### Claude Desktop (Settings → Connectors → Add custom connector)

```sh
https://mcp.supabase.com/mcp
```

### Cursor (~/.cursor/mcp.json)

```json
{
  "mcpServers": {
    "mcp": {
      "url": "https://mcp.supabase.com/mcp"
    }
  }
}
```

### VS Code (.vscode/mcp.json)

```json
{
  "servers": {
    "mcp": {
      "type": "http",
      "url": "https://mcp.supabase.com/mcp"
    }
  }
}
```

### Windsurf (~/.codeium/windsurf/mcp_config.json)

```json
{
  "mcpServers": {
    "mcp": {
      "serverUrl": "https://mcp.supabase.com/mcp"
    }
  }
}
```

### Other clients (your client's MCP settings (most use this shape))

```json
{
  "mcpServers": {
    "mcp": {
      "type": "http",
      "url": "https://mcp.supabase.com/mcp"
    }
  }
}
```

## Tools

- `list_tables`: Lists all tables in the database.
- `list_extensions`: Lists Postgres extensions.
- `list_migrations`: Lists database migrations.
- `apply_migration`: Applies a database migration.
- `execute_sql`: Executes SQL queries.
- `query_logs`: Runs a read-only SQL query against project logs.
- `get_advisors`: Gets security and performance advisors.
- `get_project_url`: Gets a project's API URL.
- `get_publishable_keys`: Gets publishable and legacy anon keys.
- `generate_typescript_types`: Generates TypeScript types from the schema.
- `list_edge_functions`: Lists Edge Functions.
- `get_edge_function`: Gets a specific Edge Function.
- `deploy_edge_function`: Deploys an Edge Function.

## FAQ

### Do I need a personal access token?

Not for the remote server; sign-in uses a browser flow. The npm stdio package takes SUPABASE_ACCESS_TOKEN.

### Can I restrict what it touches?

Yes, by scoping to one project and choosing feature groups in the URL.

### Does it work with local Supabase?

The CLI exposes it at localhost:54321/mcp with a limited tool subset and no OAuth.

### Are there risks?

The docs say connecting an LLM to your projects carries security risks and recommend reading their best practices first.

### How do I add Supabase to Claude Code?

Run this command in your terminal: claude mcp add --transport http mcp https://mcp.supabase.com/mcp

### What are the best alternatives to Supabase?

The closest alternatives to Supabase are REA, Context7, Chrome DevTools MCP, Codebase Memory and GitHub.

## Where this comes from

- Description: written from the project's README and the project's website.
- Install steps: from the official MCP Registry entry.

## Alternatives

- [REA](https://ai-powered.com/mcp/rea): REA is an open-source MCP server for developer tools.
- [Context7](https://ai-powered.com/mcp/context7): Context7 is a freemium MCP server for developer tools.
- [Chrome DevTools MCP](https://ai-powered.com/mcp/chrome-devtools-mcp-2): Chrome DevTools MCP is an open-source MCP server for browser automation.
- [Codebase Memory](https://ai-powered.com/mcp/codebase-memory): Codebase Memory is an open-source MCP server for knowledge and memory.
- [GitHub](https://ai-powered.com/mcp/github-2): GitHub is an open-source MCP server for developer tools.
- [Serena MCP: the IDE for your agent](https://ai-powered.com/mcp/serena-mcp-the-ide-for-your-agent): Serena MCP: the IDE for your agent is an open-source MCP server for developer tools.
- [awesome-mcp-servers](https://ai-powered.com/mcp/awesome-mcp-servers-2): awesome-mcp-servers is an open-source MCP server for developer tools.
- [XERJ](https://ai-powered.com/mcp/xerj): XERJ is an open-source MCP server for knowledge and memory.

---
Source: https://ai-powered.com/mcp/supabase
