KosmoKrator

productivity

Grist MCP Integration for CrewAI

Connect Grist to CrewAI 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 CrewAI

Expose KosmoKrator integrations to CrewAI workers as scoped local tools.

Wrap kosmo integrations:call for specific tasks or connect workers to a local MCP gateway. The gateway is local, scoped to this integration, and starts with --write=deny so CrewAI can inspect read-capable tools without receiving write access by default.

Grist MCP Config for CrewAI

Use per-worker integration scopes to avoid giving every worker every tool.

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

CrewAI 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 CrewAIClient-level gateway setup.