offdataai
Model Builder

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
Model Builder · canvasSaved
FactDimensionHubLinkSatelliteAuto-arrange
↓ Export JSON↓ Export PNG
Drag Kimball, Data Vault or 3NF blocks onto the canvas; no AI credits needed.
Watch the demo

See it in action

A narrated walkthrough, recorded in the real app.

How it works

Three steps, minutes not months

1

Describe or import

Answer a short interview, open a template, draw on the canvas or connect a live database.

2

Review a validated model

Keys, grain, history and PII are checked before any code is written. Refine it in plain English.

3

Ship and keep it current

Native DDL, dbt, seeds, docs and an ontology. Push to Git, diff versions, generate migrations.

Overview

Why teams choose offdataai

app.offdataai.com
The canvas in full screen, with SCD2 history and PII flags on every table

The canvas in full screen, with SCD2 history and PII flags on every table

  1. 01

    Not every model should start with a conversation.

  2. 02

    When you know exactly what you want, drawing it is faster than describing it.

  3. 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.

  4. 04

    Open the canvas in full screen for large models and press Arrange to lay everything out cleanly.

  5. 05

    Every change saves automatically.

  6. 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.

  7. 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.

Real output

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
model-builder · export.jsonjson
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}
Capabilities

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

SnowflakeBigQueryDatabricksRedshiftPostgreSQLSynapseFabricDuckDBdbtSnowflakeBigQueryDatabricksRedshiftPostgreSQLSynapseFabricDuckDBdbt
FAQ

Frequently asked questions

What is the offdataai Model Builder?
A visual, drag-and-drop canvas for designing a data model by hand. You add building blocks, define columns and draw relationships, then use the model in the rest of offdataai, for example as the source of an ontology.
Which modeling styles does it support?
Three groups of building blocks. Dimensional (Kimball): dimension, date dimension, junk dimension, fact, factless fact and bridge. Data Vault 2.0: hub, link, satellite, effectivity satellite, point-in-time and reference tables. Relational (3NF): table, associative table, lookup and reference table.
What can I set on each column?
A name and one of 13 types (varchar, text, integer, bigint, smallint, numeric, decimal, float, boolean, date, timestamp, json, uuid), plus primary key, business key, PII and nullable flags.
Does the Model Builder use AI credits?
No. It is included on every plan, including Explorer at $1/month, and it uses no AI credits.
Does it save my work?
Yes, automatically. There is no save button to forget; models appear in your list where you can reopen, rename or delete them. You can also export a model as JSON or as a PNG image.
Can I import a model from a JSON file?
Yes. Export JSON writes the whole canvas: tables, columns, relationships and where each box sits. Import JSON reads that file back as a new model in your account, laid out as it was. Files exported before the current format still import; their boxes are laid out on a grid.
When should I use the Model Builder instead of the AI interview?
Use the Model Builder when you already know the design and want to draw it precisely. Use the AI interview when you want offdataai to propose the design from a description of your business, or start from one of 174 templates.

Part of the offdataai platform

The business context behind accurate AI answers, built from the data model up.

See all six stages →
  1. 01DesignLogical, physical and dimensional models.
  2. 02GenerateSQL, dbt, documentation and migrations.
  3. 03DefineBusiness metrics, semantic models and ontology.
  4. 04ConnectReal warehouse schemas and metadata.
  5. 05GovernDrift, impact analysis, tests and approvals.
  6. 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.

Accuracy starts with context

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.

Book a demoGet started

Self-serve plans available