looker-query - Genai Toolbox

About

The looker-query tool runs a query using the Looker semantic model.

looker-query 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
type: looker-query
source: looker-source
description: |
  This tool runs a query against a LookML model and returns the results in JSON format.

  Required Parameters:
  - model_name: The name of the LookML model (from `get_models`).
  - explore_name: The name of the explore (from `get_explores`).
  - fields: A list of field names (dimensions, measures, filters, or parameters) to include in the query.

  Optional Parameters:
  - pivots: A list of fields to pivot the results by. These fields must also be included in the `fields` list.
  - filters: A map of filter expressions, e.g., `{"view.field": "value", "view.date": "7 days"}`.
    - Do not quote field names.
    - Use `not null` instead of `-NULL`.
    - If a value contains a comma, enclose it in single quotes (e.g., "'New York, NY'").
  - sorts: A list of fields to sort by, optionally including direction (e.g., `["view.field desc"]`).
  - limit: Row limit (default 500). Use "-1" for unlimited.
  - query_timezone: specific timezone for the query (e.g. `America/Los_Angeles`).

  Note: Use `get_dimensions`, `get_measures`, `get_filters`, and `get_parameters` to find valid fields.

  The result of the query tool is JSON

Reference

field	type	required	description
type	string	true	Must be "looker-query"
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.