get_example_queries
Retrieve real example SQL queries for a specified table. Each result includes SQL text, observation count, source, and PII categories to reveal actual usage patterns.
Instructions
Use this when you need real example SQL for an indexed table to learn how it's actually used. Each item carries the SQL text, observation count, source, and PII categories touched. Returns status: empty when the table has no recorded examples yet (query log mining ships next). Use describe_table instead when you want the table's structural shape rather than usage patterns. Common composition: chain find_relevant_tables to get_example_queries.
Input Schema
| Name | Required | Description | Default |
|---|---|---|---|
| qualified_name | Yes | Postgres `schema.table` qualified name (e.g. `public.orders`). Returns SQL agents (or humans) have actually run against this table, sourced from `pg_stat_statements`. Run `schemabrain mine-queries` first to populate the cache; until then this tool returns `status: empty`. |
Output Schema
| Name | Required | Description | Default |
|---|---|---|---|
| status | Yes | ||
| data | No | ||
| error | No | ||
| confidence | No | ||
| provenance | No | ||
| follow_up_hints | No | ||
| degradation_reason | No | ||
| charter_version | No | 1.2 |