Run Query
run-queryExecute read-only SQL queries on RawTree data to retrieve JSON rows, column metadata, and query statistics. Use for data exploration, verification, and aggregations.
Instructions
Purpose: Execute a read-only SQL query against the configured RawTree project and return JSON rows, column metadata, statistics, and hints.
NOT for: Inserting, updating, deleting, or mutating data. RawTree validates queries as read-only and rejects unsafe statements.
Returns: RawTree's query response: meta, data, rows, statistics, and optional hints.
When to use:
User asks questions about data already in RawTree
You need to verify an insert
You need a quick aggregate, sample, or schema-oriented SELECT
You need RawTree query hints after an error
Workflow: Start with a bounded SELECT. For exploratory queries, include LIMIT and order by a time column when available.
Key trigger phrases: "query RawTree", "run SQL", "count rows", "show sample rows", "check the data"
Input Schema
| Name | Required | Description | Default |
|---|---|---|---|
| sql | Yes | Read-only SQL to execute. Prefer bounded SELECT queries with LIMIT for exploration. |