Skip to content
SPECIFICTION
Get listed

Sidemantic

sidemantic.com

WebAPISelf-hosted
Visit sidemantic.com
Spec score 6.9 #24 of 28 in Semantic Layer Software

Spec sheet

Purpose
Sidemantic is a semantic layer for defining metrics once and querying them consistently across tools.Read 9 Oct 2026 · sidequery.dev
Support
The maker links to documentation and a Discord community for the project.Read 4 Oct 2026 · sidemantic.com
License
The GitHub repository identifies the project as open source under the AGPL-3.0 license.Read 4 Oct 2026 · github.com
Maker
The site footer identifies Sidequery Corporation as the company.Read 4 Oct 2026 · sidemantic.com
Aggregation correctness
Symmetric aggregates are used to prevent double-counting across one-to-many joins.Read 4 Oct 2026 · sidemantic.com
AI access
Sidemantic can expose metrics to LLMs through MCP, with built-in guardrails for governed access.Read 9 Oct 2026 · sidequery.dev
Format imports
It imports semantic models from formats including Cube, dbt MetricFlow, LookML, Hex, Rill, Superset, Omni, Malloy, Snowflake Cortex, OSI, AtScale, GoodData, Holistics, and ThoughtSpot.Read 9 Oct 2026 · sidequery.dev
Interactive demo
The site offers an interactive workbench with built-in demo data that does not require a database.Read 4 Oct 2026 · sidemantic.com
Join handling
Cross-model queries can infer join paths from declared relationships, and symmetric aggregates are designed to prevent double-counting across one-to-many joins.Read 9 Oct 2026 · sidequery.dev
Join inference
Cross-model queries infer join paths from declared relationships without requiring a JOIN keyword in semantic SQL.Read 4 Oct 2026 · sidequery.dev
Maturity
The project describes itself as young and notes that format conversion and its Postgres protocol server may have rough patches.Read 4 Oct 2026 · github.com
Model authoring
You can define semantic models in YAML, SQL DDL, or Python.Read 9 Oct 2026 · sidequery.dev
Model imports
It imports semantic models from more than 15 formats, including Cube, MetricFlow, LookML, Malloy, and Snowflake Cortex.Read 4 Oct 2026 · sidequery.dev
Not a BI or ETL tool
Sidemantic runs on top of a warehouse and is described as neither an ETL tool nor a BI tool.Read 4 Oct 2026 · sidequery.dev
Pre-aggregation limit
Pre-aggregation routing is disabled by default and must be explicitly enabled.Read 9 Oct 2026 · sidequery.dev
Query interfaces
Sidemantic provides a SQL interface, Python API, CLI, MCP server, and Postgres wire protocol.Read 9 Oct 2026 · sidequery.dev
Warehouse connections
Documented database connections include DuckDB, MotherDuck, PostgreSQL, BigQuery, Snowflake, ClickHouse, Databricks, and Spark SQL.Read 9 Oct 2026 · sidequery.dev
Warehouse support
Native adapters are listed for Snowflake, BigQuery, Postgres, ClickHouse, Databricks, and Spark, with additional databases supported via ADBC.Read 4 Oct 2026 · sidemantic.com
Workbench
The workbench can run with built-in demo data without a database setup.Read 9 Oct 2026 · sidequery.dev

Where Specifiction places it

Alternatives to SidemanticAll alternatives →