OWOX Data Marts

Free connectors and ontology-backed self-service analytics without hallucinations

Plug your sources into ready-to-prompt ontology models and get hallucination-free self-service analytics. Give people and AI agents joinable Data Marts in the tools they already know: API, CLI, MCP, Google Sheets, Excel, Claude, ChatGPT, Data Studio and more destinations. No extra chat tool, no semantic-layer tax, no black boxes. No LLM writes the SQL behind a business user’s answer, so nobody downstream gets a hallucinated number with your name on it.

📘 Quick Start Guide · 📚 Docs · 🌐 Website · 🆘 Issues

Why OWOX Data Marts

1. Zero hallucinations. No LLM writes the SQL behind a business user’s answer. Every answer resolves to your ontology model: Data Marts are the entities, declared joins are the relationships. A metric nobody defined goes back to its owner instead of being guessed. Patented.

2. Same number everywhere. Sheets, Excel, Data Studio, Claude and ChatGPT query one model, so revenue means one thing.

3. You control the handoff. Nothing reaches business users until you publish it. Access is set per Data Mart and Data Context.

4. No semantic-layer tax. No YAML that goes stale by next Tuesday. Just your SQL, plus metadata that AI autofills for you to review.

5. Free connectors. MIT-licensed, with no per-connector bill. A missing API takes the Connector Builder, not code.

6. Your warehouse. Data Marts run as queries in Google BigQuery, Snowflake, AWS Redshift, AWS Athena or Databricks. No second copy. Self-host for free.

7. Agent-friendly. The owox-ctl CLI and the MCP server work out of the box, so your AI can set it up for you:

   Dear coding agent, set up owox-data-marts and connect the sources I need.

How it works

1. Connect sources to your warehouse.
2. Define Data Marts from SQL, a table, a view or a connector, and declare joins.
3. Publish to destinations, or to Claude and ChatGPT through MCP.
4. Schedule report refreshes and data quality checks.

Data sources

Shopify, Facebook Ads, Google Ads, TikTok Ads, LinkedIn Ads, X Ads, Microsoft Ads, see all

Data storages

Google BigQuery, Snowflake, AWS Redshift, AWS Athena, Databricks

Data destinations

Google Sheets, Microsoft Excel, Data Studio, Claude, ChatGPT, Slack, Microsoft Teams, Email, Google Chat, see all

Missing an integration? Request it in Discussions, make it with the Connector Builder, or write your own.

🧑‍💻 Contribute

1. Read the Contributor Guide.
2. Check open Issues.
3. Join Discussions.

New connectors, docs fixes and bug reports are all welcome, and we spotlight contributors.

🛠 Quick Start

(1) Install Node.js 22.22.0+ download

(2) Install OWOX Data Marts

npm install -g owox

(3) Start it

owox serve

(4) Open http://localhost:3000 🎉

For Docker and cloud deployment, see the Quick Start Guide. Then create your first Data Mart.

📌 License

OWOX Data Marts is free for internal or client use, but not for resale in a competing product. Dual-license model:

• Connectors (packages/connectors): MIT License
• Platform (all other files): ELv2 License
• Enterprise features: Enterprise License (files in apps/backend/src/data-marts/data-destination-types/ee or containing .ee. in the filename)

Enterprise pricing: owox.com/pricing

---

Star this repo if it saves you from rebuilding the same report every week.