grist_query_sql
Execute SQL queries to perform JOINs, aggregations, and complex filters on Grist document data. Use for multi-table analysis and advanced data retrieval operations.
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
TableJSON Schema
| Name | Required | Description | Default |
|---|---|---|---|
| docId | Yes | ||
| sql | Yes | ||
| parameters | No | ||
| response_format | No | ||
| offset | No | ||
| limit | No |