malloydata/malloy

Health v2 · maintenance only

Flags: no_license

Adoption not part of the score

2559 stars · 134 forks observed · 2026-08-28

What it is AI-extracted, prompt v1, taxonomy v1, 2026-08-30, confidence not recorded

Malloy is an open-source semantic modeling and query language that compiles to SQL and runs on existing database engines like BigQuery, Snowflake, DuckDB, and PostgreSQL. It ships as an npm library plus VS Code extension, CLI, and Python package for building reusable data models and analytics.

Use cases

• write reusable semantic data models over a sql warehouse
• compile analytics queries to sql for bigquery or snowflake
• prevent incorrect aggregate calculations like fanout sums
• explore nested data and build hierarchical query views
• build dashboards and visualizations from a semantic model
• replace hand-written sql with composable analytical queries
• query duckdb or postgres from a modeling language

When to choose

• you want a semantic layer with composable, reusable analytics on top of a supported SQL engine
• you need safer aggregates and nested-data handling than raw SQL provides
• you work in VS Code or Jupyter and want an integrated modeling and query experience

When to avoid

• your database engine is not among the supported dialects
• you need a general-purpose programming language rather than an analytical query language
• your team is unwilling to learn a new DSL alongside SQL

Facets

library · maturity active

parser data-science data-visualization compiler sdk data-science analytics databases programming-languages python cli editor-plugin cross-platform semantic-modeling sql-generation query-language analytics vscode-extension duckdb bigquery snowflake dbt-alternative data-engineering nodejs web-server

Member repositories

For agents

markdown · JSON · MCP: product_card(name="malloydata/malloy")