Schema review for warehouse teams

Review schema changes before they hit production

Diff planned changes against your live Snowflake, Databricks, or Postgres warehouse, get team approval, and hand off SQL, dbt, and contracts from one workspace.

Free plan, no cardRead-only by defaultdbt-native handoff
Works with your warehouse
Snowflake Databricks PostgreSQL MySQL dbt Apache Iceberg read-only
The problem

Schema changes ship faster than anyone can review them

DDL runs in a console, the diagram drifts in a wiki, and the contract lives in a doc. Nothing reviews the change before it reaches production.

Changes ship without review

DDL gets run straight in a console or buried in a migration. Nobody sees the blast radius until something downstream breaks.

dbt models and BI dashboards break in production.

The warehouse drifts

The diagram in the wiki stopped matching reality months ago. Nobody trusts it, so nobody keeps it current.

Decisions made against a schema that no longer exists.

Diagrams and deploys disconnect

Modeling lives in one tool, DDL in another, contracts in a third. Keeping them in sync is manual and lossy.

Copy-paste errors between diagram, console, and PR.
How it works

One reviewed path from model to production

Five steps, one workspace — no copy-pasting DDL between a diagram tool, a console, and a pull request.

01

Model

Design on the canvas or in DSL, or import from SQL, dbt, or a live warehouse.

02

Diff

Compare the planned schema against live warehouse state, column by column.

03

Review

Share an approval link; reviewers see exactly what is added, dropped, and breaking.

04

Approve

Sign off with a dry-run validated against production before any DDL runs.

05

Publish

Push reviewed DDL, or hand off SQL, dbt models, and data contracts.

Model

Canvas and DSL — model the full medallion stack

Sketch bronze, silver, and gold in one diagram, or write it as DSL and watch the canvas follow. Keys, roles, and relationships stay in sync both ways.

  • Import from SQL DDL, dbt YAML, or a live warehouse — start from what you already run.
  • AI-assisted star-schema and medallion drafts from a prompt and your source tables.
  • Smart auto-layout and FK detection keep large schemas readable as they grow.
Diff & approve

Visual diff and approval before any DDL runs

Every change is a reviewable artifact: see exactly what's added, dropped, and breaking against the live warehouse, then approve and push with a dry run.

  • Side-by-side diff of planned vs live schema, column by column.
  • Shareable review links to approve or reject before any DDL runs.
  • Push reviewed DDL with a dry-run preview and background drift detection.
Publish

Author, publish, and validate data contracts

Turn a reviewed schema into a living contract: owners, SLAs, and column rules that publish to a page and stay green in CI.

  • Owners, SLAs, and column rules authored right in the editor.
  • Export ODCS, dbt, Soda, and Great Expectations from one source of truth.
  • Published contract pages with live CI health and column-level lineage.
Why SchemaStruct

Not another ERD tool

Diagrams, docs, and catalogs all describe your schema. None of them review the change before it ships.

Category
The gap
SchemaStruct
ERD tools
Pretty diagrams that drift from the warehouse the moment they're drawn.
Diffs live state and pushes reviewed DDL.
dbt docs & Cloud
Documents models, but review happens after the change already ran.
Review and approve before any DDL runs.
Data catalogs
Inventory what exists; they don't model or gate what's coming next.
Design, contract, and hand off in one flow.
Whiteboards & docs
Free-form sketches with no types, keys, or connection to production.
Warehouse-aware models with real types and FKs.
Security & governance

Enterprise-ready by design

SchemaStruct touches your warehouse with the least privilege possible and keeps every change auditable.

Read-only by default

Introspection uses read-only credentials. Writes only happen through reviewed, dry-run-checked DDL you approve.

Dry-run before any DDL

Every push is validated against live warehouse state first, so a plan never surprises production.

Git-native workflow

GitHub sync, a CI CLI, and PR comments on schema diffs — review lives where your team already works.

Shared workspace controls

Team workspace management, shared review links, and centralized billing. SSO and granular admin controls are on the Enterprise roadmap.

Auditable change log

Version history tracks every schema and contract change, with diff summaries you can replay or roll back.

Security & procurement

We support security questionnaires and procurement workflows — talk to us about data handling and team rollout.

Reviewing data handling or compliance posture? Talk to us →
Pricing

Start free, scale when review becomes a habit

Prices in INR. Every plan includes the visual editor, schema diff, and SQL export.

Free
₹0/month

For solo modeling and trying the review workflow.

  • Up to 5 saved diagrams
  • Visual canvas + DSL editor
  • Schema diff and SQL export
  • Star schema and medallion templates
  • Data Lab (CSV, JSON, Parquet)
Most popularPro
₹199/month

For analytics engineers who review every change.

  • Everything in Free, plus
  • Unlimited saved diagrams
  • AI schema generation + copilot
  • Snowflake and Databricks introspection
  • dbt import, export, and GitHub sync
Team
₹1,499/month

For data platform teams that govern the warehouse.

  • Everything in Pro, plus
  • Shared workspace sync
  • Team workspace management
  • Centralized team billing
  • SSO & admin controls (Enterprise roadmap)
Stop shipping blind

Every unreviewed schema change is a downstream break waiting to happen

Diff it, review it, and hand it off — before it ever reaches production.