広告掲載
MCP.so
ログイン

Grist MCP Server

@nic01asFr

リポジトリ

基本情報

カテゴリ

その他

ライセンス

MIT

トランスポート

stdio

作者

nic01asFr

Grist MCP Server について

MCP server implementation for Grist API integration

Grist MCP Server の設定

以下の設定を使って、このサーバーを MCP 対応クライアントに追加してください。

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

Grist MCP Server のツール

ツール一覧はまだありません

この掲載には表示できるツール一覧がまだありません。サーバーにツールがないという意味ではありません。対応機能はプロジェクトのドキュメントをご確認ください。

上のボタンで一時的なサンドボックスでこのサーバーを実行し、ツール一覧を取得できます。

概要

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

よくある質問

1

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).

2

What transports are supported?

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

3

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.

4

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

コメント

「その他」の他のコンテンツ

🚀 Model Context Protocol (MCP) Curriculum for Beginners

microsoft

This open-source curriculum introduces the fundamentals of Model Context Protocol (MCP) through real-world, cross-language examples in .NET, Java, TypeScript, JavaScript, Rust and Python. Designed for developers, it focuses on practical techniques for building modular, scalable,

16.7K

FastMCP v2 🚀

jlowin

🚀 The fast, Pythonic way to build MCP servers and clients.

26.0K

Blender

ahujasid

Open-source MCP to use Blender with any LLM

23.6K

Maestro

mobile-dev-inc

Painless E2E Automation for Mobile and Web

14.8K

Volley.sh

Volley

A good sequence diagram can solve almost any communication problem in engineering. Volley lets your agent write them as plain text, with the real request and response payloads on every arrow. It checks its own syntax wi

広告掲載