looker-skills

Looker Developer Skills Repository

This repository contains a collection of "skills" designed to assist AI agents and developers in writing high-quality, standardized LookML code and guiding them through Looker onboarding. Each skill encapsulates specific instructions, best practices, and examples for different aspects of Looker development.

Installation & Usage

To use these skills in your own projects—especially to enhance AI assistants like Gemini, Cursor, Antigravity, or Claude Code—we recommend adding this repository to your project.

Installation via npx skills add (Recommended)

The skills CLI is a tool used to install and manage specialized instructions (skills) for AI agents in your workspace. To install these LookML skills in your project, use npx skills add.

npx skills add looker-open-source/looker-skills

Core LookML Skills

These skills provide specific instructions for creating and modifying LookML objects.

Models

• lookml-model: Instructions for creating and configuring Model files, including connections and includes.

Explores

• lookml-explore: Basic Explore definition, including descriptions, labels, and basic joins.
• lookml-explore-joins: Detailed guidance on defining joins, relationships, and SQL conditions.
• lookml-explore-advanced: Advanced configurations like access_filter, sql_always_where, and UNNESTing arrays.

Views

• lookml-view: Standard View definitions, sql_table_name, and file organization (Standard, Extended, Refined).
• lookml-view-derived-table: Creating Native Derived Tables (NDT) and SQL Derived Tables (SDT).
• lookml-refinements: Deep dive into LookML includes, refinements (layering), and project structure best practices.
• lookml-sets: Guide to using LookML sets for grouping fields, controlling visibility, and managing drill paths.

Fields

• lookml-fields: Overview of LookML field types (Dimension, Measure, Filter, Parameter) and the role of the sql parameter in each.
• lookml-fields-dimension: Creating Dimensions, including HTML, links, and tier types.
• lookml-fields-measure: Creating Measures, including aggregation types and drill fields.
• lookml-fields-dimension-group: Defining Dimension Groups for time and duration, including timeframe best practices.
• lookml-fields-filter-parameter: Creating Filter-only fields and Parameters for dynamic interactivity.
• lookml-fields-value-format: Standard and custom formatting for numeric and currency fields.

Advanced Functionality

Logic & Security

• lookml-liquid: Using Liquid variables for dynamic SQL, HTML, and links.
• lookml-access-grants: Implementing access_grant and required_access_grants for row-level security.
• lookml-tests: Writing LookML tests for Views and Explores.

Developer Onboarding Skills

These skills guide new Looker developers and agents through database exploration, CLI setup, project configuration, LookML modeling, and dashboard creation.