data modeling · ERD · DDL export

Schema design that
ships with your code.

Vektir Model is a data modeling and ERD builder for data engineers. Define entities, relationships, and naming standards — then export to DDL or Mermaid ERD that lives in your repo.

Vektir Model data modeler

Data modeling built for engineers, not DBAs.

Not a heavyweight modeling tool with a 200-page manual. Designed for the way data engineers actually work — fast, code-friendly, and versionable.

Visual entity & relationship builder

Add entities, define columns with types, and draw relationships visually. One-to-many, many-to-many — the ERD updates in real time as you build.

DDL export for multiple warehouses

Export your model as runnable DDL for PostgreSQL, Snowflake, BigQuery, and more — ready to paste into a migration or drop into your /migrations folder.

Mermaid ERD output

Every model exports to Mermaid's erDiagram syntax — plain text that renders natively in GitHub READMEs, Notion, and GitLab.

Built-in naming standards

Enforce snake_case, prefix conventions, and other naming rules as you model. Catch inconsistencies before they end up in a migration and a production incident.

No account required

Open the URL, start modeling. No sign-up, no trial, no onboarding flow. Your schema stays in your browser until you choose to export.

Designed for AI-assisted workflows

Because output is plain-text Mermaid or DDL, you can paste your schema directly into an LLM to generate queries, suggest indexes, or write dbt models.

Where data engineers reach for Vektir Model.

From greenfield schema design to keeping docs in sync with production.

Schema

Greenfield database schema design

Design your tables and relationships visually before writing a single line of SQL. Export DDL when you're ready to run your first migration.

Warehouse

Dimensional modeling for data warehouses

Map out your fact and dimension tables in Snowflake or BigQuery. Export as Mermaid ERD and commit it next to your dbt project.

Review

Schema review in pull requests

Commit your schema.mmd to the repo. Reviewers see the ERD rendered directly in GitHub diffs — no tool access needed.

Docs

Living schema documentation

Keep your ERD in the same repo as the code it describes. It renders in GitHub, updates with your migrations, and never goes stale in a Confluence page nobody visits.

DDL you can run. ERDs you can commit.

Vektir Model exports to two formats: runnable DDL for your target warehouse and Mermaid ERD syntax for your documentation.

Both are plain text. Both live in Git. Both can be read by a human, an LLM, or a CI pipeline without installing anything.

Mermaid ERD PostgreSQL DDL Snowflake DDL BigQuery DDL
docs/schema.mmd Mermaid ERD
erDiagram orders ||--o{ order_items : "contains" orders }o--|| customers : "placed_by" order_items }o--|| products : "references" orders { bigint order_id PK bigint customer_id FK timestamp created_at varchar status } order_items { bigint item_id PK bigint order_id FK bigint product_id FK integer quantity }

Model your schema.
Ship the DDL.

No install, no account, no onboarding. Open Vektir Model and start building your data model right now.

no account · no install · runs in your browser