by @google cloud (mcp toolbox)
Integration with Looker through MCP Toolbox for Databases, an open-source MCP server that simplifies connecting AI agents to Looker by handling complexities like authentication and connection pooling. Provides 40+ tools organized into four categories: Looker Model and Query Tools (9 tools for querying models, explores, dimensions, measures, filters, parameters), Looker Content Tools (7 tools for managing Looks and Dashboards), Looker Instance Health Tools (3 tools for health checks using Henry algorithms), and LookML Authoring Tools (13 tools for writing and modifying LookML files, managing projects, accessing database schemas). Supports Gemini CLI with dedicated Looker extension (recommended), Claude Code, Claude Desktop, Cline, Cursor, VS Code (Copilot), and Windsurf. Requires Looker Client ID and Client Secret for API authentication. Enables natural language interaction with Looker data, semantic layer access, automated report/visualization/dashboard creation, Development Mode for LookML testing, and comprehensive database schema access. Not a supported Google Cloud product - provided as-is open-source project. Installed via npx @toolbox-sdk/server or binary download (v0.14.0+). Prebuilt tools subject to change between versions.
This server provides the following tools for AI assistants:
Run a saved Look and return the data
List all LookML models on your Looker instance
List the explores in a given model
List the dimensions in a given Explore
List the measures in a given Explore
List the filters in a given Explore
List the parameters in a given Explore
Run a query and return the data
Return the SQL generated by Looker for a query
Return a link to the query in Looker for further exploration
Return the saved Looks that match a title or description
Return the saved dashboards that match a title or description
Check the health of a Looker instance using Henry algorithms
Analyze the usage of a Looker object
Find LookML elements that might be unused
Create a saved Look in Looker and return the URL
Create a saved dashboard in Looker and return the URL
Add a tile to a dashboard
Turn Development Mode on and off for the session to test LookML changes
Add a filter to a dashboard
Get the list of available LookML projects
Get the list of LookML files in a project
Get the content of a LookML file
Get the list of connections
Get the list of schemas for a connection
Get the list of databases for a connection
Get the list of tables for a connection
Get the list of columns for a table in a connection
Create a new LookML file
Modify an existing LookML file
Delete a LookML file