
Open source semantic layer for centralized metrics management
MLCraft (now Synmetrix) is an open source data engineering platform and semantic layer built on Cube. It provides a complete framework for modeling, integrating, transforming, aggregating, and distributing metrics data at scale, serving as a modern alternative to Looker.
Flexibly define metrics and dimensions using SQL and Cube data models to create a single source of truth across your organization
Distribute metrics downstream to any consumer via a SQL API, integrating with BI tools, dashboards, and data science workflows
Uses Cube Store as a purpose-built caching and query execution layer optimized for fast aggregations and time series data
Monitor metrics with scheduled reports and real-time alerts with notification capabilities for critical data events
Track schema changes over time with built-in versioning for full auditability and governance
Set personalized user permissions and data security policies to control who can access which metrics
Seamlessly connect to BigQuery, Snowflake, ClickHouse, Redshift, Databricks, PostgreSQL, and many more
Create a single source of truth for business metrics across multiple data warehouses, eliminating inconsistent definitions across teams
Enable business analysts and decision makers to explore data and generate queries without SQL knowledge through the visual interface
Replace proprietary BI tools like Looker with a self-hosted, open source semantic layer that integrates with existing BI tools via SQL API
Build real-time data transformation pipelines with caching, pre-aggregations, and multi-source integration for production workloads
Visual data exploration interface that makes data accessible to non-technical users without requiring SQL knowledge
Deploy on your own infrastructure with Docker Compose for full control over data and security

AI-powered SQL client that turns natural language into database queries