Malloy
Malloy: A developer-focused semantic layer for reusable models, SQL compilation, and API access. Ranked #18 of 28 in Semantic Layer Software by our editors (7.6/10); pricing: Open source; best for developers building open-source semantic models.
At a glance
- Editor score7.6 / 10
- PricingOpen source
- Best forDevelopers building open-source semantic models
- Paid fromFree
- Governed metricsYes
- Facts checked20 Sep 2026
Where it wins
- Reusable dimensions, measures, aggregates, joins, and named queries
- Compiles modeled queries to SQL across multiple database systems
- VS Code, REST API, and MCP workflows support development and access
Where it doesn't
- Self-hosted deployment puts infrastructure responsibility on the team
- The primary authoring environment is a Visual Studio Code extension
- Model publishing and API workflows add operational complexity
Our verdict on Malloy
Malloy is an open-source analytical language for describing data relationships, reusable semantic models, queries, and transformations. It is designed for analysts, data scientists, data engineers, and developers building data applications, with particular appeal for developers who want to create and maintain open-source semantic models. Malloy runs against SQL databases and compiles queries to SQL, while supporting reusable dimensions, measures, aggregates, joins, nested views, and named queries. It can also produce nested results, visualizations, and dashboard-oriented outputs.
Its standout strength is the combination of semantic modeling and developer workflow. The Visual Studio Code extension brings query execution, schema browsing, autocomplete, and result visualizations into the modeling environment. Malloy also provides a CLI, notebooks, Publisher, REST API, and MCP server. The REST API enables querying published Malloy models, while MCP connects AI assistants to semantic models. Database connectivity includes DuckDB, MotherDuck, BigQuery, Databricks, Snowflake, PostgreSQL, MySQL, Trino, and Presto, with MSSQL available through DuckDB. This gives teams several ways to author, query, publish, and integrate models.
Malloy fits teams comfortable with self-hosted deployment and code-centered data work. Its reusable modeling primitives and SQL compilation are well suited to shared definitions of metrics, relationships, and analytical queries. The trade-off is operational and workflow complexity: teams must manage their own deployment, and the primary authoring experience centers on Visual Studio Code rather than a standalone hosted interface. The combination of extensions, publishing, APIs, and MCP can support varied applications, but may be more than needed for teams seeking a simple managed reporting tool. Choose Malloy for open-source semantic modeling and developer-led data applications; choose an alternative if you need a hosted, low-operations experience.
Your product? Our editors can test Malloy in depth and publish a review, labelled as paid · from $149/mo →
Malloy pricing
Malloy fact sheet
| Free plan | Not verified |
|---|---|
| Paid from | Free |
| Governed metrics | Yes |
| Dimensions and joins | Yes |
| Row-level security | Not verified |
| Certified models | Not verified |
| Query API | Yes |
| Deployment model | Self_hosted |
| Deployment | Self-hosted, Desktop, Browser extension |
| Platforms | Web, Windows, macOS, Linux |
| Support | Community, Docs |
| Built for | Solo, Small business, Mid-market (editorial estimate) |
| Integrations | 11 integrations: DuckDB, MotherDuck, BigQuery, Databricks, Snowflake, PostgreSQL … |
| Pricing | Open source |
| Website | malloydata.dev |
| Facts checked | 20 Sep 2026 |
Malloy integrations
Malloy lists 11 integrations on its own site.
- DuckDB
- MotherDuck
- BigQuery
- Databricks
- Snowflake
- PostgreSQL
- MySQL
- Trino
- Presto
- MSSQL via DuckDB
- Visual Studio Code
Alternatives to Malloy
- CubeA governed semantic layer for teams building internal and embedded analytics.9.4
- AtScaleA strong fit for enterprise teams standardizing governed metrics across BI and AI.9.3
- GoodDataA strong fit for teams building governed, embedded analytics across multiple data sources.9.1
Also Ranked In
Malloy is ranked in 2 of our directories.
Used Malloy? Be the first to review it
The editor score above is our own research. What this page doesn't have yet is a reader's view — what you used Malloy for, what worked and what didn't. No stars are seeded and no review is paid for; an editor reads every one before it appears.
Write a reviewTwo minutes · verified accounts only · read by an editor before it appears
Featured on iTechGuides
Malloy is listed in our Semantic Layer Software directory. Add the badge to your site — it links back to this page.
<a href="https://www.itechguides.com/products/malloy/"><img src="https://www.itechguides.com/best/badge/malloy.svg" alt="Featured on iTechGuides" width="230" height="46"></a>
Reviewed by iTechGuides Editors · Editorial team · Updated Oct 2026
Advertiser disclosure: iTechGuides is reader-supported. Vendors can pay for top positions in our rankings and for a place on other products' pages, and we may earn a commission when you click some links. Bought places stand at the number bought; this page and our disclosure say so. Paying vendors may get a fuller, more detailed review from our editors, and that review can change their score. How we rank.
Last updated · How we research and update