01
Connect and profile
Pull live schema from Snowflake, Databricks, or PostgreSQL. Import dbt metadata or ingest files in Data Lab. Profile column types and detect relationships automatically.
Schema review for warehouse teams
Review warehouse schema changes before they hit production
Diff planned changes against your live warehouse, get team approval, and ship with confidence.
Freeto start, no card
Snowflake& Databricks ready
dbtnative handoff
Snowflake & Databricksdbt native
Pull raw tables from a connected warehouse, import SQL or dbt metadata, or ingest Data Lab source files. Profile column types, distributions, and relation candidates automatically.
Schema review passed
AI star schema — dim_date, fact_orders
How it works
From source to production in three steps
Connect your warehouse, design and review changes visually, then hand off deployment-ready assets.
02
Design and review
Shape Bronze-to-Gold models on a visual canvas. Diff planned changes against warehouse state. Share a review link — approve or reject before any DDL runs.
03
Hand off and sync
Export SQL, dbt stubs, and data contracts. Push reviewed DDL back with dry-run preview. Publish living docs that stay aligned as systems evolve.
Everything in one workspace
Design. Review & deploy. Document & share.
Design
Visual Schema Design
Canvas and DSL — model the full medallion stack
Draw Bronze-to-Gold layers on a shared canvas or write in DSL. AI generates star schema drafts with fact tables, dimension keys, and grain.
- Import from SQL DDL, dbt YAML, or a live warehouse
- AI-assisted star schema and medallion generation
- Smart auto-layout and FK detection
Data Lineage
Trace data from source to Gold — column by column
Column-level lineage edges on the canvas show how data flows from raw ingestion to the Gold layer. Impact analysis flags downstream breakage before any change ships.
Review & Deploy
Schema Review & Diff
Visual diff and approval before any DDL runs
Diff planned changes against the current warehouse state, share a review link with your team, and approve or reject before any object is created or altered.
- Side-by-side visual diff of planned vs live warehouse schema
- Share review links — approve or reject before any DDL runs
- Version history with rollback to any prior reviewed state
Live Warehouse Sync
Pull live schema in, push reviewed DDL back out
Bidirectional sync for PostgreSQL, MySQL, Snowflake, and Databricks (Apache Iceberg supported for read-only introspection). Drift detection flags when production diverges.
- One-click introspection to visualize live state
- Push reviewed DDL with dry-run preview
- Background drift polling with grouped diff per table
Document & Share
Data Contracts
Author, publish, and validate contracts
Define owners, SLAs, and column-level rules in the same editor. Export ODCS, dbt, Soda, and Great Expectations artifacts.
- Publish contract pages with live CI validation health
- Authenticated contract registry for lifecycle management
Built for your team
One workflow, every warehouse role
SchemaStruct fits into the tools and processes your team already uses.
Analytics Engineers
The pain
Schema changes live in Slack threads and undocumented SQL. By the time a mart ships, nobody remembers why the grain was chosen.
The solution
Design Bronze-to-Gold models visually, diff against warehouse state, and get team approval before any DDL runs.
The output
Reviewed star schemas, exportable SQL, dbt stubs, and living documentation that stays current.
Data Platform Teams
The pain
Upstream schema changes break downstream models. Drift goes unnoticed until stakeholders report wrong numbers.
The solution
Pull live warehouse metadata, detect drift automatically, and enforce contracts with CI-ready validation artifacts.
The output
Pre-flight dry-run reviews, published data contracts with health status, and automated PR diffs on schema changes.
Analytics Leads & BI Owners
The pain
Dashboard metrics built from undocumented joins. Nobody can trace whether a KPI uses the right grain or source table.
The solution
Trace data lineage from source to Gold layer. Launch dashboard-ready KPI starters from the same reviewed dimensional model.
The output
Schema-aware dashboards, column-level lineage, and exportable bundles for Power BI, Tableau, and Streamlit.
Why SchemaStruct
Not another ERD tool
SchemaStruct covers the gap between warehouse design and deployment — a layer that ERD tools, catalogs, and dbt docs each only partially address.
The gapSchemaStruct
ERD toolsdbdiagram, Lucidchart, draw.io
Model schemas visually but cannot diff against warehouse state, sync DDL, or produce deployment-ready artifacts.
Visual design plus warehouse sync, diff, review approval, and SQL/dbt export from one workspace.
dbt docs & Clouddbt docs, dbt Cloud
Document what was built, not what is planned. No visual design surface or pre-deployment review layer.
Design models before they become dbt code. Import and export dbt YAML. Review changes visually before shipping.
Data catalogsAtlan, DataHub, Alation
Catalog existing assets after deployment. Not built for pre-production schema design or change review.
Pre-production design and review layer. Publish living docs and contracts from the reviewed model.
Whiteboards & docsMiro, Notion, Confluence
Capture intent but lose the connection to actual warehouse objects. No diff, no sync, no artifact generation.
Models stay connected to warehouse state. Changes are diffable, reviewable, and exportable.
Security and governance
Enterprise-ready by design
Built for teams that care about controlled access, auditable changes, and safe warehouse interaction.
Read-only introspection by default
Warehouse connections start in read-only mode. SchemaStruct introspects metadata for design — it does not modify production objects unless you explicitly initiate a sync.
Dry-run before any DDL
Every warehouse sync shows a pre-flight SQL preview. Review the exact statements before any object is created or altered. Nothing executes without explicit confirmation.
Git-native workflow
GitHub sync, CI-ready CLI with lint, diff, and validate commands, and automated PR comments on schema changes. Fits the code review process your team already follows.
Shared workspace controls
Team workspace management, shared review links, and centralized billing. SSO and granular admin controls are on the Enterprise roadmap.
Security and procurement contact
Need to review data handling, compliance posture, or team rollout details? We support security questionnaires and procurement workflows. Talk to us.
Pricing
Start free. Upgrade when the team needs more.
The visual editor, local diff, and SQL export are always free. Upgrade for AI, live warehouse sync, and team collaboration.
Free
₹0/month
Everything you need to model and export schemas locally — no card required.
Get started free- Up to 5 saved diagrams
- Visual canvas + DSL editor
- Schema diff and SQL export
- Star schema and medallion templates
- Data Lab (CSV, JSON, Parquet profiling)
Most popular
Pro
₹599/month
AI copilot, warehouse sync, and full dbt workflow for individual data engineers.
Start Pro- Everything in Free
- Unlimited saved diagrams
- AI schema generation + copilot
- Snowflake and Databricks introspection
- dbt import, export, and GitHub sync
Team
₹3,499/month
Shared workspace sync, team workspace management, and centralized billing for the whole data team.
View Team plan- Everything in Pro
- Shared workspace sync
- Team workspace management
- Centralized team billing
- SSO & admin controls (Enterprise roadmap)
Prices in INR. See full feature comparison →
Need SSO, security review, or custom onboarding? Talk to sales →
Stop shipping blind
Every unreviewed schema change is a downstream break waiting to happen
Catch drift before dashboards go wrong. Review changes before they reach production. Ship with confidence.