ERD DataDesigner
Launch App Start Free

Metadata-driven modelling for modern data teams

Design your data model once. Generate the delivery assets automatically.

DataDesigner helps data engineers and analytics teams design ERDs, manage table metadata, validate relationships, and generate Databricks SQL files from one lightweight browser workspace.

Start building See how it works
✓ Browser-based ✓ Metadata templates ✓ SQL generation ✓ Import/export
customer trn customer_id PK email created_at
orders trn order_id PK customer_id FK order_amount
_meta_generators config Databricks DDL Template files Script generators
Built for Data Engineers Analytics Engineers Platform Teams Data Modellers

What you get

From ERD thinking to deployable assets

Replace scattered spreadsheets, diagrams and one-off scripts with a metadata-first modelling workflow.

◇

Visual ERD modelling

Create schemas, tables, columns and FK relationships in a canvas designed for data teams.

▣

Reusable meta templates

Define table types like transaction, SCD, dimension or custom types and auto-populate default columns.

✓

Validation reports

Catch duplicate columns, broken foreign keys, missing data types and generator configuration issues.

{ }

Import and export

Move between JSON and CSV formats for sharing, backups and integration into delivery workflows.

SQL

Databricks file generation

Generate create table, FK, stage, DQ and update SQL files into a repo-ready folder structure.

AI

AI model builder ready

Add an AI prompt flow to draft model JSON, validate it, then apply it to the canvas.

Workflow

A practical modelling path

1

Design

Create tables, columns, schemas and relationships visually.

2

Standardise

Use meta table templates to apply consistent technical columns.

3

Validate

Run checks before the model becomes delivery code.

4

Generate

Publish model JSON and SQL files to your selected repo folder.

Why teams use it

Make your metadata operational

DataDesigner turns your model into a source for automation: validation, documentation, DDL, staging SQL and custom generators can all be driven from the same metadata.

  • Reduce hand-written boilerplate SQL
  • Keep model JSON and generated code aligned
  • Give engineers repeatable file outputs
  • Let advanced users add template and script generators

Example generated folder

repo/
  sales/
    customer/
      01_customer_create.sql
      02_customer_foreign_keys.sql
      03_customer_transform.sql
      04_stage_customer_97.sql
      05_stage_customer_98.sql
      06_stage_customer_99.sql
      07_customer_update.sql

Pricing

Start small. Scale when your team is ready.

Choose a plan and subscribe securely through Stripe Checkout.

Starter

Free

For evaluation and individual modelling.

  • Local browser workspace
  • JSON and CSV export
  • Basic validation
Try now
Popular

Pro

$1099/user/mo

For engineers generating delivery assets.

  • Databricks SQL generators
  • Custom template generators
  • Validation report
  • Priority feature updates

Team

Custom

For platform teams and governed workflows.

  • Team onboarding
  • Custom generators
  • Integration planning
Contact sales

Already subscribed?

Enter your email and we’ll send you a secure access link.

FAQ

Questions customers may ask

Can the app generate custom files?

Yes. DataDesigner supports built-in, template and in-app script generators through metadata-driven generator configuration.

Ready to turn ERDs into delivery assets?

Start with a model, validate the metadata, then generate files your data team can use.

Choose a plan