productivity
Grist MCP Integration for Codex
Connect Grist to Codex through the local KosmoKrator MCP gateway with scoped tools, credentials, and write policy.
Connect Grist 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.
Grist MCP Config for Codex
Keep write access denied or ask-based unless the workspace is trusted.
{
"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 Codex
Codex 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. |