Supabase

Learn how to use Klavis to connect your AI application to Supabase MCP Server

No-Code

Connect to enterprise-grade MCP servers instantly!

Get Started →

---

For Developer

Follow the instructions below to integrate Supabase MCP server to your API or SDK.

Prerequisites

• Create an API key

1. Create a Supabase MCP Server

Use the following endpoint to create a new remote Supabase MCP server instance:

Request

Python

from klavis import Klavis
from klavis.types import McpServerName

klavis_client = Klavis(api_key="<YOUR_API_KEY>")

# Create a Supabase MCP server instance
supabase_server = klavis_client.mcp_server.create_server_instance(
    server_name=McpServerName.SUPABASE,
    user_id="<YOUR_USER_ID>",
    platform_name="<YOUR_PLATFORM_NAME>",
)

Response

SDK Response

{
  "serverUrl": "https://supabase-mcp-server.klavis.ai/mcp/?instance_id=<instance-id>",
  "instanceId": "<instance-id>",
  "oauthUrl": "https://api.klavis.ai/oauth/supabase/authorize?instance_id=<instance-id>"
}

serverUrl specifies the endpoint of the Supabase MCP server, which you can connect and use this MCP Server with your Supabase databases and services.

instanceId is used for authentication and identification of your server instance.

2. Supabase OAuth Flow (Recommended)

If you want to enable your MCP server to access your private Supabase infomation:

Option 1: Supabase OAuth Flow

To enable your MCP server to access your private Supabase information through OAuth:

Python

import webbrowser

webbrowser.open(supabase_server.oauth_url)

Option 2: Set Auth Token

Instead of OAuth, you can also set your Supabase personal access token by calling our endpoint below:

cURL

curl --request POST \
  --url https://api.klavis.ai/mcp-server/instance/set-auth \
  --header 'Authorization: Bearer <token>' \
  --header 'Content-Type: application/json' \
  --data '{
  "instanceId": "<string>",
  "authData": {
    "token": "<string>"
  }
}'

Response

Response

{
  "success": true,
  "message": "<string>"
}

Watch the Example

Explore MCP Server Tools

Tools Information

Tool Name	Description
supabase_list_projects	Lists all Supabase projects for the user
supabase_get_project	Gets details for a Supabase project
supabase_get_cost	Gets the cost of creating a new project or branch
supabase_confirm_cost	Ask the user to confirm their understanding of the cost
supabase_create_project	Creates a new Supabase project
supabase_pause_project	Pauses a Supabase project
supabase_restore_project	Restores a Supabase project
supabase_list_organizations	Lists all organizations that the user is a member of
supabase_get_organization	Gets details for an organization including subscription plan
supabase_list_tables	Lists all tables in a schema
supabase_list_extensions	Lists all extensions in the database
supabase_list_migrations	Lists all migrations in the database
supabase_apply_migration	Applies a migration to the database
supabase_execute_sql	Executes raw SQL in the Postgres database
supabase_get_logs	Gets logs for a Supabase project by service type
supabase_get_project_url	Gets the API URL for a project
supabase_get_anon_key	Gets the anonymous API key for a project
supabase_generate_typescript_types	Generates TypeScript types for a project
supabase_create_branch	Creates a development branch on a Supabase project
supabase_list_branches	Lists all development branches of a Supabase project
supabase_delete_branch	Deletes a development branch
supabase_merge_branch	Merges migrations and edge functions from a development branch to production
supabase_reset_branch	Resets migrations of a development branch
supabase_rebase_branch	Rebases a development branch on production

For more details about tool input schema, use the list_tool API.