Drag-and-drop data modeling on a full-screen canvas
Build Kimball, Data Vault 2.0 or 3NF models by hand. Drop building blocks onto the canvas, define typed columns, draw relationships and let auto-arrange tidy the layout. Included on every plan, with no AI credits needed.
- From $1/month
- 8 SQL targets
- 174 templates
See it in action
A narrated walkthrough, recorded in the real app.
Three steps, minutes not months
Describe or import
Answer a short interview, open a template, draw on the canvas or connect a live database.
Review a validated model
Keys, grain, history and PII are checked before any code is written. Refine it in plain English.
Ship and keep it current
Native DDL, dbt, seeds, docs and an ontology. Push to Git, diff versions, generate migrations.
Why teams choose offdataai

The canvas in full screen, with SCD2 history and PII flags on every table
- 01
Not every model should start with a conversation.
- 02
When you know exactly what you want, drawing it is faster than describing it.
- 03
The Model Builder gives you a canvas with the building blocks data modelers actually use: facts and dimensions, hubs, links and satellites, bridges, lookups and reference tables.
- 04
Open the canvas in full screen for large models and press Arrange to lay everything out cleanly.
- 05
Every change saves automatically.
- 06
Export the model as JSON to keep it in version control or share it, and import that file to get the same model back.
- 07
Export a PNG for documentation, or use the model as the source of an ontology so your business vocabulary starts from the design you drew.
The code it writes, not a sketch
This is the shape of what offdataai generates here, straight from the validated model. Copy it, download it, or push it to Git.
- Building blocks for three methodologies
- Typed columns and flags
- Relationships with cardinality
1{2 "format": "offdataai.builder-model",3 "format_version": 1,4 "name": "Invoicing",5 "document": {6 "schema_version": "builder-0.1",7 "entities": [8 {9 "id": "n1", "name": "dim_customer", "kind": "dimension",10 "position": { "x": 40, "y": 60 },11 "columns": [12 { "id": "c1", "name": "customer_sk", "type": "bigint",13 "is_pk": true, "nullable": false },14 { "id": "c2", "name": "customer_id", "type": "varchar",15 "is_business_key": true },16 { "id": "c3", "name": "email", "type": "varchar",17 "pii": true }18 ]19 },20 { "id": "n2", "name": "fct_invoice", "kind": "fact",21 "position": { "x": 360, "y": 60 }, "columns": [] }22 ],23 "relationships": [24 { "id": "r1", "from_entity_id": "n1",25 "to_entity_id": "n2", "cardinality": "one_to_many",26 "fk_column": "customer_sk" }27 ]28 }29}
What the Model Builder gives you
Building blocks for three methodologies
Dimension, fact, factless fact, junk and date dimensions; hub, link, satellite, effectivity satellite and PIT; tables, lookups and associative tables.
Typed columns and flags
13 column types, with primary key, business key, PII and nullable flags on each column.
Relationships with cardinality
Draw edges between tables and set 1:1, 1:N or M:N cardinality and the foreign key column.
Full screen and auto-arrange
Work on large models in full screen, collapse the sidebar, and lay out the whole diagram in one click.
Autosave, export and import
Changes save as you go. Export JSON for version control and import it back as a new model, or export a PNG for docs and reviews.
Feeds your ontology
Use a saved model as an ontology source, so concepts and relations come from the design you drew. Ontologies start on the Starter plan.
0
Validated templates
0
SQL targets
0
Modeling paradigms
0+
Industries covered
Generates native SQL and dbt for 8 platforms · connects live to Snowflake, Databricks, BigQuery, Redshift and Postgres
FabricDuckDB
FabricDuckDBFrequently asked questions
What is the offdataai Model Builder?
Which modeling styles does it support?
What can I set on each column?
Does the Model Builder use AI credits?
Does it save my work?
Can I import a model from a JSON file?
When should I use the Model Builder instead of the AI interview?
Explore offdataai
- AI Data ArchitectHire Atlas by the hour: voice or text, 43 languages, read-only.
- Semantic layerGoverned metrics, compiled to SQL for people and AI agents.
- Context layer for AI agentsConcepts, metrics, join paths and docs for agents over MCP.
- Data catalogEvery table and column, which concepts use it, where it's copied.
- Data modeling tools comparedDesktop, diagram, code-first and AI-native tools side by side.
- Ontology builderTurn a data model into a published business ontology.
Part of the offdataai platform
The business context behind accurate AI answers, built from the data model up.
- 01DesignLogical, physical and dimensional models.
- 02GenerateSQL, dbt, documentation and migrations.
- 03DefineBusiness metrics, semantic models and ontology.
- 04ConnectReal warehouse schemas and metadata.
- 05GovernDrift, impact analysis, tests and approvals.
- 06ActivateMake trusted context available to AI agents.
This page covers Design. Every stage works on the same model, so what you design here carries through to the rest.
Give your AI agents context they can trust.
Design the model, define what your metrics mean, and serve that context to every agent and BI tool, on the warehouse you already run.
