looker-auth-mcp

Configure Looker API credentials and MCP Toolbox integration for AI agent access.

Updated Jul 7, 2026
One-click install
npx skills add https://github.com/ricardolui/gcp-custom-agent-skills --skill looker-auth-mcp-ricardolui
Or copy as Structured Prompt for Agent
Please help me install this Agent Skill.
Skill: looker-auth-mcp
Source: https://github.com/ricardolui/gcp-custom-agent-skills/tree/main/c6-looker-auth
Command: npx skills add https://github.com/ricardolui/gcp-custom-agent-skills --skill looker-auth-mcp-ricardolui

SYSTEM DOCUMENTATION & REQUIREMENTS

💡 This Skill requires @toolbox-sdk/server, and includes scripts (resource) components.

What problem does it solve? Setting up Looker API authentication and connecting AI agents to a Looker instance requires juggling multiple environment variable conventions, credential files, and MCP server configurations, which is error-prone and risks leaking secrets. ## Core Features & Use Cases - Credential & Environment Setup: Maps Looker API3 Client ID and Secret to the correct environment variables for both the Looker Python SDK (LOOKERSDK_*) and the MCP Toolbox (LOOKER_*), with secure .env handling. - MCP Toolbox Integration: Provides a ready-to-use mcp_config.json block for Claude Desktop, Cursor, VS Code, and Antigravity, exposing 45 prebuilt Looker tools for LookML development and semantic querying. - Automated Injection Script: Generates looker.ini, .env, and the IDE MCP config snippet automatically from existing environment variables. - Use Case: A data engineer wants Claude Desktop to explore LookML models and run Looker queries locally; this Skill configures the credentials and MCP server so the agent can list explores, validate LookML, and run queries without remote credential forwarding. ## Quick Start Ask the AI agent to set up Looker authentication and generate the MCP Toolbox configuration using the credentials in your .env file.

Frequently Asked Questions about looker-auth-mcp

High-intent search queries and answers about installing and using this skill.

FAQPage Schema
How do I connect Claude Desktop to Looker with MCP?

Add a looker-toolbox server block to your mcp_config.json that runs npx @toolbox-sdk/server with the looker and looker-dev prebuilts, passing LOOKER_BASE_URL, LOOKER_CLIENT_ID, and LOOKER_CLIENT_SECRET as environment variables.

How do I get Looker API credentials for the MCP Toolbox?

Generate an API3 Client ID and Client Secret from the Looker Admin Console under Admin > Users > Edit User > API3 Keys. Store them in a .env file as LOOKER_CLIENT_ID and LOOKER_CLIENT_SECRET, which is excluded from Git via .gitignore.

What is the difference between LOOKER_ and LOOKERSDK_ environment variables?

The MCP Toolbox for Databases reads LOOKER_BASE_URL, LOOKER_CLIENT_ID, and LOOKER_CLIENT_SECRET, while the Looker Python SDK uses the LOOKERSDK_ prefixed equivalents. Export the set matching the client layer you are using.

What tools does the Looker MCP Toolbox expose?

It exposes 45 prebuilt tools across two areas: looker-dev for LookML development (branching, file editing, project validation) and looker for business intelligence (listing models and explores, running queries, and retrieving compiled SQL).

Why is my Looker MCP server failing to authenticate?

Authentication usually fails because environment variables were not sourced from .env before starting the server, or the base URL is incorrect. Export variables with export $(grep -v '^#' .env | xargs) and verify the instance URL and port.