Exploration & Query Records

Databook & Query Catalog

Curate verified SQL insights, inspect full multi-step agent reasoning transcripts, and explore query result datasets in a spreadsheet-grade tabular view.

The Verified Query Catalog

When an agent generates a high-value query (e.g. "Top 10 Customers by Retention Rate"), users can pin the query into the organization's Databook. These saved queries serve as verified gold-standard references that feed back into Semantic Vector Memory.

Interactive Spreadsheet Explorer

The Databook view (/databook) provides high-performance data grids with:

Instant Column Filtering

Filter numerical thresholds, regex text search, and date ranges without running new database queries.

Pagination & Sorting

Seamlessly navigate thousands of rows with client-side virtual scrolling.

Schema Type Formatting

Automatic currency, percentage, and ISO timestamp formatting based on MDL column metadata.

Reasoning Transcripts & Token Auditing

Each Databook item records the exact agent thought trajectory:

● Step 1: User requested count of orders where CustomerID = 'BLAUS'

● Step 2: Inferred quantitative aggregation (COUNT with WHERE filter)

● Step 3: Executed SQL: SELECT COUNT(*) AS NUMBEROFORDERS FROM Orders WHERE CustomerID = 'BLAUS'

Tokens Spent: 1,052 tokens | Execution Time: 42ms | Verified by Admin

Data Exporting

Export verified tables in one click to CSV, Excel (.xlsx), or JSON via /api/export for downstream reporting in BI tools.