Loading ToolBench
A semantic layer that compiles and executes YAML semantic models as analytical SQL. Provides REST API endpoints for querying, schema exploration, and supports multiple database backends (BigQuery, Snowflake, PostgreSQL, ClickHouse, Dremio, Databricks, DuckDB, MySQL). Includes Arrow Flight SQL support and integrations with CrewAI, LangChain, and Google ADK.
Compile an advanced query with filters, ordering, and HAVING clauses.
Compile a semantic query to SQL. Dimensions and measures must be exact business names from the model.
Get the full semantic model structure: data objects, dimensions, measures, metrics. Call this first to understand what is available before compiling queries.
Explain the lineage of a dimension, measure, or metric. Shows which data objects, columns, joins, and expressions contribute to the named artefact.
Get the join graph showing how data objects (tables) are connected. Returns nodes (data objects) and edges (joins) with cardinality and join columns.
List all supported SQL dialects with their capabilities. Supported: bigquery, clickhouse, databricks, dremio, duckdb, mysql, postgres, snowflake.
List all dimensions in the semantic model. Dimensions are categorical or temporal attributes used for grouping and filtering (e.g. Country Name, Sales Date, Product Category).
| Scored | Grade | Overall | Spec posture | Rubric |
|---|---|---|---|---|
| 2026-09-22 | F | 16 | 2026-07-28+ | v2 |
List all measures in the semantic model. Measures are numeric aggregations computed from data object columns (e.g. Total Sales, Sales Count, Avg Unit Price).
List all metrics in the semantic model. Metrics are derived calculations built from measures (e.g. Profit Margin, YoY Growth). Types: derived, cumulative, period_over_period.
Search for dimensions, measures, or metrics by name or synonym.
Compile a semantic query to SQL. Dimensions and measures must be exact business names from the model.
Compile a semantic query to SQL. Dimensions and measures must be referenced by their exact business names as returned by describe_model, list_dimensions, and list_measures.
Compile an advanced query with filters, ordering, and HAVING clauses.
Compile an advanced query with filters, ordering, and HAVING clauses. Use this for queries that need WHERE filters, HAVING filters, ORDER BY, or other advanced features not covered by compile_query.
Get the full semantic model structure: data objects, dimensions, measures, metrics. Call this first to understand what is available before compiling queries.
Get the full semantic model structure: data objects, dimensions, measures, metrics. Call this first to understand what is available before compiling queries.
Explain the lineage of a dimension, measure, or metric. Shows which data objects, columns, joins, and expressions contribute to the named artefact.
Explain the lineage of a dimension, measure, or metric. Shows which data objects, columns, joins, and expressions contribute to the named artefact.
Get the join graph showing how data objects (tables) are connected. Returns nodes (data objects) and edges (joins) with cardinality and join columns.
Get the join graph showing how data objects (tables) are connected. Returns nodes (data objects) and edges (joins) with cardinality and join columns.
List all supported SQL dialects with their capabilities. Supported: bigquery, clickhouse, databricks, dremio, duckdb, mysql, postgres, snowflake.
List all supported SQL dialects with their capabilities. Supported: bigquery, clickhouse, databricks, dremio, duckdb, mysql, postgres, snowflake.
List all dimensions in the semantic model. Dimensions are categorical or temporal attributes used for grouping and filtering (e.g. Country Name, Sales Date, Product Category).
List all dimensions in the semantic model. Dimensions are categorical or temporal attributes used for grouping and filtering (e.g. Country Name, Sales Date, Product Category).
List all measures in the semantic model. Measures are numeric aggregations computed from data object columns (e.g. Total Sales, Sales Count, Avg Unit Price).
List all measures in the semantic model. Measures are numeric aggregations computed from data object columns (e.g. Total Sales, Sales Count, Avg Unit Price).
List all metrics in the semantic model. Metrics are derived calculations built from measures (e.g. Profit Margin, YoY Growth). Types: derived, cumulative, period_over_period.
List all metrics in the semantic model. Metrics are derived calculations built from measures (e.g. Profit Margin, YoY Growth). Types: derived, cumulative, period_over_period.
Search for dimensions, measures, or metrics by name or synonym.
Search for dimensions, measures, or metrics by name or synonym. Use this when the user mentions a concept and you need to find the matching artefact (e.g. "sales" might match a measure with synonym "sales").