KosmoKrator

other

Supabase MCP Integration for Codex

Connect Supabase to Codex 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 Codex

Use KosmoKrator as a local MCP proxy for Codex so coding sessions can reach selected integrations with explicit write policy.

Register kosmo mcp:serve as a local stdio server and choose the integration allowlist. The gateway is local, scoped to this integration, and starts with --write=deny so Codex can inspect read-capable tools without receiving write access by default.

Supabase MCP Config for Codex

Keep write access denied or ask-based unless the workspace is trusted.

{
  "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 Codex

Codex 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 CodexClient-level gateway setup.