airlayer

airlayer

In-process semantic engine. Compiles YAML semantic definitions to dialect-specific SQL. Compatible with LookML, Cube.js, dbt MetricFlow, and Omni. Built to be embedded, scripted, or called by agents.

GitHubApache-2.0

Embedded demo (via WASM)

Airlayer compiles semantic layer definitions to SQL. Works with its native format or your existing LookML, Cube.js, dbt MetricFlow, and Omni schemas — no migration required.

Native .view.yml format
orders.view.yml
Query JSON
Compiled SQL

Install

$ bash <(curl -sSfL https://raw.githubusercontent.com/oxy-hq/airlayer/main/install_airlayer.sh)

Installs the airlayer binary to your system.

Supported databases

bigqueryclickhousedatabricksdomoduckdbmotherduckmysqlpostgresprestoredshiftsnowflakesqlite

Quick start

Initialize airlayer in your project directory. The CLI will walk you through database connection and schema discovery.

terminal
$ airlayer init

This generates:

  • config.yml — database connection
  • views/*.view.yml — semantic layer definitions
  • CLAUDE.md — project instructions for Claude Code
  • .claude/ — agents and skills for Claude Code

airlayer init

Claude Code integration

Airlayer generates Claude Code agents and skills for working with your semantic layer:

  • analyst— answers data questions via semantic queries
  • builder— creates and edits view definitions

Skills include bootstrap, profile, and query for schema discovery, data profiling, and semantic queries.