offdataai
DuckDB

AI DuckDB schema generator

Describe your domain or pick a template, choose DuckDB, and get clean DuckDB DDL with keys, history and audit columns, from the same model that ships to your production warehouse.

  • From $1/month
  • 8 SQL targets
  • 174 templates
freshcart.duckdb · localIn-process
.db

freshcart.duckdb

single file · no server

  • dim_customer
  • dim_product
  • dim_store
  • fct_order_line
  • fct_stock_snapshot
dbt-duckdb ready
D
region · revenue0.0 ms
West
North
South
East

4 rows · ran inside the process, no network hop

One file on your laptop: native DuckDB DDL, queried in-process in milliseconds, and the same model built with dbt-duckdb.
Built for DuckDB

What offdataai writes for DuckDB

Keys DuckDB actually enforcesduckdb
1CREATE TABLE IF NOT EXISTS sales.fct_orders (
2 order_key BIGINT NOT NULL,
3 date_key BIGINT NOT NULL,
4 customer_key BIGINT NOT NULL,
5 order_total DECIMAL(18,4),
6 PRIMARY KEY (order_key),
7 FOREIGN KEY (date_key)
8 REFERENCES conformed_dimensions.dim_date(date_key),
9 FOREIGN KEY (customer_key)
10 REFERENCES conformed_dimensions.dim_customer(customer_key)
11);

Enforced

Primary and foreign keys

One file

No server to run

dbt-duckdb

Profile included

UUID · JSON · BLOB

Native DuckDB types

Types, mapped for DuckDB

from the generator

Your model's logical types become native DuckDB types.

stringVARCHAR
textVARCHAR
integerINTEGER
bigintBIGINT
decimalDECIMAL(18,4)
doubleDOUBLE
booleanBOOLEAN
dateDATE
timestampTIMESTAMP
jsonJSON
uuidUUID
binaryBLOB
Watch the demo

See it in action

A narrated walkthrough, recorded in the real app.

The difference

DuckDB by hand, or generated

By hand

  • ○Translate warehouse DDL into DuckDB types
  • ○Order tables so foreign keys resolve
  • ○Write a dbt profile and placeholder data
  • ○Keep the local copy in step with production

With offdataai

  • Native types: UUID, JSON, BLOB, DECIMAL
  • Tables emitted in dependency order
  • dbt-duckdb profile and seeds included
  • One model, regenerated for every platform
Your workflow

Where offdataai fits in your DuckDB stack

1

Pick a template or describe it

Start from one of 174 templates or the AI interview, with DuckDB as the target.

2

Generate DuckDB DDL

Schemas, tables in dependency order, enforced keys.

3

Run it locally

Load it into a .duckdb file and query it in-process.

4

Build with dbt-duckdb

The bundled seeds let dbt build run end to end on your laptop.

PII intent as column comments

DuckDB has no native column masking, so the masking intent is written as column comments, with a suggested secure-view expression for each tagged column.

1COMMENT ON COLUMN conformed_dimensions.dim_customer.email
2 IS 'masking:hash; classification:pii';
3COMMENT ON COLUMN conformed_dimensions.dim_customer.first_name
4 IS 'masking:partial; classification:pii';
5
6-- Suggested secure-view expressions:
7-- SELECT left(first_name, 2) || '***' AS first_name
Capabilities

What offdataai generates for DuckDB

  • DuckDB-native DDL

    VARCHAR, BIGINT, DECIMAL, DOUBLE, TIMESTAMP, JSON, UUID and BLOB, with CREATE SCHEMA and CREATE TABLE IF NOT EXISTS.

  • Keys in the right order

    Primary and foreign keys are emitted and tables are ordered by dependency, so the script runs top to bottom.

  • History and audit columns

    Type 2 dimensions get effective_date, expiry_date and is_current; audit columns are added where the model asks for them.

  • One model, eight platforms

    Switch the target to Snowflake, BigQuery, Databricks, Redshift, Synapse, Fabric or Postgres without remodeling.

Overview

Why teams choose offdataai

app.offdataai.com
Platform-native DDL, ready to copy, download or push to Git

Platform-native DDL, ready to copy, download or push to Git

  1. 01

    DuckDB has become the default way to prototype analytics locally. offdataai treats it as a first-class target: the same validated model that produces Snowflake or BigQuery DDL also compiles to DuckDB, with native types, schemas, primary and foreign keys in dependency order, and SCD2 history columns.

  2. 02

    Prototype on your laptop, then switch the target platform when you are ready for production.

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.

  • DuckDB-native DDL
  • Keys in the right order
  • History and audit columns
ddl/duckdb.sqlduckdb
1CREATE SCHEMA IF NOT EXISTS marts;
2
3CREATE TABLE IF NOT EXISTS marts.dim_customer (
4 customer_sk BIGINT NOT NULL,
5 customer_id VARCHAR NOT NULL,
6 plan_id VARCHAR,
7 attributes JSON,
8 effective_date TIMESTAMP NOT NULL,
9 expiry_date TIMESTAMP NOT NULL,
10 is_current BOOLEAN NOT NULL,
11 PRIMARY KEY (customer_sk)
12);
13
14CREATE TABLE IF NOT EXISTS marts.fct_usage (
15 usage_id VARCHAR NOT NULL,
16 customer_sk BIGINT NOT NULL,
17 event_ts TIMESTAMP NOT NULL,
18 api_calls BIGINT NOT NULL,
19 PRIMARY KEY (usage_id),
20 FOREIGN KEY (customer_sk) REFERENCES
21 marts.dim_customer(customer_sk)
22);

Generates native SQL and dbt for 8 platforms · connects live to Snowflake, Databricks, BigQuery, Redshift and Postgres

SnowflakeBigQueryDatabricksRedshiftPostgreSQLSynapseFabricDuckDBdbtSnowflakeBigQueryDatabricksRedshiftPostgreSQLSynapseFabricDuckDBdbt
FAQ

Frequently asked questions

Can offdataai generate DuckDB DDL?
Yes. DuckDB is one of eight target platforms. Choose DuckDB and offdataai emits DuckDB-native CREATE SCHEMA and CREATE TABLE statements from your validated model.
How are types mapped to DuckDB?
Model types map to DuckDB types: strings to VARCHAR, integers to INTEGER, BIGINT or SMALLINT, decimals to DECIMAL, floats to REAL or DOUBLE, timestamps to TIMESTAMP, semi-structured data to JSON, identifiers to UUID and binary to BLOB.
Does the DDL include keys and history?
Yes. Primary keys and foreign keys are emitted, with tables created in dependency order so references resolve. Type 2 slowly changing dimensions get effective_date, expiry_date and is_current columns, and audit columns are added where the model asks for them.
Why model for DuckDB?
DuckDB is a fast in-process analytics database that is popular for local development, prototyping and embedded analytics. Modeling once in offdataai lets you prototype on DuckDB and ship the same model to Snowflake, BigQuery, Databricks or another warehouse.
Which modeling paradigms are supported?
Kimball dimensional models, Data Vault 2.0 and 3NF, from the AI interview, a template or an imported database.

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 Generate and Connect. 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