Connect Looker to AI agents

Connect Looker to Claude, Codex, Cursor, or other AI agents for your entire team. Metorial security, governance, observability, and gives your team a unified Magic MCP url to connect.

Supported Tools

manage_look

Manage Look

Get, create, update, or permanently delete a Look (saved query with visualization). Can also run a Look and return JSON results inline or non-JSON results as attachments.

run_query

Run Query

Run an inline query against a LookML model and retrieve results without saving a Look first. Specify the model, Explore (view), fields, filters, sorts, limit, and output format. JSON formats are returned inline; file and text formats are returned as attachments.

manage_user

Manage User

Get, create, update, or delete a Looker user. Can also search for users by name or email, and manage user role assignments.

manage_folder

Manage Folder

Get, create, update, permanently delete, search, or list direct child folders in Looker. Deleting a folder recursively deletes its child folders and all Looks and dashboards it contains, and cannot be undone.

search_looks

Search Looks

Search for saved Looks by title, description, or folder. String filters are case-insensitive and support % and _ wildcards. Multiple filters use AND unless filterOr is true.

search_dashboards

Search Dashboards

Search user-defined dashboards by title, description, folder, or creator user ID. String filters are case-insensitive and support % and _ wildcards. Multiple filters use AND unless filterOr is true. Use manage_user to discover a creator's user ID from their name or email. This does not return LookML dashboards.

manage_dashboard

Manage Dashboard

Get, create, update, or permanently delete a Looker dashboard. When getting a dashboard, also retrieves its elements and filters. For updates, only provide the fields you want to change. Delete is permanent and cannot be recovered.

run_sql_query

Run SQL Query

Execute raw SQL using Looker's SQL Runner. Provide either a database connection name or a LookML model name, plus the exact SQL statement. SQL can mutate the underlying database; use SELECT statements for read-only access. JSON results are returned inline, while CSV and TXT results are returned as attachments.

create_embed_url

Create Embed URL

Generate a signed SSO embed URL for embedding Looker content (dashboards, Looks, Explores) into external applications. The URL can be used to embed Looker in iframes with authenticated user context.

list_models

List LookML Models

List available LookML models and their explores, or get details about a specific model or explore. Use this to discover what data models are available for querying.

list_roles

List Roles

List all available roles in the Looker instance, or get details for a specific role. Roles define permission sets and model access that can be assigned to users and groups.

manage_connection

Manage Connection

List database connections, get connection details, test connectivity, and explore database metadata (schemas, tables, columns). Use this to inspect what data sources are available and their structure.

manage_group

Manage Group

Get, create, update, permanently delete, or search for user groups. Groups can be used for assigning roles and managing content access. Can also add or remove users from groups.

manage_alert

Manage Alert

Get, create, update, permanently delete, or search data-driven alerts on dashboard tiles. Alerts trigger notifications when data meets specified conditions.

manage_scheduled_plan

Manage Scheduled Plan

Get, create, update, permanently delete, or list scheduled content delivery plans, and create plans that run once immediately. Scheduled plans automate delivery of Look, dashboard, LookML dashboard, or query results via email, webhooks, S3, or SFTP.

validate_content

Validate Content

Run Looker's content validator across saved content, or lint all LookML files in one project. Content validation can be filtered by project names or space IDs. For backward compatibility, providing projectId without mode selects project validation; otherwise the default mode is content.

More integrations teams use with Looker

GitHub

Manage repositories, issues, and pull requests. Create and configure branches, star repositories, review code, and merge changes. Automate CI/CD workflows with GitHub Actions, manage workflow runs, secrets, and artifacts. Track issues with labels, milestones, and assignees. Search across code, repositories, issues, and users. Manage organizations, teams, and memberships. Create and manage projects, gists, packages, deployments, and environments. Access security alerts including code scanning, secret scanning, and Dependabot alerts. Read and write file contents in repositories. Manage webhooks, notifications, and codespaces.

Salesforce

Manage CRM data including Accounts, Contacts, Leads, Opportunities, Cases, and custom objects. Create, read, update, and delete records. Query data using SOQL and search across objects using SOSL. Perform bulk data operations for large-scale imports, exports, and migrations. Execute composite requests to batch multiple operations in a single API call. Access analytics, reports, and dashboards. Manage files and attachments associated with records. Interact with Chatter feeds, posts, and groups for social collaboration. Subscribe to real-time change events via Change Data Capture and Platform Events. Manage org metadata including custom objects, fields, layouts, and workflows. Query data using GraphQL for precise data retrieval across related objects.

Sharepoint

Manage SharePoint sites, document libraries, lists, and files. Create, read, update, and delete lists and list items with custom columns. Resolve site users to numeric Person/Group LookupId values. Upload, download, move, copy, and version files in document libraries. Search across sites, files, folders, lists, and list items using Microsoft Search. Manage permissions at site, list, and item levels with granular access control. Define and manage content types and site columns. Subscribe to webhooks for list and library change notifications. Retrieve site properties and search for sites across Microsoft 365.

Airtable

Create, read, update, and delete records in Airtable bases and tables. Manage base schemas including creating tables and fields. Filter records using formulas, sort by fields, and scope queries to specific views. Upsert records to find, create, or update in a single call. Upload attachments to records, read and write record comments, list accessible bases, and receive real-time base change events through webhooks.

Bitbucket

Manage Git repositories, pull requests, and CI/CD pipelines on Bitbucket Cloud. Create, fork, and configure repositories within workspaces and projects. Create, review, approve, merge, and decline pull requests with inline code comments. Browse source code, list commits, and manage branches and tags. Track issues with the built-in issue tracker. Trigger, monitor, and manage Bitbucket Pipelines. List workspace members, configure repository default reviewers and branch restrictions, create and manage repository webhooks, and search code across repositories.

Heroku

Deploy, manage, and scale applications on Heroku's cloud platform. Create and configure apps, scale dynos, provision add-ons (databases, caching, etc.), manage configuration variables, build and release code, add custom domains and SSL certificates, manage collaborators and team permissions, configure pipelines for continuous delivery, set up log drains, and sync data with Salesforce via Heroku Connect. Subscribe to webhooks for real-time notifications on app changes, builds, releases, dyno lifecycle events, and more.

Technical notes for Looker

Run queries against LookML models and retrieve results in multiple formats (JSON, CSV, PDF, XLSX). Create, manage, and organize dashboards, Looks, and folders. Schedule recurring data deliveries via email, webhook, S3, and SFTP. Administer users, groups, roles, and permissions. Configure database connections and inspect database metadata (schemas, tables, columns). Manage LookML projects with Git branch operations, deployments, and validation. Generate embed URLs and cookieless sessions for embedding analytics in external applications. Create and manage data-driven alerts on dashboard tiles. Render dashboards and queries as images or PDFs. Configure instance settings, authentication (LDAP, SAML, OIDC), themes, and integrations with external action hubs.

Connect Looker to production AI agents

See how Metorial gives Looker access the governance, tracing, and security controls teams need.

Frequently asked questions

Common questions about connecting Looker to AI agents with Metorial.

  1. Can Metorial connect Looker to AI agents?
    Yes. Metorial connects AI agents to Looker through a governed integration layer, so teams can use the provider while keeping access controlled and observable.
  2. Metorial is MCP compatible and lets teams expose approved provider tools to MCP-capable agents and clients through a controlled access layer.
  3. Metorial applies policies across users, groups, providers, agents, and individual tools, then records the context around every agent interaction.
  4. Yes. Metorial records provider activity so teams can inspect tool calls, troubleshoot integrations, and give security teams the visibility they need.