MCP Server Grist

An MCP service that implements Grist API interaction, providing a tool for integrating language models with Grist spreadsheets, supporting operations such as data query, addition, deletion, and modification.

Developer tools Research and data #Table integration #API tool #Data operation .Python

rating : 2.5 points

downloads : 18

update time : 2025-04-28

What is the Grist MCP Server?

The Grist MCP Server is a powerful tool that allows you to directly access and operate data in Grist spreadsheets through language models. You can easily list organizations, workspaces, documents, tables, and columns, and perform complex queries and data updates.

How to use the Grist MCP Server?

First, make sure you have installed Python 3.8+ and set the correct environment variables. Then, you can use the provided command-line tools to perform various operations, such as listing organizations and querying records.

Applicable scenarios

The Grist MCP Server is very suitable for users who need to regularly analyze and process large amounts of data, such as data scientists, business analysts, and technology developers.

Main features

List organizationsList all Grist organizations you have access to and their basic information.

List documentsList all documents in the specified workspace.

Query dataFilter and sort data according to conditions to obtain the desired results.

Add, update, and delete recordsAdd new records to the table, update existing records, or delete unwanted data.

Advantages and limitations

Advantages

Seamlessly integrate Grist and language models to improve work efficiency.

Support rich query functions to meet complex requirements.

API key authentication ensures data security.

Limitations

Requires a certain programming foundation for setup and use.

Has certain requirements for the network environment to ensure a stable connection.

How to use

Install dependencies

Make sure you have installed Python 3.8+ and the required packages: `fastmcp`, `httpx`, `pydantic`, `python-dotenv`.

Configure environment variables

Create a `.env` file and fill in your API key and host address.

Run the server

Start the server to start using Grist MCP.

Usage examples

List all organizationsView all organizations associated with your account through this command.

Query table dataFilter out records that meet the conditions based on the conditions.

Frequently Asked Questions

How to set up the API key?

What if I forget my API key?

What if I can't connect to the server?

Related resources

Official documentation

Learn more about the basic knowledge and advanced usage of Grist.

GitHub repository

View the source code and contribution guidelines.

Quick start video

Watch the demonstration video to learn how to get started quickly.

🚀 Grist MCP Server

A Grist API interaction tool that enables integration between Grist spreadsheets and language models.

🚀 Quick Start

This tool provides seamless integration between Grist spreadsheets and language models, facilitating easy data access and manipulation.

✨ Features

Directly access Grist data from language models.
List organizations, workspaces, documents, tables, and fields.
Query, add, update, and delete records in Grist tables.
Utilize rich query capabilities for filtering and sorting.
Secure authentication based on API keys.

📚 Documentation

list_organizations

List all Grist organizations accessible to the user.

Returns: A list of organizations containing ID, name, and domain.

list_workspaces

List all workspaces in a Grist organization.

Input:

org_id (int or string): The ID of the organization for which to list workspaces.

Returns: A list of workspaces containing ID and name.

list_documents

List all documents in a Grist workspace.

Input:

workspace_id (int): The ID of the workspace for which to list documents.

Returns: A list of documents containing ID and name.

list_tables

List all tables in a Grist document.

Input:

doc_id (string): The ID of the document containing the tables to list.
table_id (string): The ID of the table for which to list fields.

Returns: A list of columns containing ID and field data.

list_records

List records in a Grist table based on optional filtering, sorting, and limiting conditions.

Input:

doc_id (string): The ID of the document containing the table.
table_id (string): The ID of the table for which to list records.
filter_json (string, optional): A JSON string for filtering records (e.g., {"column_name": ["value1", "value2"]}).
sort (string, optional): A comma-separated list of sorting columns (prefix with '-' for descending order).
limit (int, optional): The maximum number of records to return.

Returns: A list of records containing ID and field data.

add_grist_records

Add records to a Grist table.

Input:

doc_id (string): The ID of the document containing the table.
table_id (string): The ID of the table to which to add records.
records (array): A list of records to add (each record is a dictionary of field values).

Returns: A list of IDs of the newly created records.

update_grist_records

Update records in a Grist table.

Input:

doc_id (string): The ID of the document containing the table.
table_id (string): The ID of the table in which to update records.
records (array): A list of records to update (each record is a dictionary of field values).

Returns: The number of successfully updated records.

delete_grist_records

Delete records from a Grist table.

Input:

doc_id (string): The ID of the document containing the table.
table_id (string): The ID of the table from which to delete records.
records (array): A list of records to delete (each record is a dictionary of field values).

Returns: The number of successfully deleted records.

💻 Usage Examples

Basic Usage

Docker

docker build -t mcp/grist-mcp-server .

📦 Installation

pip install mcp-server-grist

Or install manually:

git clone https://github.com/yourusername/mcp-server-grist.git
cd mcp-server-grist
pip install -r requirements.txt

📄 License

This MCP server is licensed under the MIT License.

Featured MCP Services

Gitlab MCP Server

Certified

The GitLab MCP server is a project based on the Model Context Protocol that provides a comprehensive toolset for interacting with GitLab accounts, including code review, merge request management, CI/CD configuration, and other functions.

TypeScript

4.3 points

Markdownify MCP

Markdownify is a multi-functional file conversion service that supports converting multiple formats such as PDFs, images, audio, and web page content into Markdown format.

A Python-based MCP Server that provides advanced to-do list management and content organization functions through the Notion API, enabling seamless integration between AI models and Notion.

Python

150

4.5 points

Duckduckgo MCP Server

Certified

The DuckDuckGo Search MCP Server provides web search and content scraping services for LLMs such as Claude.

Framelink Figma MCP Server is a server that provides access to Figma design data for AI programming tools (such as Cursor). By simplifying the Figma API response, it helps AI more accurately achieve one - click conversion from design to code.

UnityMCP is a Unity editor plugin that implements the Model Context Protocol (MCP), providing seamless integration between Unity and AI assistants, including real - time state monitoring, remote command execution, and log functions.

573

5 points

Context7

Context7 MCP is a service that provides real-time, version-specific documentation and code examples for AI programming assistants. It is directly integrated into prompts through the Model Context Protocol to solve the problem of LLMs using outdated information.

A Gmail automatic authentication MCP server designed for Claude Desktop, supporting Gmail management through natural language interaction, including complete functions such as sending emails, label management, and batch operations.

TypeScript

289

4.5 points

Zhiqi Future, Your AI Solution Think Tank

English 简体中文繁體中文にほんご