Mprove

All Metrics in One Place

Open Source Agentic Business Intelligence

with Malloy Semantic Layer

This is login-free Demo with limited features.

Self host to build your own project and use all features.

How It Works

Begin with a Clear Picture of Your Data Sources

DWH Schema Discovery: Tables, Columns, Indexes, Keys and DataTypes
Metadata Enrichment: Attach metadata to tables and columns (description, example data and relationship type)
Data Relationships Graph: Browse schemas visually. Get data samples by click.

Build Semantic Models

Get Data Answers

True Self Service: AI data analyst available 24/7
Fast Reliable Answers: User queries are guaranteed to be correct if semantic model is correct

Explore Semantic Model

Drill Down: Segment the metric by dimension
Concise Queries: Malloy queries are easy to read and understand. They translate into SQL.

Build Reports and Dashboards

Simple UI: Add metrics to reports or compose dashboard from multiple charts
Global Filters: Dashboard filters can be linked to tiles, Report filters can be linked to metric rows
Role Based Access Control: Fine-tune access to models, reports and dashboards based on user roles

Deploy Changes as Code

Git Version Control: Personal dev repository for each data analyst (developer), single common production repository for all project users
Git Commands: Manage changes reliably with git commands: commit, push, pull, fetch, merge, revert
Multiple environments: Switch connections to query against Test, Stage, Prod, etc.

Integrations

SQL DATABASES

PostgreSQL

MySQL

Databricks

SnowFlake

BigQuery

MotherDuck

Presto / Trino

HTTP API CONNECTORS

Google Analytics

Frequenty Asked Questions

Can't find the answer you're looking for?

How to do X in Malloy?: You can ask for help on the Malloy Slack channel (link in navbar on their website).
More SQL integrations?: Mprove connects to SQL databases that are supported by Malloy.
More HTTP API integrations?: To integrate with a new third-party HTTP API service, create a file with the “.store” extension containing the integration logic.
Do you support other SQL semantic layers?: If other semantic-level providers have APIs, you can use the HTTP Custom API connector.
What Malloy features are supported?: Mprove builds models based on Malloy Sources. Malloy Nesting and Calculations are not yet supported.