Grist MCP server
io.github.gwhthompson/grist-mcp-server·v2.0.33·3 stars11 tools for managing Grist documents with AI
3 stars252 downloads/wk
Reviews
Write oneNobody has reviewed Grist yet.
If you have run it, two minutes of your experience saves the next person an afternoon.
Grist tools (21, 9 write)
write = sends, deletes, buys or postsRead from the package source without running it. The installed server may list more.
grist_build_pagewrite actionCreate pages with widget patterns (master-detail, hierarchical, chart dashboard)
grist_configure_widgetConfigure widget properties, linking, sorting, and filtering
grist_create_documentwrite actionCreate a new document or fork an existing one
grist_create_summary_tablewrite actionCreate an aggregated summary table from a source table
grist_create_tablewrite actionCreate a new table with column definitions
grist_delete_tablewrite actionPermanently delete a table and all its data
grist_get_documentsFind documents by ID, name, or workspace
grist_get_pagesList pages and widgets in a document
grist_get_recordsFetch records with optional filters
grist_get_tablesGet table and column schema
grist_get_workspacesList accessible workspaces
grist_helpGet documentation and schemas for Grist tools. Omit params to list all tools. Use tools array for detailed help. Ex: {} → list all, {tools:["grist_manage_schema","grist_manage_records"]} → docs + schemas
grist_manage_columnsAdd, update, delete, or rename columns
grist_manage_conditional_rulesAdd, update, remove, or list conditional formatting rules
grist_manage_pagesDeclarative page layouts with widget arrangement and linking. Also: rename/delete/reorder pages, configure widget sorting.
grist_manage_recordsRecord CRUD: add, update, delete, or upsert. Single or batch operations. Supports cross-table dependencies (add Company, then Contact referencing it).
grist_manage_schemawrite actionCreate/rename/delete tables, add/modify/remove columns, create summary tables
grist_manage_webhookswrite actionCreate, update, delete, or list webhooks in batch for real-time notifications
grist_query_sqlwrite actionExecute SQL for JOINs, aggregations, and complex queries
grist_rename_tableRename a table
grist_update_pagewrite actionRename, reorder, or delete pages
Public scan report
scanner v0.1.10 · 2026-10-01 · same rubric, same numbers if you re-run it
- Code scan322 source files scanned20/25
- –Live reliabilityno gateway calls yet and no remote to proben/a
- –Tool poisoningtools not inspected (local package is not executed); not countedn/a
- Auth qualitystatic API keys via environment variables6/15
- Maintenancelast push 244 days ago4/15
- Maintainer identityregistry namespace matches repository owner; GitHub account older than a year8/10
Findings (1)
- mediumeval / new Function used
exec.evalbundle/index.js: …(J=this.opts.code.process(J,f));const Y=new Function(`${n.default.self}`,`${n.default.scope}`…
How Grist compares
Against every graded MCP server, from our own scans and uptime checks. Updated after each scan run.
- Safety score
- 58/100
- higher than 13% of 48,255 servers
- Tools
- 21
- the typical server has 7
- Tools that change things
- 43%
- typical: 0%. Fewer write tools means less an agent can break
- GitHub stars
- 3
- more than 80% of 28,688 servers
- Downloads a week
- 252
- more than 78% of 12,191 servers with a package
What its tools let an agent do: 12 read · 9 change
Install Grist in Claude Code, Cursor or VS Code
Runs npx -y grist-mcp-server on your machine. Read the scan report first; the gateway never runs local packages.
claude mcp add grist-mcp-server -- npx -y grist-mcp-server
What the publisher says
From the Grist repository's README, as published. We do not edit it. Read it on GitHub
Grist MCP Server
MCP server for Grist. 11 tools for documents, records, SQL, and pages.
Quick Start
Claude Code (recommended)
claude mcp add grist --env GRIST_API_KEY=your_api_key --env GRIST_BASE_URL=https://docs.getgrist.com -- npx -y grist-mcp-serverClaude Desktop (MCPB bundle)
- Download grist-mcp-server.mcpb from Releases
- In Claude Desktop: Settings → Developer → MCP Servers → Install from MCPB
- Configure your Grist API key and base URL
- Restart Claude Desktop
Manual configuration (.mcp.json)
Add to your .mcp.json file:
{
"mcpServers": {
"grist": {
"command": "npx",
"args": ["-y", "grist-mcp-server"],
"env": {
"GRIST_API_KEY": "your_api_key",
"GRIST_BASE_URL": "https://docs.getgrist.com"
}
}
}
}Install from source
git clone https://github.com/gwhthompson/grist-mcp-server.git
cd grist-mcp-server
npm install && npm run buildAdd to your MCP config:
{
"mcpServers": {
"grist": {
"command": "node",
"args": ["/path/to/grist-mcp-server/dist/index.js"],
"env": {
"GRIST_API_KEY": "your_api_key",
"GRIST_BASE_URL": "https://docs.getgrist.com"
}
}
}
}Cloudflare Workers (HTTP transport)
Deploy as a remote MCP server using Cloudflare Workers for HTTP-based access.
Local development:
npm run worker:devDeploy to Cloudflare:
npm run worker:deployConfiguration:
The Workers deployment uses header-based authentication:
- X-Grist-API-Key: Your Grist API key (required)
- X-Grist-Base-URL: Grist instance URL (optional, defaults to https://docs.getgrist.com)
Endpoint: https://your-worker.workers.dev/mcp
Example request:
curl -X POST https://your-worker.workers.dev/mcp \
-H "Content-Type: application/json" \
-H "X-Grist-API-Key: your_api_key" \
-d '{"jsonrpc":"2.0","method":"tools/list","id":1}'Notes:
- Stateless design: Each request creates a fresh server instance
- CORS enabled for all origins (safe because auth uses headers, not cookies)
- Configure environment variables via wrangler secret put GRISTAPIKEY
Tools
<!-- TOOLSTABLESTART -->
<!-- TOOLSTABLEEND -->
Examples
Create a database
1. grist_get_workspaces → find workspace
2. grist_create_document → create document
3. grist_manage_schema → create tables with columnsImport data
Shortened. The full README is on GitHub.
Nothing above is checked by us. What we check is on the safety report.
Grist: common questions
- Is Grist MCP server safe?
- With care: it is graded C, so read the findings first (58/100). Read the Grist safety report
- How do I install Grist?
- It runs on your machine. Copy the Claude Code, Cursor, VS Code or Claude Desktop config from the install section.
- Does Grist need an API key?
- Yes. The registry entry asks for
GRIST_API_KEY. - Is Grist maintained?
- The last commit was 278 days ago (2026-01-30). The latest release is v2.0.33.
- How does Grist compare with other MCP servers?
- safety score 58/100 (higher than 13% of 48,255 servers); tools 21 (the typical server has 7); tools that change things 43% (typical: 0%. Fewer write tools means less an agent can break). Full comparison.