looker-query-sql
“looker-query-sql” generates a sql query using the Looker semantic model.
About
The looker-query-sql generates a sql query using the Looker
semantic model.
It’s compatible with the following sources:
looker-query-sql takes eight parameters:
- the
model - the
explore - the
fieldslist - an optional set of
filters - an optional set of
pivots - an optional set of
sorts - an optional
limit - an optional
tz
Starting in Looker v25.18, these queries can be identified in Looker’s System Activity. In the History explore, use the field API Client Name to find MCP Toolbox queries.
Example
kind: tools
name: query_sql
type: looker-query-sql
source: looker-source
description: |
This tool generates the underlying SQL query that Looker would execute
against the database for a given set of parameters. It is useful for
understanding how Looker translates a request into SQL.
Parameters:
All parameters for this tool are identical to those of the `query` tool.
This includes `model_name`, `explore_name`, `fields` (required),
and optional parameters like `pivots`, `filters`, `sorts`, `limit`, and `query_timezone`.
Output:
The result of this tool is the raw SQL text.
Reference
| field | type | required | description |
|---|---|---|---|
| type | string | true | Must be “looker-query-sql” |
| source | string | true | Name of the source the SQL should execute on. |
| description | string | true | Description of the tool that is passed to the LLM. |