List all LookML models accessible to the current user. Returns model names, labels, associated projects, and their explores.

Get detailed information about a specific LookML model, including all its explores and their descriptions.

Get full details of an explore including all its dimensions, measures, filters, and parameters. This is the primary tool for understanding what fields are available for querying.

List dimensions in an explore. Convenience tool that returns only the dimension fields (name, label, type, description).

List measures in an explore. Convenience tool that returns only the measure fields (name, label, type, description).

List all database connections configured in the Looker instance.

Run a query using the Looker semantic model. Specify the model, explore, fields, filters, and sorts. Looker generates the optimized SQL — you never write SQL directly. Returns data rows as JSON.

Generate the SQL that Looker would execute for a query, without actually running it. Useful for reviewing or debugging queries.

Run the query associated with a saved Look and return its results. Looks are pre-built query configurations saved in Looker.

Run an existing saved Looker Query by ID and return its results. Unlike query, this does not re-spec the query body — any settings baked into the saved Query (e.g. dynamic_fields / table calcs / vis config) are preserved. Useful for re-running a query whose ID you already have: a dashboard tile's query.id, the id returned by query_url, or an id surfaced by other Looker tooling.

Get a dashboard definition and run all its tile queries. Returns the dashboard metadata and the data for each element.

Generate a URL to a Looker Explore with pre-populated query parameters. The URL opens the Explore UI in Looker.

Search across all Looker content — dashboards, looks, explores, and more. Returns matching items with titles, descriptions, and IDs.

List all databases accessible through a Looker connection.

List schemas in a database accessible through a Looker connection.

List tables in a schema accessible through a Looker connection.

List columns for specific tables in a Looker connection. Returns column names, data types, and other metadata.

Search for saved Looks by title, description, or other criteria.

Create a new saved Look with a query definition. The Look is saved in the specified folder.

Update a Look's metadata (title, description, folder).

Delete a saved Look. This action cannot be undone.

Search for dashboards by title, description, or other criteria.

Create a new empty dashboard in the specified folder.

Update a dashboard's metadata (title, description, folder).

Delete a dashboard. This action cannot be undone.

Add a visualization tile to a dashboard. Requires a query definition (model, view, fields) or a saved Look ID.

Add a filter to a dashboard.

Generate an embeddable SSO URL for Looker content (dashboards, Looks, or explores). The URL includes authentication so the viewer does not need separate Looker credentials.

Run Looker's content validator across all looks and dashboards in the instance. Returns broken content references grouped by error kind (e.g. missing explore, renamed field, deleted model). Useful to audit breakage after a LookML change before users see errors. Can be slow on large instances.

Run a health check on the Looker instance. Returns status of database connections, datagroups, and overall system health.

Analyze usage patterns across Looker content. Shows which models, explores, and content are most and least used.

Identify unused or orphaned LookML objects for cleanup. Scans for explores with no content, unreferenced views, and Looks/dashboards with zero views.

Return the Looker user this MCP session is currently authenticated as. Calls GET /user, which Looker resolves against the active session token — so when the session is sudo-impersonating another user (per-call act_as_user or X-User-Token header), the impersonated user's record is returned. Useful when the same Looker instance has multiple similarly-named users and you need to confirm which one the MCP is operating as.