looker-query-sql - Genai Toolbox

About

The looker-query-sql generates a sql query using the Looker semantic model.

looker-query-sql takes eight parameters:

the model
the explore
the fields list
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.

Compatible Sources

Example

yaml

kind: tool
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.