How to Connect Supabase Remote MCP to Gemini CLI
Add Supabase's remote MCP server to Gemini CLI in about a minute.
Step-by-step
- Edit ~/.gemini/settings.jsonAdd the
mcpServersentry shown above โ Gemini CLI useshttpUrlfor Streamable HTTP endpoints andurlfor legacy SSE. - AuthorizeOn first use your client opens a Supabase OAuth consent screen โ approve it and tools become available.
- VerifyRestart
gemini, then run/mcp listinside the CLI. Verify in the browser: pastehttps://mcp.supabase.com/mcpinto remotemcp.net/inspector and run initialize + tools/list.
Troubleshooting OAuth / 401
- A
401 Unauthorizedon first connect is normal โ the endpoint is OAuth-protected; let Gemini CLI finish the browser consent flow. - If the consent window never opens, remove and re-add the server, then retry.
- Check the exact challenge at our OAuth debugger.
- Run the live endpoint through the online inspector to see the raw JSON-RPC exchange.
Or add to ~/.cursor/mcp.json:
{
"mcpServers": {
"supabase": {
"url": "https://mcp.supabase.com/mcp"
}
}
}claude mcp add --transport http supabase https://mcp.supabase.com/mcp
Or add to .vscode/mcp.json:
{
"servers": {
"supabase": {
"type": "http",
"url": "https://mcp.supabase.com/mcp"
}
}
}- Open Settings โ Connectors (Integrations) โ Add Custom Connector.
- Paste the endpoint URL:
https://mcp.supabase.com/mcp - Complete the browser OAuth 2.1 login flow when prompted.
Bridge the remote endpoint into stdio with mcp-remote in claude_desktop_config.json:
{
"mcpServers": {
"supabase": {
"command": "npx",
"args": [
"-y",
"mcp-remote",
"https://mcp.supabase.com/mcp"
]
}
}
}Add to ~/.codeium/windsurf/mcp_config.json:
{
"mcpServers": {
"supabase": {
"serverUrl": "https://mcp.supabase.com/mcp"
}
}
}Add to ~/.kiro/settings/mcp.json (or .kiro/settings/mcp.json in your workspace), then reopen Kiro's Agent panel to pick up the server:
{
"mcpServers": {
"supabase": {
"url": "https://mcp.supabase.com/mcp"
}
}
}Add to ~/.codex/config.toml โ Codex reads remote HTTP servers from [mcp_servers.*] tables:
[mcp_servers.supabase] url = "https://mcp.supabase.com/mcp"
Add to cline_mcp_settings.json (Cline โ MCP Servers โ Configure), or paste it via Cline's MCP marketplace file:
{
"mcpServers": {
"supabase": {
"type": "streamableHttp",
"url": "https://mcp.supabase.com/mcp"
}
}
}Add to ~/.gemini/settings.json under mcpServers โ httpUrl for Streamable HTTP, url for legacy SSE:
{
"mcpServers": {
"supabase": {
"httpUrl": "https://mcp.supabase.com/mcp"
}
}
}Tools exposed by Supabase MCP (30)
| Tool | Safety | Description | Parameters |
|---|---|---|---|
| list_organizations ~31 tok | ๐ข Read | List Supabase organizations. | โ |
| get_organization ~33 tok | ๐ข Read | Get details of a Supabase organization. | โ |
| list_projects ~28 tok | ๐ข Read | List Supabase projects. | โ |
| get_project ~31 tok | ๐ข Read | Get details of a Supabase project. | โ |
| get_project_url ~33 tok | ๐ข Read | Get the API URL of a Supabase project. | โ |
| get_publishable_keys ~35 tok | ๐ข Read | Get publishable/anon API keys for a project. | โ |
| get_cost ~33 tok | ๐ข Read | Estimate the cost of a new project or branch. | โ |
| confirm_cost ~35 tok | ๐ข Read | Confirm a cost estimate before resource creation. | โ |
| create_project ~30 tok | ๐ Write | Create a new Supabase project. | โ |
| pause_project ~29 tok | ๐ Write | Pause a Supabase project. | โ |
| restore_project ~32 tok | ๐ Write | Restore a paused Supabase project. | โ |
| list_tables ~31 tok | ๐ข Read | List tables in a project database. | โ |
| list_extensions ~32 tok | ๐ข Read | List installed Postgres extensions. | โ |
| list_migrations ~31 tok | ๐ข Read | List applied database migrations. | โ |
| apply_migration ~35 tok | ๐ Write | Apply a SQL migration to the project database. | โ |
| execute_sql ~35 tok | ๐ด Destructive | Execute arbitrary SQL against the project database. | โ |
| get_logs ~32 tok | ๐ข Read | Retrieve recent logs for a Supabase service. | โ |
| get_advisors ~34 tok | ๐ข Read | Get security and performance advisor findings. | โ |
| generate_typescript_types ~38 tok | ๐ข Read | Generate TypeScript types from the database schema. | โ |
| search_docs ~31 tok | ๐ข Read | Search the Supabase documentation. | โ |
| create_branch ~33 tok | ๐ Write | Create a development branch of a project. | โ |
| list_branches ~32 tok | ๐ข Read | List development branches of a project. | โ |
| delete_branch ~30 tok | ๐ด Destructive | Delete a development branch. | โ |
| merge_branch ~33 tok | ๐ด Destructive | Merge a development branch into production. | โ |
| reset_branch ~33 tok | ๐ด Destructive | Reset a development branch to a prior state. | โ |
| rebase_branch ~34 tok | ๐ Write | Rebase a development branch onto production. | โ |
| deploy_edge_function ~34 tok | ๐ Write | Deploy an edge function to a project. | โ |
| list_edge_functions ~31 tok | ๐ข Read | List deployed edge functions. | โ |
| get_edge_function ~32 tok | ๐ข Read | Get details of an edge function. | โ |
| create_storage_bucket ~31 tok | ๐ Write | Create a storage bucket. | โ |
Connect Supabase MCP to another client
Other servers for Gemini CLI
GitHub's official remote MCP server hosted at api.githubcopilot.com. Gives AI agents first-party access to repositories, issues, pull requests and code search.
Notion's official hosted MCP server. Agents can search your workspace, read and create pages, and query databases over Streamable HTTP or SSE.
Linear's official remote MCP server. Agents can search, create and update issues and query your team's workflow over Streamable HTTP or SSE.
Figma's official remote MCP server. Agents can pull design context, variables, Code Connect mappings and screenshots from your Figma files.
AWS Knowledge's hosted remote MCP server. AWS's fully-managed public knowledge MCP gives agents access to the latest AWS documentation, API references, What's New posts and architectural guidance across all AWS services. It is public and unauthenticated โ connect and call tools immediately.
Stripe's official remote MCP server at mcp.stripe.com. Agents can query customers, payment intents and subscriptions and invoke Stripe API operations with OAuth.