KosmoKrator

productivity

Grist MCP Integration for OpenAI Agents SDK

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

13 functions 9 read 4 write API key auth
Submit Grist feedback View package source

Connect Grist 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.

Grist MCP Config for OpenAI Agents SDK

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

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

Run the Gateway Manually

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

Why Use KosmoKrator Here

Scoped tools

Expose only Grist 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.

Grist Tools Visible to OpenAI Agents

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

MCP toolSource functionTypeDescription
integration__grist__grist_list_workspaces grist.grist_list_workspaces Read List all workspaces in a Grist organization.
integration__grist__grist_get_workspace grist.grist_get_workspace Read Get details for a single Grist workspace, including its documents.
integration__grist__grist_list_docs grist.grist_list_docs Read List all documents in a Grist organization.
integration__grist__grist_get_doc grist.grist_get_doc Read Get details for a single Grist document by ID.
integration__grist__grist_list_tables grist.grist_list_tables Read List all tables in a Grist document.
integration__grist__grist_get_table grist.grist_get_table Read Get a single table from a Grist document.
integration__grist__grist_list_records grist.grist_list_records Read List records from a Grist table with optional filtering, sorting, and limiting.
integration__grist__grist_get_record grist.grist_get_record Read Get full column data for a Grist table (raw cell values per column).
integration__grist__grist_create_records grist.grist_create_records Write Create one or more records in a Grist table.
integration__grist__grist_update_records grist.grist_update_records Write Update one or more existing records in a Grist table.
integration__grist__grist_delete_records grist.grist_delete_records Write Delete records from a Grist table by row IDs.
integration__grist__grist_create_column grist.grist_create_column Write Create a new column in a Grist table.
integration__grist__grist_list_columns grist.grist_list_columns Read List all columns in a Grist table.

Related Grist Pages

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