KosmoKrator

other

Supabase MCP Integration for Generic MCP Clients

Connect Supabase to Generic MCP Clients 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 Generic MCP Clients

Connect any stdio-compatible MCP client to local KosmoKrator integration tools.

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

Supabase MCP Config for Generic MCP Clients

Start with read-only write policy and expand only for trusted projects.

{
  "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 MCP clients

MCP clients 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 MCP clientsClient-level gateway setup.