Validating a schema before creating it, creating tables, columns and relations in a single pass, and resolving a reference column's visible column automatically are the parts that make constructing a Grist document from a conversation actually work — reference columns are where hand-rolled attempts usually break. Two notes: the SQL tool means analysis questions do not have to be assembled from record listings, and the tool descriptions the model reads are in French, which is worth knowing but does not change the arguments.
A full administrative surface over the Grist API, covering the whole hierarchy: organizations, workspaces, documents, tables, columns and records, plus access control, exports, attachments and webhooks. Tool descriptions are written in French.
- Navigation down the hierarchy — list_organizations, list_workspaces, list_documents, list_tables, list_columns — each with a describe_ counterpart for details
- list_records with sorting and a limit, get_table_schema for the structure behind them
- Records added, updated and deleted; add_grist_records_safe validates the table and column structure before writing, rather than failing halfway
- execute_sql_query runs a full SQL query against a document, with filter_sql_query as the simpler form for ordinary filters
- Tables and columns created, modified and deleted; create_reference_column builds a reference and resolves its visible column itself
- Schema tooling that reads like a migration path: validate_schema checks a schema without creating anything, create_schema builds tables, columns and relations in one pass, and export_schema dumps an existing document's schema
- Organizations, workspaces and documents created, modified, moved and deleted, with force_reload_document for synchronisation problems and delete_document_history for trimming a document's action history
- Access listed and modified at all three levels — organization, workspace and document
- Exports: a document as SQLite or Excel, a table as CSV
- Attachments listed, inspected, downloaded and uploaded
- Webhooks created, listed, modified and deleted, with clear_webhook_queue for a backlog of undelivered notifications
A Grist API key in GRIST_API_KEY, with GRIST_API_HOST pointing at the API — https://docs.getgrist.com/api for the hosted service, or your own instance. Python 3.8+; it runs as uvx mcp-server-grist, with a Docker image as the alternative. Whatever the API key's account can reach in Grist is what the tools can reach. MIT.
One command plus a key — uvx mcp-server-grist, then supply credentials