productivity
Grist MCP Integration for Vercel AI SDK
Connect Grist to Vercel AI SDK through the local KosmoKrator MCP gateway with scoped tools, credentials, and write policy.
Connect Grist to Vercel AI SDK
Use KosmoKrator as a local integration gateway for Vercel AI SDK agents and scripts.
Create an MCP client that starts or connects to the KosmoKrator gateway for the selected integration. The gateway is local, scoped to this integration, and starts with
--write=deny so Vercel AI SDK can inspect read-capable tools without receiving write access by default.
Grist MCP Config for Vercel AI SDK
Prefer CLI JSON calls when a workflow only needs one deterministic integration operation.
{
"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 Vercel AI SDK
Vercel AI SDK 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. |