# Use Looker with MCP, Gemini CLI and other Agents

This page shows you how to connect your Looker instance to various developer tools.

For the most powerful and integrated experience, we recommend using the dedicated Looker extension for [Gemini CLI](https://docs.cloud.google.com/gemini/docs/codeassist/gemini-cli). Use Looker's semantic layer to provide the Gemini CLI with secure, governed, and on-demand access to trusted data, and accelerate workflows by automating the creation of reports, visualizations, and dashboards from natural language prompts. As Google Cloud's next-generation command-line interface, the Gemini CLI is the recommended tool for interacting with your Looker instances from the command line.

You can also connect other integrated development environments (IDEs) and developer tools that support the [Model Context Protocol (MCP)](https://modelcontextprotocol.io/introduction) by using the general-purpose [MCP Toolbox for Databases](https://github.com/googleapis/mcp-toolbox). The MCP Toolbox is an open-source MCP server that simplifies connecting AI agents to your data by handling complexities like authentication and connection pooling, which lets you interact with your data using natural language directly from your IDE. For these tools, this method provides core database interaction capabilities.

> [!NOTE]
> **Note:** The MCP Toolbox is an open-source project provided "as-is". It is not a supported Google Cloud product and is not covered by the Google Cloud Technical Support Services Guidelines or SLAs. For support, see the project's [GitHub Issues page](https://github.com/googleapis/mcp-toolbox/issues).

## About Gemini CLI and extensions

Gemini CLI is an open-source AI agent that's designed to accelerate development workflows by assisting with coding, debugging, data exploration, and content creation. Its mission is to provide an elegant agentic experience for interacting with data cloud services and popular open-source databases.

### How extensions work

Gemini CLI is highly extensible, allowing for the addition of new tools and capabilities through extensions. These extensions are straightforward to install. You can load them from a GitHub URL, a local directory, or a configurable registry. These extensions provide a rich set of capabilities, including new tools, slash commands, and prompts to streamline your workflow.

## Set up Looker

<br />

1. Get a Looker Client ID and Client Secret. Follow the directions on the [Looker API authentication](https://docs.cloud.google.com/looker/docs/2602/api-auth#authentication_with_an_sdk) documentation page.
2. Have the base URL of your Looker instance available. It is likely something like `https://looker.example.com`. In some cases the API is listening at a different port, and you will need to use `https://looker.example.com:19999` instead.

<br />

## Install MCP Toolbox

> [!NOTE]
> **Note:** If you are using the Gemini CLI or Gemini Code Assist to connect to your Looker instance using the [MCP Toolbox for Databases](https://github.com/googleapis/mcp-toolbox), you don't need to install MCP Toolbox. MCP Toolbox will be installed when the Gemini extension is installed during the [configuration step](https://docs.cloud.google.com/looker/docs/2602/connect-ide-to-looker-using-mcp-toolbox#configure-your-mcp-client).

1. Download the latest version of MCP Toolbox as a binary. Select the [binary](https://github.com/googleapis/mcp-toolbox/releases) that corresponds to your OS and CPU architecture. You must use MCP Toolbox version V0.14.0 or later.

   ### linux/amd64

   ```
   curl -O https://storage.googleapis.com/genai-toolbox/v0.14.0/linux/amd64/toolbox
   ```

   ### darwin/arm64

   ```
   curl -O https://storage.googleapis.com/genai-toolbox/v0.14.0/darwin/arm64/toolbox
   ```

   ### darwin/amd64

   ```
   curl -O https://storage.googleapis.com/genai-toolbox/v0.14.0/darwin/amd64/toolbox
   ```

   ### windows/amd64

   ```
   curl -O https://storage.googleapis.com/genai-toolbox/v0.14.0/windows/amd64/toolbox.exe
   ```
2. Make the binary an executable.

       chmod +x toolbox

3. Verify the installation.

       ./toolbox --version

## Configure the MCP client

This section describes how to configure various developer tools to connect to your Looker instance using the [MCP Toolbox for Databases](https://github.com/googleapis/mcp-toolbox). The toolbox acts as an open-source [Model Context Protocol (MCP)](https://modelcontextprotocol.io/introduction) server that sits between your IDE and your database, providing a secure and efficient control plane for your AI tools. Select the tab for your specific tool to see the configuration instructions.

- [Gemini CLI](https://docs.cloud.google.com/looker/docs/2602/connect-ide-to-looker-using-mcp-toolbox#configure-your-mcp-client)
- [Gemini Code Assist](https://docs.cloud.google.com/looker/docs/2602/connect-ide-to-looker-using-mcp-toolbox#configure-your-mcp-client)
- [Claude code](https://docs.cloud.google.com/looker/docs/2602/connect-ide-to-looker-using-mcp-toolbox#configure-your-mcp-client)
- [Claude desktop](https://docs.cloud.google.com/looker/docs/2602/connect-ide-to-looker-using-mcp-toolbox#configure-your-mcp-client)
- [Cline](https://docs.cloud.google.com/looker/docs/2602/connect-ide-to-looker-using-mcp-toolbox#configure-your-mcp-client) (VS Code extension)
- [Cursor](https://docs.cloud.google.com/looker/docs/2602/connect-ide-to-looker-using-mcp-toolbox#configure-your-mcp-client)
- [Visual Studio Code](https://docs.cloud.google.com/looker/docs/2602/connect-ide-to-looker-using-mcp-toolbox#configure-your-mcp-client) (Copilot)
- [Windsurf](https://docs.cloud.google.com/looker/docs/2602/connect-ide-to-looker-using-mcp-toolbox#configure-your-mcp-client) (Codium)

### Gemini CLI

1. Install the [Gemini CLI](https://github.com/google-gemini/gemini-cli?tab=readme-ov-file#-installation).
2. Install the Looker extension for Gemini CLI from the GitHub repository using the following command:

   ```
   gemini extensions install https://github.com/gemini-cli-extensions/looker
   ```
3. Set environment variables to connect to your Looker instance, replacing the following environment variables with your values:
   - <var translate="no">`LOOKER_URL`</var>: The URL of your Looker instance.
   - <var translate="no">`CLIENT_ID`</var> and <var translate="no">`CLIENT_SECRET`</var>: The [API key](https://docs.cloud.google.com/looker/docs/2602/admin-panel-users-users#api_keys) that is used to access the [Looker API](https://docs.cloud.google.com/looker/docs/2602/api-auth).
   - <var translate="no">`VERIFY_SSL`</var>: Either `true` or `false`, depending on whether you use [SSL encryption](https://docs.cloud.google.com/looker/docs/2602/enabling-secure-db-access#option_2_ssl_encryption) to connect your database to your Looker instance.

   ```
   export LOOKER_BASE_URL="LOOKER_URL"
   export LOOKER_CLIENT_ID="CLIENT_ID"
   export LOOKER_CLIENT_SECRET="CLIENT_SECRET"
   export LOOKER_VERIFY_SSL="VERIFY_SSL"
   ```
4. Start the Gemini CLI in interactive mode:

   ```
   gemini
   ```
   The CLI automatically loads the Looker extension for Gemini CLI extension and its tools, which you can use to interact with your Looker instance.

### Gemini Code Assist

We recommend to configure Gemini Code Assist to use the Gemini CLI. This approach removes the need to manually configure an MCP server.

1. Make sure that you have installed and configured the [Gemini CLI](https://github.com/google-gemini/gemini-cli?tab=readme-ov-file#-installation) and the [`looker` extension](https://github.com/gemini-cli-extensions/looker).
2. [Configure Gemini Code Assist to use the Gemini CLI](https://developers.google.com/gemini-code-assist/docs/set-up-gemini-standard-enterprise).
3. Start interacting with your Looker instance using natural language directly within the Gemini Code Assist chat.

### Claude code

1. Install [Claude Code](https://docs.anthropic.com/en/docs/agents-and-tools/claude-code/overview).
2. Create the `.mcp.json` file in your project root, if it doesn't exist.
3. Add the following configuration, replacing the following environment variables with your values, and then save.
   - <var translate="no">`LOOKER_URL`</var>: The URL of your Looker instance.
   - <var translate="no">`CLIENT_ID`</var> and <var translate="no">`CLIENT_SECRET`</var>: The [API key](https://docs.cloud.google.com/looker/docs/2602/admin-panel-users-users#api_keys) that is used to access the [Looker API](https://docs.cloud.google.com/looker/docs/2602/api-auth).
   - <var translate="no">`VERIFY_SSL`</var>: Either `true` or `false`, depending on whether you use [SSL encryption](https://docs.cloud.google.com/looker/docs/2602/enabling-secure-db-access#option_2_ssl_encryption) to connect your database to your Looker instance.

<br />

```
      {
        "mcpServers": {
          "looker-toolbox": {
            "command": "./PATH/TO/toolbox",
            "args": ["--stdio", "--prebuilt", "looker"],
            "env": {
                "LOOKER_BASE_URL": "LOOKER_URL",
                "LOOKER_CLIENT_ID": "CLIENT_ID",
                "LOOKER_CLIENT_SECRET": "CLIENT_SECRET",
                "LOOKER_VERIFY_SSL": "VERIFY_SSL",
          }
          }
        }
      }
  
```

### Claude desktop

1. Open [Claude Desktop](https://claude.ai/download) and navigate to **Settings**.
2. In the **Developer** tab, click **Edit Config** to open the configuration file.
3. Add the following configuration, replacing the following environment variables with your values, and then save.
   - <var translate="no">`LOOKER_URL`</var>: The URL of your Looker instance.
   - <var translate="no">`CLIENT_ID`</var> and <var translate="no">`CLIENT_SECRET`</var>: The [API key](https://docs.cloud.google.com/looker/docs/2602/admin-panel-users-users#api_keys) that is used to access the [Looker API](https://docs.cloud.google.com/looker/docs/2602/api-auth).
   - <var translate="no">`VERIFY_SSL`</var>: Either `true` or `false`, depending on whether you use [SSL encryption](https://docs.cloud.google.com/looker/docs/2602/enabling-secure-db-access#option_2_ssl_encryption) to connect your database to your Looker instance.

<br />

```
      {
        "mcpServers": {
          "looker-toolbox": {
            "command": "./PATH/TO/toolbox",
            "args": ["--stdio", "--prebuilt", "looker"],
            "env": {
                "LOOKER_BASE_URL": "LOOKER_URL",
                "LOOKER_CLIENT_ID": "CLIENT_ID",
                "LOOKER_CLIENT_SECRET": "CLIENT_SECRET",
                "LOOKER_VERIFY_SSL": "VERIFY_SSL",
          }
          }
        }
      }
  
```

4. Restart Claude Desktop.
5. The new chat screen displays a hammer (MCP) icon with the new MCP server.

### Cline

1. Open the [Cline](https://github.com/cline/cline) extension in VS Code and click the **MCP Servers** icon.
2. Click **Configure MCP Servers** to open the configuration file.
3. Add the following configuration, replacing the following environment variables with your values, and then save.
   - <var translate="no">`LOOKER_URL`</var>: The URL of your Looker instance.
   - <var translate="no">`CLIENT_ID`</var> and <var translate="no">`CLIENT_SECRET`</var>: The [API key](https://docs.cloud.google.com/looker/docs/2602/admin-panel-users-users#api_keys) that is used to access the [Looker API](https://docs.cloud.google.com/looker/docs/2602/api-auth).
   - <var translate="no">`VERIFY_SSL`</var>: Either `true` or `false`, depending on whether you use [SSL encryption](https://docs.cloud.google.com/looker/docs/2602/enabling-secure-db-access#option_2_ssl_encryption) to connect your database to your Looker instance.

<br />

```
      {
        "mcpServers": {
          "looker-toolbox": {
            "command": "./PATH/TO/toolbox",
            "args": ["--stdio", "--prebuilt", "looker"],
            "env": {
                "LOOKER_BASE_URL": "LOOKER_URL",
                "LOOKER_CLIENT_ID": "CLIENT_ID",
                "LOOKER_CLIENT_SECRET": "CLIENT_SECRET",
                "LOOKER_VERIFY_SSL": "VERIFY_SSL",
          }
          }
        }
      }
  
```

<br />

A green active status appears after the server connects successfully.

<br />

<br />

### Cursor

1. Create the `.cursor` directory in your project root if it doesn't exist.
2. Create the `.cursor/mcp.json` file if it doesn't exist, and open it.
3. Add the following configuration, replacing the following environment variables with your values, and then save.
   - <var translate="no">`LOOKER_URL`</var>: The URL of your Looker instance.
   - <var translate="no">`CLIENT_ID`</var> and <var translate="no">`CLIENT_SECRET`</var>: The [API key](https://docs.cloud.google.com/looker/docs/2602/admin-panel-users-users#api_keys) that is used to access the [Looker API](https://docs.cloud.google.com/looker/docs/2602/api-auth).
   - <var translate="no">`VERIFY_SSL`</var>: Either `true` or `false`, depending on whether you use [SSL encryption](https://docs.cloud.google.com/looker/docs/2602/enabling-secure-db-access#option_2_ssl_encryption) to connect your database to your Looker instance.

```
      {
        "mcpServers": {
          "looker-toolbox": {
            "command": "./PATH/TO/toolbox",
            "args": ["--stdio", "--prebuilt", "looker"],
            "env": {
                "LOOKER_BASE_URL": "LOOKER_URL",
                "LOOKER_CLIENT_ID": "CLIENT_ID",
                "LOOKER_CLIENT_SECRET": "CLIENT_SECRET",
                "LOOKER_VERIFY_SSL": "VERIFY_SSL",
          }
          }
        }
      }
  
```

4. Open [Cursor](https://www.cursor.com/) and navigate to **Settings \> Cursor Settings \> MCP**. A green active status appears when the server connects.

### Visual Studio Code (Copilot)

1. Open [VS Code](https://code.visualstudio.com/docs/copilot/overview) and create the `.vscode` directory in your project root if it doesn't exist.
2. Create the `.vscode/mcp.json` file if it doesn't exist, and open it.
3. Add the following configuration, replacing the following environment variables with your values, and then save.
   - <var translate="no">`LOOKER_URL`</var>: The URL of your Looker instance.
   - <var translate="no">`CLIENT_ID`</var> and <var translate="no">`CLIENT_SECRET`</var>: The [API key](https://docs.cloud.google.com/looker/docs/2602/admin-panel-users-users#api_keys) that is used to access the [Looker API](https://docs.cloud.google.com/looker/docs/2602/api-auth).
   - <var translate="no">`VERIFY_SSL`</var>: Either `true` or `false`, depending on whether you use [SSL encryption](https://docs.cloud.google.com/looker/docs/2602/enabling-secure-db-access#option_2_ssl_encryption) to connect your database to your Looker instance.

```
      {
        "mcpServers": {
          "looker-toolbox": {
            "command": "./PATH/TO/toolbox",
            "args": ["--stdio", "--prebuilt", "looker"],
            "env": {
                "LOOKER_BASE_URL": "LOOKER_URL",
                "LOOKER_CLIENT_ID": "CLIENT_ID",
                "LOOKER_CLIENT_SECRET": "CLIENT_SECRET",
                "LOOKER_VERIFY_SSL": "VERIFY_SSL",
          }
          }
        }
      }
  
```

### Windsurf

1. Open [Windsurf](https://docs.codeium.com/windsurf) and navigate to Cascade assistant.
2. Click the MCP icon, then click **Configure** to open the configuration file.
3. Add the following configuration, replacing the following environment variables with your values, and then save.
   - <var translate="no">`LOOKER_URL`</var>: The URL of your Looker instance.
   - <var translate="no">`CLIENT_ID`</var> and <var translate="no">`CLIENT_SECRET`</var>: The [API key](https://docs.cloud.google.com/looker/docs/2602/admin-panel-users-users#api_keys) that is used to access the [Looker API](https://docs.cloud.google.com/looker/docs/2602/api-auth).
   - <var translate="no">`VERIFY_SSL`</var>: Either `true` or `false`, depending on whether you use [SSL encryption](https://docs.cloud.google.com/looker/docs/2602/enabling-secure-db-access#option_2_ssl_encryption) to connect your database to your Looker instance.

```
      {
        "mcpServers": {
          "looker-toolbox": {
            "command": "./PATH/TO/toolbox",
            "args": ["--stdio", "--prebuilt", "looker"],
            "env": {
                "LOOKER_BASE_URL": "LOOKER_URL",
                "LOOKER_CLIENT_ID": "CLIENT_ID",
                "LOOKER_CLIENT_SECRET": "CLIENT_SECRET",
                "LOOKER_VERIFY_SSL": "VERIFY_SSL",
          }
          }
        }
      }
  
```

## Use AI tools

Your AI tool is now connected to Looker using MCP. Try asking your AI assistant to list models, Explores, dimensions, and measures. You can also run a query by retrieving the SQL for a query or running a saved Look.

The following tools are available to the LLM:

### Looker Model and Query Tools

These tools are used to get information about a Looker model and execute queries against that model.

- `get_models`: List all LookML models on your Looker instance.
- `get_explores`: List the explores in a given model.
- `get_dimensions`: List the dimensions in a given Explore.
- `get_measures`: List the measures in a given Explore.
- `get_filters`: List the filters in a given Explore.
- `get_parameters`: List the parameters in a given Explore.
- `query`: Run a query and return the data.
- `query_sql`: Return the SQL that is generated by Looker for a query.
- `query_url`: Return a link to the query in Looker for further exploration.

### Looker Content Tools

These tools get saved content (Looks and Dashboards) from a Looker instance and create new saved content.

- `get_looks`: Return the saved Looks that match a title or description.
- `run_look`: Run a saved Look and return the data.
- `make_look`: Create a saved Look in Looker and return the URL.
- `get_dashboards`: Return the saved dashboards that match a title or description.
- `make_dashboard`: Create a saved dashboard in Looker and return the URL.
- `add_dashboard_element`: Add a tile to a dashboard.

### Looker Instance Health Tools

These tools offer the same health check algorithms that the popular CLI [Henry](https://github.com/looker-open-source/henry) offers.

- `health_pulse`: Check the health of a Looker instance.
- `health_analyze`: Analyze the usage of a Looker object.
- `health_vacuum`: Find LookML elements that might be unused.

### LookML Authoring Tools

These tools allow enable the caller to write and modify LookML files as well as get the database schema needed to write LookML effectively.

- `dev_mode`: Turn [Development Mode](https://docs.cloud.google.com/looker/docs/2602/dev-mode-prod-mode#development_mode) on and off for the session. LookML authoring must be done in Development Mode. Queries that are run in Development Mode use the modified LookML so you can test the impact of your changes.
- `get_projects`: Get the list of available LookML projects.
- `get_project_files`: Get the list of LookML files in a project.
- `get_project_file`: Get the content of a LookML file.
- `create_project_file`: Create a new LookML file.
- `update_project_file`: Modify an existing LookML file.
- `delete_project_file`: Delete a LookML file.
- `get_connections`: Get the list of connections.
- `get_connection_schemas`: Get the list of schemas for a connection.
- `get_connection_databases`: Get the list of databases for a connection.
- `get_connection_tables`: Get the list of tables for a connection.
- `get_connection_table_columns`: Get the list of columns for a table in a connection.

> [!NOTE]
> **Note:** Prebuilt tools are pre-1.0, so expect some tool changes between versions. Because LLMs adapt to the tools that are available, most users won't be affected.