Query Grist with SQL
grist_query_sqlRun SQL queries with joins, aggregations, and complex filters on Grist documents. Supports parameterized queries for dynamic data retrieval.
Instructions
Execute SQL queries for JOINs, aggregations, and complex filters. Use grist_get_records for single-table queries without SQL. Supports parameterized q
Example: {"docId":"abc123","sql":"SELECT c.Name, o.Total FROM Customers c JOIN Orders o ON c.id = o.Customer"}
Use grist_help({tools:["grist_query_sql"]}) for full schema.
Input Schema
| Name | Required | Description | Default |
|---|---|---|---|
| docId | Yes | ||
| sql | Yes | ||
| parameters | No | ||
| response_format | No | ||
| offset | No | ||
| limit | No |