Supabase MCP for AI Agents

Securely connect your AI agents and chatbots (Claude, ChatGPT, Cursor, etc) with Supabase MCP or direct API to manage projects, query and modify databases, deploy Edge Functions, and manage storage and logs through natural language.

Supabase MCP logoSupabase MCP
Dcr Oauth

Supabase MCP is Supabase's hosted MCP server for managing projects, databases, edge functions, storage, and workflows. Use it to manage Supabase resources and development workflows from a single hosted control plane.

32 Tools

Try Supabase MCP now

Type what you want done — sign in and watch it run live in the Tool Router playground.

TOOL ROUTER PLAYGROUND
Supabase MCP
Try asking
TOOLS

Supported Tools

Every Supabase MCP action and event your agent gets out of the box.

Apply migration

Applies a migration to the database.

Confirm cost

Ask the user to confirm their understanding of the cost of creating a new project or branch.

Create branch

Creates a development branch on a Supabase project.

Create project

Creates a new Supabase project.

Delete branch

Deletes a development branch.

Deploy edge function

Deploys an Edge Function to a Supabase project.

Execute sql

Executes raw SQL in the Postgres database.

Generate typescript types

Generates TypeScript types for a project.

Get advisors

Gets a list of advisory notices for the Supabase project.

Get cost

Gets the cost of creating a new project or branch.

Get edge function

Retrieves file contents for an Edge Function in a Supabase project.

Get organization

Gets details for an organization.

Get project

Gets details for a Supabase project.

Get project url

Gets the API URL for a project.

Get publishable keys

Gets all publishable API keys for a project, including legacy anon keys (JWT-based) and modern publishable keys (format: sb_publishable_.

Get storage config

Get the storage config for a Supabase project.

List branches

Lists all development branches of a Supabase project.

List edge functions

Lists all Edge Functions in a Supabase project.

List extensions

Lists all extensions in the database.

List migrations

Lists all migrations in the database.

List organizations

Lists all organizations that the user is a member of.

List projects

Lists all Supabase projects for the user.

List storage buckets

Lists all storage buckets in a Supabase project.

List tables

Lists all tables in one or more schemas.

Merge branch

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

Pause project

Pauses a Supabase project.

Query logs

Runs a custom read-only ClickHouse SQL query against a Supabase project's unified logs stream, for filtering, aggregating, or joining across log fields more precisely than a simple per-service log dump.

Rebase branch

Rebases a development branch on production.

Reset branch

Resets migrations of a development branch.

Restore project

Restores a Supabase project.

Search docs

Search the Supabase documentation using GraphQL.

Update storage config

Update the storage config for a Supabase project.

SETUP GUIDE

Connect Supabase MCP Tool with your Agent

1

Install Composio

typescript
npm install @composio/core ai @ai-sdk/openai @ai-sdk/mcp
Install the Composio SDK for Python or TypeScript
2

Initialize Client and Create Tool Router Session

typescript
import { Composio } from '@composio/core';

const composio = new Composio({ apiKey: 'your-api-key' });
const session = await composio.create('your-user-id');
console.log(`Tool Router session created: ${session.mcp.url}`);
Import and initialize the Composio client, then create a Tool Router session for Supabase MCP
3

Connect to AI Agent

typescript
import { openai } from '@ai-sdk/openai';
import { experimental_createMCPClient as createMCPClient } from '@ai-sdk/mcp';
import { generateText } from 'ai';

const client = await createMCPClient({
  transport: {
    type: 'http',
    url: session.mcp.url,
    headers: {
      'x-api-key': 'your-composio-api-key',
    },
  },
});

const tools = await client.tools();
const { text } = await generateText({
  model: openai('gpt-4o'),
  tools,
  messages: [{
    role: 'user',
    content: 'YOUR_SPECIFIC_PROMPT_HERE'
  }],
  maxSteps: 5,
});

console.log(`Agent: ${text}`);
Use the MCP server with your AI agent (Anthropic Claude or Mastra)
SETUP GUIDE

Connect Supabase MCP API Tool with your Agent

1

Install Composio

typescript
npm install @composio/openai
Install the Composio SDK
2

Initialize Composio and Create Tool Router Session

typescript
import OpenAI from 'openai';
import { Composio } from '@composio/core';
import { OpenAIResponsesProvider } from '@composio/openai';

const composio = new Composio({
  provider: new OpenAIResponsesProvider(),
});
const openai = new OpenAI({});
const session = await composio.create('your-user-id');
Import and initialize Composio client, then create a Tool Router session
3

Execute Supabase MCP Tools via Tool Router with Your Agent

typescript
const tools = session.tools;
const response = await openai.responses.create({
  model: 'gpt-4.1',
  tools: tools,
  input: [{
    role: 'user',
    content: "List all Supabase projects and for project 'my-project' list databases, branches, and recent Edge Function deployments"
  }],
});
const result = await composio.provider.handleToolCalls(
  'your-user-id',
  response.output
);
console.log(result);
Get tools from Tool Router session and execute Supabase MCP actions with your Agent

Why Use Composio?

AI Native Supabase MCP Integration

  • Supports both Supabase MCP and direct API based integrations
  • Structured, LLM-friendly schemas for reliable tool execution
  • Rich coverage for reading, writing, and querying your Supabase MCP data

Managed Auth

  • Built-in OAuth handling with automatic token refresh and rotation
  • Central place to manage, scope, and revoke Supabase MCP access
  • Per user and per environment credentials instead of hard-coded keys

Agent Optimized Design

  • Tools are tuned using real error and success rates to improve reliability over time
  • Comprehensive execution logs so you always know what ran, when, and on whose behalf

Enterprise Grade Security

  • Fine-grained RBAC so you control which agents and users can access Supabase MCP
  • Scoped, least privilege access to Supabase MCP resources
  • Full audit trail of agent actions to support review and compliance
FRAMEWORKS

Use Supabase MCP with any AI Agent Framework

Choose a Framework you want to connect Supabase MCP with

FAQ

Frequently asked questions

Yes, Supabase MCP requires you to configure your own Dcr Oauth credentials. Once set up, Composio handles secure credential storage and management for you.

Yes! Composio's Tool Router enables agents to use multiple toolkits. Learn more.

Composio is SOC 2 and ISO 27001 compliant with all data encrypted in transit and at rest. Learn more.

Composio maintains and updates all toolkit integrations automatically, so your agents always work with the latest API versions.

Start with Supabase MCP.It takes 30 seconds.

Managed auth, hosted MCP servers, and every Supabase MCP tool your agent needs.Free to start.

Start building