Skip to content
MCP server

Grist MCP Server

MCP server with 11 tools for Grist documents, records, SQL and page layouts

Runs locallyStatus and history
Install
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-server

Add 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 keyRequired
  • GRIST_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.

How AIPoweredBot checks servers