Grist MCP Server

Name: Grist MCP Server
Author: nic01asFr

@nic01asFr

Repository

About Grist MCP Server

MCP server implementation for Grist API integration

Basic information

Config

Add this server to your MCP-compatible client using the configuration below.

{
  "mcpServers": {
    "mcp-server-grist": {
      "command": "uvx",
      "args": [
        "mcp-server-grist"
      ]
    }
  }
}

Tools

No tools detected

We auto-extract tools from the README. The maintainer can list them under a ## Tools heading to populate this section.

Overview

What is Grist MCP Server?

Grist MCP Server is a Model Context Protocol (MCP) server that enables large language models like Claude to access and manipulate data in Grist spreadsheets through the Grist API. It provides a structured interface for performing CRUD operations, querying data, and managing Grist resources directly from AI-assisted workflows.

How to use Grist MCP Server?

Install via uvx mcp-server-grist, pip install mcp-server-grist, or Docker. Set environment variables GRIST_API_KEY and optionally GRIST_API_HOST. Configure your MCP client (e.g., Claude Desktop) with the appropriate JSON settings pointing to the server command (uvx, python, or docker). Start the server with mcp-server-grist or python -m mcp_server_grist with desired transport (stdio, streamable-http, or SSE).

Key features of Grist MCP Server

List organizations, workspaces, documents, tables, and columns
Create, read, update, and delete records in Grist tables
Execute SQL queries (SELECT only) with parameters and timeouts
Filter and sort data with advanced querying capabilities
Manage user access to organizations, workspaces, and documents
Export documents as SQLite, Excel, or CSV; handle attachments and webhooks
Validate and create safe formulas for columns

Use cases of Grist MCP Server

Allow an AI assistant to query and update Grist spreadsheets directly
Automate data management tasks in Grist via natural language commands
Integrate Grist with external MCP‑compatible applications and workflows
Perform complex data analysis using SQL queries from within a chat interface
Manage Grist resources (documents, tables, permissions) programmatically

FAQ from Grist MCP Server

What are the dependencies and runtime requirements?

Python 3.8+ and the packages fastmcp, httpx, pydantic, and python-dotenv are required. You also need a valid Grist API key and access to a Grist instance (cloud or self‑hosted).

What transports are supported?

The server supports stdio, streamable-http, and SSE transports. For HTTP transports you can configure host, port, and path.

How do I authenticate with the Grist API?

Authentication is done via an API key set in the GRIST_API_KEY environment variable. The API key can be obtained from your Grist account settings.

Can I run custom SQL queries?

Yes, the server provides an execute_sql_query tool for arbitrary SELECT queries, including JOINs and subqueries, with configurable parameters and timeout. The server also has a filter_sql_query tool for