It's an MCP (Model Context Protocol) server that connects Grist to your AI, giving the agent tools to act on your data — through a single remote link.

Which AI clients does it work with?

Any MCP-compatible client: Claude (web, desktop and mobile), Cursor, ChatGPT with connectors, OpenClaw and other agents.

No. Paste the remote URL into your client, authenticate once, and you're done — no packages to install, no code to write.

Is it secure? Can the AI change my data?

Access is authorized by you and can be revoked anytime. Permissions follow what Grist exposes; you approve them when connecting.

How much does it cost?

You start free and upgrade when you need more usage. Billing and limits are managed in your mcp.ai account.

Can I cancel anytime?

Yes. Plans are monthly and can be cancelled at any time, with no lock-in.

Grist MCP Server and REST API

Grist

Connect your Grist account and use 30 tools for productivity straight from your AI agent. Connect with your own API key. Grist is a relational spreadsheet platform that combines the flexibility of a spreadsheet with the robustness of a database, allowing users to create custom applications tailored to their data needs.

Install in your client

MCP server URL

https://api.mcp.ai/p_grist

Secure connection via OAuth 2.0

Tools (30)

For developers

API & agent docs

Machine-readable docs to plug this server into an agent or call it over REST.

Skill (how to use)

Markdown: use via MCP or via the direct REST API.

Open

llms.txt

Agent-readable spec of this server.

Open

For agents

Install prompt — paste into Claude, ChatGPT, Cursor or any MCP agent and it sets itself up.

Open

Postman collection

Import the REST API into Postman.

Download

FAQ

Grist

Tools (30)

API & agent docs

Frequently asked questions

Example prompts

Related tags

Grist

Tools (30)

grist_add_recordsAdd one or more records to a Grist table. First use GRIST_LIST_WORKSPACES to get docId, GRIST_LIST_TABLES to get tableId, and GRIST_LIST_COLUMNS to get column IDs for the fields mapping.

grist_create_documentCreates a new Grist document in a specified workspace. Use this tool when you need to add a new spreadsheet document to a workspace. Requires a valid workspace ID (obtainable via GRIST_LIST_WORKSPACES

grist_create_scim_userTool to create a new SCIM user. Use when provisioning new user accounts via SCIM. Run after gathering all required user details.

grist_create_tableTool to create tables in a document. Use after confirming the document ID. Creates one or more tables with specified columns in the given document.

grist_create_webhookTool to create a new webhook for a specified document. Use when you need to register webhook endpoints for document events in Grist. Run after confirming document ID.

grist_delete_attachmentRemove unused attachments from a Grist document to free up storage space. IMPORTANT: This action removes ALL attachments that are not currently referenced by any cell in the document. It does NOT dele

grist_delete_columnTool to delete a column from a Grist document table. Use after confirming document, table, and column IDs.

grist_delete_recordsTool to delete records from a specified Grist table. Use when you need to remove specific rows by their IDs. Use after confirming the row IDs exist.

grist_delete_scim_userDelete a user from the Grist organization by their numeric user ID. Use GRIST_GET_USERS first to find the user's ID. Falls back to org access API if SCIM is not enabled. Note: Cannot delete your own a

grist_delete_webhookPermanently removes a webhook from a Grist document. Use this tool when you need to stop receiving notifications for document changes. First use GRIST_LIST_WEBHOOKS to find the webhook_id you want to

grist_download_all_attachments_archiveDownload all attachments from a Grist document as a single archive file (.zip or .tar). Use this to bulk-download attachments. Ensure the document has attachments before calling (check with GRIST_LIST

grist_download_attachmentDownload a file attachment from a Grist document. Returns the file content as a downloadable file. Use GRIST_LIST_ATTACHMENTS first to get valid attachment IDs.

grist_fetch_document_metadataTool to fetch metadata for a specified Grist document. Use after obtaining the document ID.

grist_fetch_table_metadataTool to retrieve metadata for a specified table in a Grist document. Use when you need to inspect table schema details before data operations.

grist_get_org_accessRetrieves the list of users who have access to a Grist organization along with their access roles (owners, editors, viewers). Use this to find user IDs, emails, or check access permissions within an o

grist_get_usersTool to retrieve a list of users via SCIM v2. Use when you need to page through and filter enterprise users in Grist.

grist_list_attachmentsTool to list all attachments in a Grist document. Use after confirming the document ID to retrieve attachment metadata.

grist_list_columnsTool to list all columns in a specified Grist table. Use after selecting the document and table to inspect column metadata.

grist_list_organizationsTool to list all organizations accessible to the authenticated user. Use when you need to select a Grist organization for subsequent operations.

grist_list_recordsTool to retrieve records from a specified table within a Grist document. Use when you need to fetch rows by applying optional filters, sorting, limits, or hidden columns. Example: list records where p

grist_list_tablesTool to list all tables within a specified document. Use after obtaining the document ID to retrieve its tables.

grist_list_webhooksList all webhooks configured for a Grist document. Returns webhook configuration details (URL, event types, table binding) and delivery status information. Use this to inspect, audit, or manage webhoo

grist_list_workspacesTool to list all workspaces and documents accessible to the authenticated user on the current site. Use when you need to select a workspace or document for subsequent operations.

grist_run_sql_queryTool to execute a read-only SQL SELECT query on a Grist document. Use after confirming the document ID and preparing a valid SQL SELECT statement.

grist_update_column_metadataUpdates metadata (label, type, description, formula, etc.) for one or more columns in a Grist table. Use List Columns first to get valid column IDs. Warning: changing 'label' may rename the column ID

grist_update_document_metadataTool to update metadata for a specified Grist document. Use when you need to rename or pin/unpin a document after obtaining its ID.

grist_update_recordsUpdate existing records in a Grist table by their row IDs. Use this tool to modify field values for one or more records in a specified document and table. First use GRIST_LIST_RECORDS to obtain the re

grist_update_table_metadataUpdate metadata properties for a table in a Grist document. Currently the main updatable property is 'onDemand' which controls lazy loading of table data. Use List Tables to find valid table IDs first

grist_update_webhookUpdate an existing webhook configuration for a Grist document. Use to modify webhook settings such as URL, event types, enabled status, or target table. Requires valid document ID (from GRIST_LIST_WOR

grist_upload_attachmentUpload one or more file attachments to a Grist document. Returns attachment IDs that can be used to link files to records in Attachments-type columns. First use GRIST_LIST_WORKSPACES to get a valid do

API & agent docs

Frequently asked questions

What is Grist MCP?

Which AI clients does it work with?

Do I need to code?

Is it secure? Can the AI change my data?

How much does it cost?

Can I cancel anytime?

Example prompts

Related tags