An experimental language for data

Welcome to Malloy - an open source language that offers a new way to compose with data, to expose the intelligence you need, all with a single query.

Each query you write in Malloy is a building block for the next level of understanding. The more queries you build, the more refined your understanding becomes.

Malloy is the first hyper-dimensional programming language built for the needs of a big data world.

What is hyper-dimensionality?

When you're working with complex data, and want to see the relationships between data, Hyper-dimensionality allows composition not just with measures and dimensions, but with entire queries and across the relationship graph. This exposes all the interesting facets of a data set, simultaneously, in an easy and understandable way.

Model and Query

Malloy is a semantic data model and a query language in one. Seamlessly build your reusable model as you go.

Hyper-dimensional

Reusable components that expose all the relationships within the data set simultaneously and in a single view.

Superpower your SQL

Malloy writes SQL, optimized for your BigQuery, DuckDB or Postgres (beta) database.

How it works

Discover how easy it is to write queries using Malloy to produce rich hierarchical views of data.

No more rewriting queries to create hierarchies. Queries are reusable components in Malloy.

See relationships and dimensions of the data simultaneously - giving you unparalleled insights.

Playground

Try Malloy in one of our no-install, completely web-based demo environments.

Composer

Explore data modeled in Malloy

Fiddle

Try out the language

Malloy Composer lets you build a web based data exploration experience by adding just 3 files to your data model. Learn more

Get started

Install Malloy to use with your own data.

VSCode Extension

Develop and explore Malloy models.

Composer

Explore modeled data in a visual composer application.

npm Package

Build applications on top of Malloy.

Fiddle

Share your data using a Malloy fiddle.

Resources

Documentation

Language reference and Quickstart guide

Slack

Please join our Slack community!
We'd love to help.

Github

Discussion, feature requests, and bug tracking

Malloy is full of new ideas. As you work with Malloy, we'd love to help explain them.
Please ask your questions, as they will help Malloy be better. See you on Slack!