Grist Mcp Server
Connects Claude to Grist's spreadsheet database through 11 tools covering the full API surface. You get workspace and document discovery, SQL queries with JOINs, record CRUD operations with upsert support, schema management for tables and columns, and webhook configuration. The workflow is straightforward: find your workspace, locate or create a document, inspect the table structure, then query or manipulate data. Ships with both stdio transport for local Claude Desktop use and a Cloudflare Workers deployment option for HTTP access. Includes a help tool that surfaces detailed examples and error documentation for each operation, which matters since the base tool descriptions stay minimal.
- GitHub stars
- 4
- tools
- 11
- auth
- Secret needed
- transport
- STDIO
- env vars
- 2
- last updated
- Nov 12, 2026
Tools
11 toolsPublic tool metadata for what this MCP can expose to an agent.
grist_get_workspacesList and filter workspaces
List and filter workspaces
No parameter schema in public metadata yet.
grist_get_documentsFind documents by ID, name, or workspace
Find documents by ID, name, or workspace
No parameter schema in public metadata yet.
grist_get_tablesGet table structure and schema
Get table structure and schema
No parameter schema in public metadata yet.
grist_query_sqlRun SQL queries with JOINs and aggregations
Run SQL queries with JOINs and aggregations
No parameter schema in public metadata yet.
grist_get_recordsFetch records with filters
Fetch records with filters
No parameter schema in public metadata yet.
grist_manage_recordsAll record CRUD operations (add/update/delete/upsert)
All record CRUD operations (add/update/delete/upsert)
No parameter schema in public metadata yet.
grist_manage_schemaSchema operations: tables, columns, summaries
Schema operations: tables, columns, summaries
No parameter schema in public metadata yet.
grist_manage_pagesPage layout and management
Page layout and management
No parameter schema in public metadata yet.
grist_create_documentCreate new Grist documents or copy existing ones
Create new Grist documents or copy existing ones
No parameter schema in public metadata yet.
grist_manage_webhooksCreate and manage webhooks for real-time event notifications
Create and manage webhooks for real-time event notifications
No parameter schema in public metadata yet.
grist_helpDiscover tools and get detailed documentation with JSON schemas
Discover tools and get detailed documentation with JSON schemas
No parameter schema in public metadata yet.
Sponsors
Agent CaffeineSponsoredClose your lid, come back to finished work
SnugSponsoredThe clipboard manager for the AI eraPromote your product hereReach 125k+ visitors monthly
WaxSponsoredBlock anything with supervision, without erasing your iPhonePromote your product hereReach 125k+ visitors monthly
knobsSponsoredSee your site on any phone, any day, in any languageConfiguration
GRIST_API_KEY*secretYour Grist API key
GRIST_BASE_URLdefault: https://docs.getgrist.comBase URL for Grist instance (default: https://docs.getgrist.com)
Readme
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-server
Claude Desktop (MCPB bundle)
- Download
grist-mcp-server.mcpbfrom 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)
Details
- Repository
- github.com/gwhthompson/grist-mcp-server
- Package
grist-mcp-server- Transport
- STDIO
- Auth
- Required
- Registry
- MCP registry, active