mcdview blog
EN FR

Keep an ER diagram of your database, updated on every push

Paste a schema, get a link, then let CI keep the diagram current on every push.

Manage your diagrams: rename, update, connect your Git, delete

Control a diagram from one page, and find them all by connecting GitLab or GitHub.

Read your schema's history: the timeline and diffs

Every update is a version. Scrub the timeline and diff any two.

Why an mcdview diagram is a single HTML file with no runtime

One static file: no server, no database connection, no framework at view time.

Explore real database schemas as interactive ER diagrams

A gallery of well-known sample schemas you can click through.

Open-source schemas in the wild, as live ER diagrams

Ten well-known projects (Mastodon, GitLab, Discourse, Cal.com…), their schemas rebuilt from git history with time-lapses and diffs.

Guess the app from its database schema

Five real open-source schemas, every name replaced by T01, c1… Only the shape is left.

How long does a database table live?

1,112 tables followed through the git history of nine open-source apps: most are forever, and the ones that die, die young.

We linted 6,008 real database schemas. 45% of foreign keys have no index.

A study of 6,006 public repositories: missing indexes, missing foreign keys, and why design tools score worst.

Fifteen years of the LinuxFr.org schema, in time-lapse

Tables with no relations until 2018, then 29 foreign keys in one commit, and the move to OAuth2 readable in a diff.

Crow's-foot cardinality, deduced from your SQL alone

Child many, parent one, an open ring for nullable foreign keys, N-N for junction tables. Zero configuration.

From a Mermaid erDiagram to an interactive diagram

Paste a .mmd, get a layout you own, and export back to Mermaid.

How to read a 100-table schema without getting lost

Hubs first, then cycles, isolate one table at a time, search, hide audit foreign keys.

Visualize a Rails schema.rb as an ER diagram

Paste your Rails db/schema.rb into mcdview and get an interactive ER diagram on a stable link, read natively, no account, no Ruby to run.

Turn a Prisma schema into an ER diagram

Point mcdview at your schema.prisma and get an interactive ER diagram: models become tables, relations become edges. No account.

Make an ER diagram from a PostgreSQL dump

A schema-only PostgreSQL dump, pasted into mcdview, becomes an interactive ER diagram. No database connection, no account.

A dbdiagram alternative with no account

A dbdiagram-style ER diagram without signing up: paste an existing schema, get a link in seconds, keep it current in CI.

Open a pgModeler .dbm without pgModeler

Drop a pgModeler .dbm file into mcdview and read its ER diagram in the browser: no pgModeler to install, no account.

Visualize a Drizzle schema as an ER diagram

Point mcdview at your Drizzle schema and get an interactive ER diagram: tables and their references, read in the browser, no account.

Make an ER diagram from a MySQL dump

A schema-only MySQL dump, pasted into mcdview, becomes an interactive ER diagram. No live database is contacted, no account.