run_query
Run a read-only QuickBooks query for anything the other tools miss. Use SQL SELECT statements to retrieve live company data.
Instructions
Run a read-only QuickBooks query for anything the other tools miss.
Only SELECT statements are accepted, and this server can only issue read requests, so no query can modify data. The language is a restricted subset of SQL: no JOIN, GROUP BY, OR, or aggregate functions. Call describe_schema first to check entity and field names, and prefer the purpose-built tools where one fits -- they do arithmetic this cannot.
Example: SELECT * FROM Invoice WHERE TxnDate >= '2026-01-01'
Args: query: A QuickBooks SELECT statement.
Input Schema
| Name | Required | Description | Default |
|---|---|---|---|
| query | Yes |
Output Schema
| Name | Required | Description | Default |
|---|---|---|---|
No arguments | |||