Grist

What is Grist?

Grist is a flexible spreadsheet-database that powers everything from CRMs to project trackers to inventory systems. The Grist MCP server lets agents work across your team sites and documents.

How to use Grist?

Configure any HTTP MCP client (e.g., Claude Desktop, ChatGPT) with type "http" and URL https://docs.getgrist.com/api/mcp. Authentication is handled via OAuth 2.0 with Dynamic Client Registration / CIMD; the bearer token identifies the user.

Key features of Grist

• Read orgs, workspaces, docs, tables, columns, and records
• Run SQL-style queries across tables in a doc
• Add, update, and remove records
• Create or remove tables and columns
• Create new documents from a description

Use cases of Grist

• Automate data entry and record updates across team sites
• Query spreadsheet data for reporting or analysis
• Manage document schemas by adding or removing tables and columns
• Generate new Grist documents from a plain‑language description

FAQ from Grist

What transport does Grist MCP use?

Streamable HTTP.

How do I authenticate with Grist MCP?

Authentication uses OAuth 2.0 (Dynamic Client Registration / CIMD). The bearer token identifies the user.

Does the same URL work for all users and team sites?

Yes, the URL https://docs.getgrist.com/api/mcp is shared; the OAuth bearer token determines which user and team site is accessed.

How do I configure Grist MCP in a client like Claude Desktop?

Add the following to your client configuration:

{
  "mcpServers": {
    "grist": {
      "type": "http",
      "url": "https://docs.getgrist.com/api/mcp"
    }
  }
}