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.
Tool call template
Replace each placeholder with a value matching the input schema. Only required parameters are included; add optional parameters as needed.
{
"id": 1,
"jsonrpc": "2.0",
"method": "tools/call",
"params": {
"arguments": {
"entity": "<entity>"
},
"name": "query_project_state"
}
}Input 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) |