# malloydata/malloy

Malloy is a modern open source language for describing data relationships and transformations.

Repository: https://github.com/malloydata/malloy
Canonical: https://ross.abutalabs.com/products/malloy
Homepage: http://www.malloydata.dev
Language: TypeScript
License: NOASSERTION
License Family: other
Topics: data, database, sql, data-visualization, malloy, semantic-modeling
Last push: 2026-08-26T21:53:41+00:00

## Health v2 (maintenance only)
Score: 95/100 (v2, computed 2026-09-03T02:39:23.370411+00:00)
- activity 99, release rhythm 86, longevity 100
- inputs: {"age_days": 1846, "days_push": 7, "days_rel": 13, "gap_med": 1.0, "n_releases_24m": 101}
- flags: no_license
- formula: round(0.45*activity + 0.35*rhythm + 0.20*longevity); archived -> min(score, 10)

## Adoption (not part of the score)
Stars 2559, forks 134 (observed 2026-08-28T04:07:00.867742+00:00)

## What it is
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
- artifact type: library
- maturity: active
- function: parser, data-science, data-visualization, compiler, sdk
- domain: data-science, analytics, databases, programming-languages
- platform: python, cli, editor-plugin, cross-platform
- tags: semantic-modeling, sql-generation, query-language, analytics, vscode-extension, duckdb, bigquery, snowflake, dbt-alternative, data-engineering, nodejs, web-server

## Member repositories
- malloydata/malloy (main) score 95

## Provenance
- Observed fields: from GitHub, fetched 2026-08-28T04:07:00.867742+00:00.
- Health v2: computed from the inputs above; adoption is never an input.
- Inferred fields (summary, facets, guidance): AI-extracted, prompt v1, taxonomy v1, on 2026-08-30T02:23:33.215552+00:00, confidence not recorded.
  - readme: https://github.com/malloydata/malloy (fetched 2026-08-28T04:07:00.867742+00:00, sha 5ecedb5d5507)
  - homepage: http://www.malloydata.dev (fetched 2026-08-29T10:06:24.452110+00:00, sha 9665edffa95e)
  - site_page: https://docs.malloydata.dev/documentation (fetched 2026-08-29T10:06:24.461003+00:00, sha 1427b86ac24c)
- Data as of 2026-08-30T08:39:29.467469+00:00.