Malloy
malloydata.dev
- Free plan
- Windows
- macOS
- Linux
- Web
- Browser extension
- API
- Self-hosted
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.