Skip to the content
Know your tech before you buy it. Makers: get listed from $49/mo

Malloy

malloydata.dev

  • Free plan
  • Windows
  • macOS
  • Linux
  • Web
  • Browser extension
  • API
  • Self-hosted
8.0 Club score Visit malloydata.dev

What Malloy is

Malloy is an open source language for describing data relationships, transformations, and reusable business logic. Users define calculations, table relationships, and queries in semantic models, then compile Malloy queries into SQL optimized for the connected database. It supports nested datasets and automatically prevents common aggregate errors involving sums, averages, and counts. Supported databases include DuckDB, MotherDuck, BigQuery, Databricks, Snowflake, PostgreSQL, MySQL, Trino, and Presto. DuckDB can read Parquet, CSV, and JSON files without extra setup. Malloy offers a Visual Studio Code extension for modeling, querying, transformations, and visualizations, as well as a browser notebook through github.dev that requires a GitHub sign-in. Its open source Python package loads models, compiles queries, and runs statements with DuckDB and BigQuery. The CLI can run Malloy files, build persistent tables, and automate transformations and pipelines. DuckDB connections can disable network access, and sandboxed mode also limits file access to permitted directories. The CLI binary is not notarized on macOS and requires explicit permission in Privacy and Security settings.

Who it suits

Malloy suits SQL users who want to define reusable data models and queries across supported databases. It may also fit teams using VS Code, Python, or the CLI to build and automate data workflows.

Good to know, and what to watch

  • Compiles queries into SQL optimized for the connected database
  • Supports nine listed database systems
  • Reads Parquet, CSV, and JSON through DuckDB
  • Offers a VS Code extension and Python package
  • DuckDB sandboxing can limit network and file access
  • The browser notebook requires a GitHub sign-in
  • The macOS CLI binary requires explicit permission

The verdict

Malloy offers a reusable semantic modeling language with database-specific SQL output, editor support, and automation options. macOS CLI users should account for the additional permission step.

What the maker publishes

Aggregations
Malloy reuses aggregate computations across query granularities and says this helps improve accuracy. source
Authoring
The VS Code extension includes schema browsing, query execution, language autocomplete, documentation, and result visualizations. source
Browser use
The project offers a browser-based Malloy notebook through github.dev, which requires a GitHub sign-in. source
Browser use
The Malloy extension works in VS Code Web, where it supports DuckDB with local CSV, JSON, and Parquet files; BigQuery, Snowflake, and PostgreSQL require VS Code Desktop. source
CLI
The Malloy CLI runs Malloy files, builds persistent tables, and can automate transformations and pipelines. source
CLI limitation
Malloy states that its downloadable CLI binary is currently not notarized on macOS and requires explicit permission in macOS Privacy and Security settings. source
Credential security
The VS Code connection editor stores sensitive values such as passwords and tokens in the system keychain. source
Database integrations
The documentation lists DuckDB, MotherDuck, BigQuery, Databricks, Snowflake, PostgreSQL, MySQL, Trino, and Presto as supported databases. source
Editor support
Malloy provides a Visual Studio Code extension for building models, querying and transforming data, and creating visualizations. source
Intended users
Malloy says it is immediately understandable to SQL users and easier to use and learn than SQL. source
Local data files
DuckDB support can read Parquet, CSV, and JSON files without additional setup. source
Nested analysis
Malloy supports nested query results, including fetching entire dashboards in a single query. source
Nested data
Malloy supports reading and writing nested datasets as a language feature. source
Python package
Malloy’s open source MIT-licensed Python package loads models, compiles queries, and runs statements, and currently works with DuckDB and BigQuery. source
Query execution
Malloy queries compile to SQL optimized for the connected database. source
Safer aggregates
Malloy automatically prevents miscalculating aggregates such as sums, averages, and counts. source
Security controls
DuckDB connections offer local and sandboxed security policies that disable network access; sandboxed mode also restricts file access to allowed directories. source
Semantic modeling
Malloy lets users define reusable calculations and business logic in a semantic data model. source
Semantic models
Malloy data models can encode reusable calculations, table relationships, and queries. source
SQL output
Malloy queries translate into SQL optimized for the connected database. source
Support
The project directs users to its Slack community to ask questions and share models, and to GitHub Issues for bug reports and feature requests. source
Support
Malloy directs users to its Slack community to share work, ask questions, and provide feedback, and to its GitHub project for bugs and ideas. source
Visualizations
Malloy’s rendering library can use query metadata and results to render dashboards and visualizations and support drill through to detail. source
What it is
Malloy is an open source language for describing data relationships and transformations. source

Checked against the maker's pages on 7 Oct 2026.