mcp-server-grist
7
The Grist MCP Server is designed to facilitate seamless interaction with the Grist API, enabling comprehensive management and manipulation of data from language models. It supports advanced querying and secure access to Grist environments.
Grist MCP Server
A Model Context Protocol (MCP) server to interact with the Grist API, allowing access and manipulation of Grist data directly from language models like Claude.
Prerequisites
- Python 3.8+
- A valid Grist API key
- Required Python packages: fastmcp, httpx, pydantic, python-dotenv
Features
- Access Grist data directly from language models
- List organizations, workspaces, documents, tables, and columns
- Manage records (create, read, update, delete)
- Advanced query capabilities, including filtering and sorting
- Support for SQL queries (SELECT only)
- Secure authentication via API key
Available Tools
- Manage organizations and documents
- Handle tables and columns
- Data manipulation: add, update, and delete records
- Filtering and SQL queries: filter_sql_query and execute_sql_query for advanced queries
Use Cases
- Analyze and summarize Grist data
- Programmatically create, update, and delete records
- Build reports and visualizations
- Use natural language queries to interact with Grist data