For SQL Server schemas too big to read at once

Big schemas, one hop at a time.

Pick one table in your SQL Server database, watch the diagram grow outward from it, make the changes you need, and get a migration script ready to run.

No credit card to start. Sign in with your email — no password to choose.

1 HOP 2 HOPS ProductCategory Vendor SalesOrderDetail Location ScrapReason ProductSubcategory ProductModel ProductVendor SpecialOfferProduct ProductInventory WorkOrder Production.Product 18 FOREIGN KEYS
AdventureWorks · Production.Product, two hops out
Why it exists

Four hundred tables drawn at once is a wall, not a diagram.

Most tools draw every table they find. WoodFireERD starts from the one you care about and shows only what connects to it, one hop at a time, as far out as you choose to look.

Then you make the change right there, and take the migration script with you.

What it does

From "what is this table?" to a script you can run.

A diagram you can navigate

Pick the table you care about and the picture grows outward from it, as far as you want to look.

Relationships you can read

One, many, and optional all look different, because the difference is the thing you came to find out. Hover any line to see exactly how two tables join.

Edit by dragging

Add columns, keys, indexes and triggers. Drag from one column to another to create a relationship. Everything you change is collected as you go.

Migration scripts that just run

Correctly ordered and ready to run whenever it suits you. No hand-sorting statements, no guessing what has to happen first.

Nothing lost by surprise

Before you run anything, you are told plainly what a change would destroy — and deleting a table shows everything that would go with it.

Safe while others change the database

Refresh to pick up changes colleagues have already made. Your own edits are kept, and their work never turns up as a drop in your migration.

How it works

Four steps, in the order you'd take them.

  1. 01

    Connect

    Point it at your database, or open a project you saved earlier.

  2. 02

    Explore

    Follow the relationships that matter and ignore the rest.

  3. 03

    Edit

    Change what you need, and see it on the diagram as you go.

  4. 04

    Export

    Take the script and run it when it suits you.

Where it runs

In your browser, or on Windows behind your firewall.

In the browser

Nothing to install

Read a live database the internet can reach — Azure SQL is the usual case — or open a DACPAC or a project you saved.

On Windows

For schemas that never leave the network

The same designer as a desktop application, for databases behind a company firewall or schemas you would rather not send through anyone's server.

Start at the table you know.

Start free on a small schema, and upgrade when you need bigger ones and migration scripts.

By creating an account you agree to our Terms and Privacy Policy.

An unhandled error has occurred. Reload 🗙