Looker
 · MCP Server

Looker MCP — Your BI Layer, Queryable in Plain English

Improvado's MCP server connects your Looker instance to AI agents. Ask business questions against your existing LookML models, run explores, and pull dashboard data — without opening Looker every time. Works with Claude, Cursor, and any MCP-compatible tool.

46K+ metrics · Read & Write access · 500+ platforms · <60s setup
📈 Read

Read: Query Looker Explores Without Writing LookML

Your LookML models already define your business logic. Now your AI agent can use them. Ask for revenue by segment, funnel conversion by cohort, or retention by product line — and the MCP server translates it into Looker API calls against your existing explores.

Your AI agent reads harmonized data across 500+ platforms. "Cost" in Google Ads and "spend" in Meta Ads resolve to the same field automatically.

Example prompts
"Show anomalies across all accounts" 2h → 40s
"CPL in New York vs. California?" 1h → 30s
"ROAS by campaign type, last 30 days" 45m → 15s
Works with Claude ChatGPT Cursor +5
Write actions
"Launch A/B test, $5K budget" 5 days → 20m
"Shift 20% of Display to PMax" 2h → 1m
"Pause all ad groups with CPA > $50" 30m → 10s
🛡 Every action logged · Fully reversible · SOC 2 certified
🚀 Write

Write: Schedule Reports and Update Dashboards via AI

Create and update scheduled reports, configure dashboard filters, and manage Looker content programmatically. The operational work that normally means navigating deeply nested menus — done in one conversation.

250+ governance rules enforce naming conventions, budget limits, and KPI thresholds. SOC 2 Type II certified.

⚠️ Monitor

Monitor: Watch Business Metrics Without Manual Checks

Set AI-powered alerts on the Looker metrics that matter. Track when KPIs breach thresholds, when dashboard data goes stale, or when explore results change significantly week-over-week.

Automated weekly reports, anomaly flagging, and budget alerts — all from a single conversation. No more morning check-ins across 5 dashboards.

Monitor prompts
"Flag ad groups over 120% budget" 3h → 1m
"Weekly report: spend, CPA, anomalies" 3h → auto
"Which creatives are fatiguing?" 2h → 30s
Alerts sent to Slack, email, or your AI agent
💡
Ideate
🚀
Launch
📈
Measure
🔍
Analyze
📝
Report
🔄
Iterate
One conversation. All six phases. Every platform.
🔄 Full Cycle

The Closed Loop: Read → Decide → Write → Monitor

Create and update scheduled reports, configure dashboard filters, and manage Looker content programmatically. The operational work that normally means navigating deeply nested menus — done in one conversation.

Every phase runs through the same MCP connection. One protocol, all platforms, full governance. No switching between tools.

Challenge 1

Analysts Become Bottlenecks for Every Data Question

THE PROBLEM

Everyone knows Looker exists, but only a handful of analysts know how to navigate explores and write custom looks. Every ad-hoc business question lands in a Slack DM to an analyst. Response time is hours. During planning cycles, analysts are buried.

HOW MCP SOLVES IT

Improvado's MCP server exposes your existing LookML models to AI agents. Non-technical stakeholders ask questions in plain English — the AI maps them to the correct explore and dimensions. Analysts focus on modeling, not answering repetitive lookups.

Try asking
"Show ROAS across all 120 accounts"
Answer in seconds
All data sources, one query
Try asking
"What's my CPL in New York vs. California?"
🔍
Full detail preserved
No data loss on export
Challenge 2

Cross-Explore Analysis Requires Manual Export and Joining

THE PROBLEM

You want to correlate marketing spend from one explore with revenue outcomes from another. Looker doesn't let you join across explores natively. The workaround is downloading two CSVs, opening Excel, and joining them manually. By the time you're done, the numbers are stale.

HOW MCP SOLVES IT

Your AI agent queries multiple Looker explores in sequence and synthesizes the results. It pulls ad spend from your marketing explore and LTV from your revenue explore, then builds the correlation in the same conversation — no CSV exports needed.

Challenge 3

Dashboard Sprawl Makes It Impossible to Find the Right Numbers

THE PROBLEM

Your Looker instance has 400 dashboards built over three years. Half are duplicates or stale. When someone asks 'what's our churn rate,' three different dashboards show three different numbers because they use different date logic and segment filters. Nobody knows which to trust.

HOW MCP SOLVES IT

Ask your AI agent to identify which Looker dashboards cover a given topic, when they were last updated, and how their underlying explores differ. Surface the authoritative source without digging through 400 dashboards manually.

Try asking
"PMax vs. Search ROAS for Q1?"
⚖️
Unified data model
Compare anything side by side
Agency CEO
Portfolio health. Client risk. Revenue signals.
Media Strategist
70% strategy, not 70% ops. Auto campaign QA.
Marketing Analyst
Zero wrangling. Cross-platform. AI narratives.
Account Manager
QBR decks auto-generated. Call prep in 30s.
Creative Director
Performance-to-brief. Predict winners before spend.
👥 Teams

One Framework. Five Roles. Zero Setup.

Same MCP connection, different workflows for every team member. Agency CEOs get portfolio health. Media Strategists get campaign QA. Analysts get cross-platform reports. Account Managers get auto-generated QBR decks. Creative Directors get performance-based briefs.

Each role asks in natural language. The MCP server handles the complexity — rate limits, auth, schema normalization, governance — behind the scenes.

Frequently Asked Questions

Does this work with my existing LookML models?
+

Yes. The MCP server connects to your Looker instance and uses your existing explores, dimensions, and measures. You don't need to redefine your data model — the AI queries what's already there. Any explore accessible via the Looker API is queryable through the MCP connection.

Do I need to know LookML to use the Looker MCP server?
+

No. That's the point. You ask in plain English and the MCP server translates your question into Looker API calls against the right explore. Your LookML models define the business logic; the AI figures out how to query them.

Can I query Looker dashboards or only explores?
+

Both. You can pull data from specific explores for ad-hoc analysis, or you can query existing dashboards and tiles directly. You can also list and manage dashboards, scheduled reports, and content.

How does this handle Looker's row-level access controls?
+

The MCP server authenticates with your Looker API credentials. It inherits the exact same data access controls as the account you connect — row-level access, model permissions, and folder visibility are all respected. The AI only sees what that account can see.

Can the Looker MCP integration run queries against LookML models or only retrieve pre-built Look results?
+

The Looker MCP integration supports both approaches. It can retrieve results from saved Looks and dashboards, and it can also execute ad-hoc queries against your LookML models using Looker's Run Inline Query API. This means an AI agent can translate a natural-language question into the appropriate LookML explore, dimensions, measures, and filters, then execute the query in real time. Organizations benefit from having governed, centrally defined LookML metrics as the trusted source rather than raw SQL.

How does the Looker MCP integration handle row-level security and user attribute restrictions?
+

The Looker MCP integration operates under the permissions of the Looker API credentials used to configure it. If the integration uses a service account, that account's Looker model and data access permissions apply to all queries, including any user attribute-based row-level security rules defined in your LookML models. For organizations requiring per-user data isolation, it is recommended to configure the integration with appropriately scoped credentials or to consult Looker's embed and API authentication documentation to understand how user context can be passed through.

Does this work with my existing LookML models?
Yes. The MCP server connects to your Looker instance and uses your existing explores, dimensions, and measures. You don't need to redefine your data model — the AI queries what's already there. Any explore accessible via the Looker API is queryable through the MCP connection.
Do I need to know LookML to use the Looker MCP server?
No. That's the point. You ask in plain English and the MCP server translates your question into Looker API calls against the right explore. Your LookML models define the business logic; the AI figures out how to query them.
Can I query Looker dashboards or only explores?
Both. You can pull data from specific explores for ad-hoc analysis, or you can query existing dashboards and tiles directly. You can also list and manage dashboards, scheduled reports, and content.
How does this handle Looker's row-level access controls?
The MCP server authenticates with your Looker API credentials. It inherits the exact same data access controls as the account you connect — row-level access, model permissions, and folder visibility are all respected. The AI only sees what that account can see.
Can the Looker MCP integration run queries against LookML models or only retrieve pre-built Look results?
The Looker MCP integration supports both approaches. It can retrieve results from saved Looks and dashboards, and it can also execute ad-hoc queries against your LookML models using Looker's Run Inline Query API. This means an AI agent can translate a natural-language question into the appropriate LookML explore, dimensions, measures, and filters, then execute the query in real time. Organizations benefit from having governed, centrally defined LookML metrics as the trusted source rather than raw SQL.
How does the Looker MCP integration handle row-level security and user attribute restrictions?
The Looker MCP integration operates under the permissions of the Looker API credentials used to configure it. If the integration uses a service account, that account's Looker model and data access permissions apply to all queries, including any user attribute-based row-level security rules defined in your LookML models. For organizations requiring per-user data isolation, it is recommended to configure the integration with appropriately scoped credentials or to consult Looker's embed and API authentication documentation to understand how user context can be passed through.

Stop Reporting. Start Executing.

Connect your data to an AI agent in under 60 seconds. The closed loop starts with one conversation.

SOC 2 Type II
GDPR
500+ Platforms
46K+ Metrics