Executable connectorDatabaseJul 22, 20260 calls

Supabase Connector

Executable Supabase connector for PostgREST tables, Auth Admin users, and approved RPC calls.

Credential setup

bearer

Use the service role key only in private Astrail servers; Astrail also mirrors it to the required apikey header.

Setup docs: https://supabase.com/dashboard/project/_/settings/api

After adding this connector, attach the credential on the server page, then run astrail tools list.

Hosted MCP endpoint

/api/mcp/preset-supabase

Private servers require an Astrail API key in the Authorization header.

MCP client snippets

Connect

Claude Desktop config

{
  "mcpServers": {
    "supabase-connector": {
      "url": "/api/mcp/preset-supabase"
    }
  }
}

cURL initialize

curl -sS -X POST "/api/mcp/preset-supabase" \
  -H 'Content-Type: application/json' \
  --data '{"jsonrpc":"2.0","id":1,"method":"initialize","params":{}}'

cURL tools/list

curl -sS -X POST "/api/mcp/preset-supabase" \
  -H 'Content-Type: application/json' \
  --data '{"jsonrpc":"2.0","id":2,"method":"tools/list","params":{}}'

cURL tools/call

curl -sS -X POST "/api/mcp/preset-supabase" \
  -H 'Content-Type: application/json' \
  --data '{"jsonrpc":"2.0","id":3,"method":"tools/call","params":{"name":"supabase_list_tables","arguments":{"project_ref":"example"}}}'

Runtime behavior

Runtime healthhealthy

Endpoint healthnot_checked

Execution modesafe_rest_execution

Deterministic executionSupported

Generated sourceExport only

Endpoint mapAvailable

Endpoint mappedYes

Auth-required endpointsPresent

Browser runtime endpointsNone detected

Last statusnot recorded

Last execution modenot recorded

Last toolnot recorded

Last latencynot recorded

Upstream statusnot recorded

Trace IDnot recorded

Error codenone

Observabilitystructured fallback

Rate limit modestandard

Missing authauth_required / oauth_required

Missing mappingmapping_required

Astrail does not evaluate generated TypeScript inside Next.js. Hosted calls are routed through stored tool metadata and endpoint maps.

Tools

supabase_list_tables

Discover PostgREST table resources from the project's OpenAPI document.

supabase_select_rows

Select rows from a Supabase PostgREST table.

supabase_list_auth_users

List Auth users via the Supabase Auth Admin API.

supabase_rpc

Call a Supabase PostgREST RPC function after approval.

server.ts

import { McpServer } from "@modelcontextprotocol/sdk/server/mcp.js";
import { StdioServerTransport } from "@modelcontextprotocol/sdk/server/stdio.js";
import { z } from "zod";

const server = new McpServer({ name: "Supabase Connector", version: "1.0.0" });

// Curated Astrail connector for: supabase_list_tables, supabase_select_rows, supabase_list_auth_users, supabase_rpc.
// The hosted endpoint executes its verified deterministic endpoint map. Attach a least-privilege provider credential before calling private tools.

server.tool("connector_status", "Confirm this curated connector template is installed.", z.object({}), async () => ({
  content: [{ type: "text", text: "Connector installed. Attach provider credentials to enable hosted API calls." }],
}));

const transport = new StdioServerTransport();
await server.connect(transport);