Grist MCP Server
MCP server with 11 tools for Grist documents, records, SQL and page layouts
- Pricing
- Open source
- Platforms
- CLI, API, self-hosted
- Runs
- Locally
- Version
- 2.0.34
- Listing updated
- today
Similar MCP servers
About Grist MCP Server
Grist MCP Server is an open-source MCP server for databases. It runs locally on your machine and is started by your AI client.
This community server connects an assistant to Grist, the spreadsheet-database tool, through the Grist API. Tools cover finding workspaces and documents, reading table schemas, fetching records with filters, running SQL with joins and aggregations, and managing records, schema, pages and webhooks. A grist_help tool returns documentation and JSON schemas for the others on demand.
One tool handles all record operations (add, update, delete and upsert), and another handles tables, columns and summaries, so a short chain such as find workspace, create document, create tables can build a small database from chat. It works with docs.getgrist.com or a self-hosted instance through GRIST_BASE_URL.
It runs locally over stdio from npm, as an MCPB bundle for Claude Desktop, from source, or as a stateless HTTP server on Cloudflare Workers that reads the API key from a request header. A Grist API key is required.
Install
Run in a terminal
claude mcp add grist-mcp-server --env GRIST_API_KEY='<GRIST_API_KEY>' -- npx -y grist-mcp-serverAdd to claude_desktop_config.json
{
"mcpServers": {
"grist-mcp-server": {
"command": "npx",
"args": [
"-y",
"grist-mcp-server"
],
"env": {
"GRIST_API_KEY": "<GRIST_API_KEY>"
}
}
}
}Add to ~/.cursor/mcp.json
{
"mcpServers": {
"grist-mcp-server": {
"command": "npx",
"args": [
"-y",
"grist-mcp-server"
],
"env": {
"GRIST_API_KEY": "<GRIST_API_KEY>"
}
}
}
}Add to .vscode/mcp.json
{
"servers": {
"grist-mcp-server": {
"type": "stdio",
"command": "npx",
"args": [
"-y",
"grist-mcp-server"
],
"env": {
"GRIST_API_KEY": "<GRIST_API_KEY>"
}
}
}
}Add to ~/.codeium/windsurf/mcp_config.json
{
"mcpServers": {
"grist-mcp-server": {
"command": "npx",
"args": [
"-y",
"grist-mcp-server"
],
"env": {
"GRIST_API_KEY": "<GRIST_API_KEY>"
}
}
}
}Add to your client's MCP settings (most use this shape)
{
"mcpServers": {
"grist-mcp-server": {
"command": "npx",
"args": [
"-y",
"grist-mcp-server"
],
"env": {
"GRIST_API_KEY": "<GRIST_API_KEY>"
}
}
}
}Using several servers? Build one config file with the MCP config generator.
Configuration
GRIST_API_KEYYour Grist API keyRequiredGRIST_BASE_URLBase URL for Grist instance (default: https://docs.getgrist.com)
Tools this server provides (11)
Taken from the project documentation; the running server may differ.
- grist_get_workspaces
- List and filter workspaces.
- grist_get_documents
- Find documents by ID, name or workspace.
- grist_get_tables
- Get table structure and schema.
- grist_query_sql
- Run SQL queries with joins and aggregations.
- grist_get_records
- Fetch records with filters.
- grist_manage_records
- Add, update, delete and upsert records.
- grist_manage_schema
- Schema operations: tables, columns, summaries.
- grist_manage_pages
- Page layout and management.
- grist_create_document
- Create new Grist documents or copy existing ones.
- grist_manage_webhooks
- Create and manage webhooks.
- grist_help
- Discover tools and get documentation with JSON schemas.
What it does
- SQL queries
- Run SQL with joins and aggregations.
- Record operations
- Add, update, delete and upsert in one tool.
- Schema management
- Create tables, columns and summaries.
- Webhooks
- Create and manage real-time event notifications.
- Self-hosted support
- Point it at your own Grist instance.
- Workers deployment
- Optional remote HTTP server on Cloudflare.
Good for
- Build a small database from a chat
- Import data with upserts
- Query tables with SQL joins
- Adjust page layouts
- Set up webhooks on a document
Pricing
Open source
Free open-source package; a Grist account and API key are needed
Grist MCP Server FAQ
Which Grist can it use?
docs.getgrist.com by default, or a self-hosted instance via GRIST_BASE_URL.
What is required?
A Grist API key.
How is it installed?
Via npx, an MCPB bundle, from source, or on Cloudflare Workers.
How many tools?
Eleven.
Is Grist MCP Server free?
Yes. Grist MCP Server is open source, so you can use and self-host it for free.
How do I add Grist MCP Server to Claude Code?
Run this command in your terminal: claude mcp add grist-mcp-server --env GRIST_API_KEY='<GRIST_API_KEY>' -- npx -y grist-mcp-server
What are the best alternatives to Grist MCP Server?
The closest alternatives to Grist MCP Server are Ha MCP, Concord MCP, Midplane, note1 and Todoist.
Where this comes from
- Description: written from the project's README.
- Install steps: from the official MCP Registry entry.
