Sidemantic plugin
A plugin with two skills over a semantic metrics layer: the agent writes models in YAML and queries them through SQL.
- 139 ★ on the repository
- Last commit
Extended access
Why this level
- Queries run against your database, and the `serve` server exposes data over the network.
Install
- Works in
In your terminal, with SkillFoxx CLI
npx skillfoxx add plugins/sidemanticDetects the agents on your machine, shows the access level and pins the version.
Other ways to install
Access and checks
How we reviewExtended accessThe tool runs code or makes network calls and only reads external data.
- Queries run against your database, and the `serve` server exposes data over the network.
This is third-party code. Review the repository files before installing.
What it does
Sidemantic is an open semantic layer where metrics are defined once and computed the same way from SQL, the CLI, Python, HTTP, PostgreSQL clients, notebooks and agents. Models are written in YAML, semantic SQL or Python, and existing definitions import from Cube, dbt MetricFlow, LookML, Power BI, Malloy and other formats. Queries run on DuckDB, BigQuery, Snowflake, ClickHouse, Databricks and more. For agents the repository ships a plugin for Claude Code and Codex with two skills: `modeler` builds and validates models, `webapp-builder` assembles a web app. The `sidemantic serve` command starts a web UI, HTTP API and MCP on one port.
Who it is for. Data analysts and engineers who want one definition of each metric and an agent to handle the modelling.
Good fit when
- Metrics drifted across BI tools and one source of definitions is needed.
- An existing Cube or MetricFlow project must move to another format.
- An agent should answer data questions through vetted metrics rather than arbitrary SQL.
- A database schema must become models with dimensions and relationships.
Not a fit when
- A ready BI dashboard is wanted with no model setup.
- The AGPL-3.0 license does not fit your product.
- Data is small and plain SQL is enough.
Example request
Create an orders model from CSV, define revenue and order_count metrics, check it with `sidemantic validate` and show a query by status.Limitations
The AGPL-3.0 license puts obligations on embedding into closed products. The agent part is small, two skills, and the main value is the metrics layer itself. Connecting a cloud warehouse needs your own credentials, and `serve` exposes data over the network, so put authentication in front of it. Some extras install separately. The project evolves quickly: import formats and extras change between releases, so pin a version in working projects. The demo site downloads more than 50 MB of data.
How to disable. Remove the plugin through the Claude Code or Codex plugin manager. Stop the `sidemantic serve` process if it was started.
FAQ
How do I try it quickly?
Run `uvx sidemantic demo`. It creates a demo project with DuckDB data and runs a first query.
How do I install the plugin in Claude Code?
`claude plugin marketplace add sidequery/sidemantic && claude plugin install sidemantic@sidequery`. Codex has a similar pair of `codex plugin` commands.
Which formats can be imported?
Cube, dbt MetricFlow, LookML, Power BI TMDL/DAX, Hex, Rill, Superset, Omni, Malloy and more. The adapter guide has the full list.
Is there an MCP server?
Yes. `sidemantic serve` starts a web UI, HTTP API and MCP on one port.
Which warehouses are supported?
DuckDB, MotherDuck, PostgreSQL, BigQuery, Snowflake, ClickHouse, Databricks, Spark SQL and ADBC sources.
Discussion
No questions or reviews yet.
Related
PluginsSemantica plugin: 17 skills and 3 agents for knowledge graphs, reasoning and data provenance in Claude Code, Cursor and Codex.
The UModel plugin gives an agent three skills to read entities and topology from a graph and trace root causes locally.
A plugin marketplace for Claude Code and GitHub Copilot on Power BI and Microsoft Fabric: semantic models, DAX, TMDL, reports
A text-to-SQL MCP server: an agent asks a database in words, gets SQL plus a trace, and a stated refusal when data is missing.
Three Claude Code plugins: queries to OpenData public datasets, OpenChart charts and tables, and SVG graphics.
A Claude Code and Codex plugin that builds an ontology over your tables and files and refines it from the agent's work history
Comparison with similar tools
Cards that share the main search query, and how they differ.
| Tool | Official | Authentication | Repository stars | Main difference |
|---|---|---|---|---|
| Sidemantic (this card) | no | 139 | ||
| dbt Agent Skills | yes | 756 | skills for working with dbt; Sidemantic keeps its own metrics layer and imports definitions from dbt MetricFlow, Cube and LookML | |
| dbt MCP | yes | API key | 616 | an MCP server for dbt projects; Sidemantic provides a metrics layer with SQL, HTTP and MCP plus a plugin with two skills |
README in short
The README opens with the metrics layer and a one-minute quickstart, then covers usage paths, import formats, warehouses, Docker and an agent plugin section with install commands.