query_project_state
Read-onlyIdempotent
Query project data using SQL-like filters, joins, and pagination to retrieve tasks, milestones, files, and more without writing raw SQL.
Instructions
Flexible SQL-like query interface for complex project queries. Provides powerful filtering and joining capabilities without writing raw SQL.
Input Schema
TableJSON Schema
| Name | Required | Description | Default |
|---|---|---|---|
| entity | Yes | Primary table to query: 'tasks', 'subtasks', 'sidequests', 'milestones', 'files', 'functions', 'flows', 'themes', etc. | |
| filters | No | WHERE-like conditions with operators: {field: value} or {field: {op: 'gt', value: 5}} | |
| joins | No | Relations to include via LEFT JOIN: ['milestones', 'files'] | |
| sort | No | ORDER BY clause: 'field ASC' or 'field DESC' | |
| limit | No | Maximum results (pagination) | |
| offset | No | Skip first N results (pagination) |