productivity
Grist MCP Integration for Generic MCP Clients
Connect Grist to Generic MCP Clients through the local KosmoKrator MCP gateway with scoped tools, credentials, and write policy.
Connect Grist 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.
Grist MCP Config for Generic MCP Clients
Start with read-only write policy and expand only for trusted projects.
{
"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
Expose only Grist instead of a broad multi-service tool list.
Reuse credentials already configured for the KosmoKrator CLI and Lua runtime.
Start read-only, then opt into ask or allow for trusted workspaces.
Grist Tools Visible to MCP clients
MCP clients sees stable MCP tool names generated from the Grist integration catalog.
| MCP tool | Source function | Type | Description |
|---|---|---|---|
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. |