Grist is a flexible spreadsheet-database. The Grist MCP server lets agents work across your team sites and documents: list and query records, add or update rows, create new docs and tables. Universal URL with OAuth 2.0. Works in Claude, ChatGPT, and any MCP client that supports remote HTTP servers.
Overview
Grist MCP Server
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.
What it can do
- Read: list orgs, workspaces, docs, tables, columns, records.
- Query: run SQL-style queries across the tables in a doc.
- Write: add, update, remove records.
- Schema: create or remove tables and columns.
- Create new documents from a description.
Connect
- MCP URL:
https://docs.getgrist.com/api/mcp - Transport: Streamable HTTP
- Authentication: OAuth 2.0 (Dynamic Client Registration / CIMD)
The same URL works for every user and every team site, the OAuth bearer token identifies you.
Documentation
- Setup guide and tool list: https://support.getgrist.com/mcp
- Grist website: https://www.getgrist.com
- Privacy policy: https://www.getgrist.com/privacy/
Quick example config (Claude Desktop, ChatGPT, any HTTP MCP client)
{
"mcpServers": {
"grist": {
"type": "http",
"url": "https://docs.getgrist.com/api/mcp"
}
}
}
Server Config
{
"mcpServers": {
"grist": {
"type": "http",
"url": "https://docs.getgrist.com/api/mcp"
}
}
}