KosmoKrator

other

Supabase MCP Integration for OpenAI Agents SDK

Connect Supabase to OpenAI Agents SDK through the local KosmoKrator MCP gateway with scoped tools, credentials, and write policy.

9 functions 9 read 0 write Bearer token auth
Submit Supabase feedback View package source

Connect Supabase to OpenAI Agents SDK

Attach KosmoKrator integration tools to OpenAI Agents SDK workflows through a local MCP gateway.

Start the KosmoKrator MCP gateway locally and point the OpenAI Agents SDK MCP tool at that process or wrapper. The gateway is local, scoped to this integration, and starts with --write=deny so OpenAI Agents can inspect read-capable tools without receiving write access by default.

Supabase MCP Config for OpenAI Agents SDK

Use headless JSON commands for CI-style execution and MCP for agent tool discovery.

{
  "mcpServers": {
    "kosmokrator-supabase": {
      "type": "stdio",
      "command": "kosmo",
      "args": [
        "mcp:serve",
        "--integration=supabase",
        "--write=deny"
      ]
    }
  }
}

Run the Gateway Manually

kosmokrator mcp:serve --integration=supabase --write=deny

Why Use KosmoKrator Here

Scoped tools

Expose only Supabase instead of a broad multi-service tool list.

Local credentials

Reuse credentials already configured for the KosmoKrator CLI and Lua runtime.

Write policy

Start read-only, then opt into ask or allow for trusted workspaces.

Supabase Tools Visible to OpenAI Agents

OpenAI Agents sees stable MCP tool names generated from the Supabase integration catalog.

MCP toolSource functionTypeDescription
integration__supabase__supabase_get_current_user supabase.supabase_get_current_user Read Get the currently authenticated Supabase user profile information.
integration__supabase__supabase_get_project supabase.supabase_get_project Read Get details of a specific Supabase project by its reference ID.
integration__supabase__supabase_get_row supabase.supabase_get_row Read Get a single row from a Supabase table by its ID.
integration__supabase__supabase_get_settings supabase.supabase_get_settings Read Get the OpenAPI spec info for the Supabase PostgREST instance. Returns database metadata, available tables, and schema information.
integration__supabase__supabase_get_table supabase.supabase_get_table Read Get details of a specific table in a Supabase project by its ID.
integration__supabase__supabase_list_projects supabase.supabase_list_projects Read List all Supabase projects in the organization. Returns project IDs, names, and regions.
integration__supabase__supabase_list_rows supabase.supabase_list_rows Read List rows in a Supabase table. Returns row data and metadata.
integration__supabase__supabase_list_tables supabase.supabase_list_tables Read List all tables in a Supabase project. Returns table IDs, names, and schemas.
integration__supabase__supabase_query_with_filters supabase.supabase_query_with_filters Read Query a Supabase table using advanced PostgREST filter operators. Provide filters as a JSON array of objects, each with "column", "operator", and "value" keys. Supported operators: eq, neq, gt, gte, lt, lte, like, ilike, in, is, cs, cd, ov, sl, sr, nxr, nxl, adj, not, or, and. Example filters_json: [ {"column": "status", "operator": "eq", "value": "active"}, {"column": "age", "operator": "gte", "value": 18} ]

Related Supabase Pages

Supabase CLIUse direct JSON commands instead of MCP discovery. Supabase MCPFull gateway reference and MCP tool names. KosmoKrator for OpenAI AgentsClient-level gateway setup.