Grist

About

The Grist MCP Server serves as a powerful bridge, connecting the Model Context Protocol (MCP) to your Grist instances. It provides a comprehensive set of 11 tools, enabling programmatic interaction with Grist documents, records, and schemas. Users can perform advanced operations such as running SQL queries with joins and aggregations, managing record CRUD operations, defining and modifying database schemas, creating new documents, and setting up webhooks for real-time notifications. This integration streamlines Grist workflows and unlocks automation possibilities through the MCP framework.

Key Features

• Execute SQL queries with JOINs and aggregations across Grist tables
• Perform full CRUD (Create, Read, Update, Delete) operations on Grist records, including upsert functionality
• Manage Grist schema, including creating and modifying tables, columns, and summary tables
• List and filter Grist workspaces and documents
• 0 GitHub stars
• Create new Grist documents or duplicate existing ones programmatically
• Establish and manage webhooks for real-time event notifications within Grist

Use Cases

• Run complex data analysis by executing SQL queries directly against Grist data, including joins and aggregations
• Automate the creation of new Grist databases, including documents, tables, and columns
• Programmatically import and update data into Grist tables, handling both new and existing records