Supabase MCP Server

Local

API Integration

Integrate this MCP server into your applications.

Get your API Key

You'll need to login and generate a Smithery API key to connect to this server.

Installation

Install the official MCP SDKs using npm:

npm install @modelcontextprotocol/sdk

TypeScript SDK

typescript


import { StreamableHTTPClientTransport } from "@modelcontextprotocol/sdk/client/streamableHttp.js"

const serverUrl = new URL("https://server.smithery.ai/@davesbits/supabase-mcp-server/mcp")
const config = {
  "supabaseRegion": "string",
  "supabaseDbPassword": "postgres",
  "supabaseProjectRef": "127.0.0.1:54322",
  "supabaseAccessToken": "string",
  "supabaseServiceRoleKey": "string"
}
const configString = JSON.stringify(config)
serverUrl.searchParams.set("config", btoa(configString))
serverUrl.searchParams.set("api_key", "your-smithery-api-key")

const transport = new StreamableHTTPClientTransport(serverUrl)

// Create MCP client
import { Client } from "@modelcontextprotocol/sdk/client/index.js"

const client = new Client({
	name: "Test client",
	version: "1.0.0"
})
await client.connect(transport)

// Use the server tools with your LLM application
const tools = await client.listTools()
console.log(`Available tools: ${tools.map(t => t.name).join(", ")}`)

Configuration Schema

Full JSON Schema for server configuration:

json

{
  "type": "object",
  "required": [
    "supabaseProjectRef",
    "supabaseDbPassword",
    "supabaseRegion"
  ],
  "properties": {
    "supabaseRegion": {
      "type": "string",
      "description": "(required) - AWS region where your Supabase project is hosted - Default: us-east-1"
    },
    "supabaseDbPassword": {
      "type": "string",
      "default": "postgres",
      "description": "(required) - Database password - Default: postgres"
    },
    "supabaseProjectRef": {
      "type": "string",
      "default": "127.0.0.1:54322",
      "description": "(required) - Supabase project reference ID - Default: 127.0.0.1:54322"
    },
    "supabaseAccessToken": {
      "type": "string",
      "description": "(optional) - Personal access token for Supabase Management API - Default: none"
    },
    "supabaseServiceRoleKey": {
      "type": "string",
      "description": "(optional) - Project Service Role Key for Auth Admin SDK - Default: none"
    }
  }
}