GraphMyDB

Interactive database schema diagrams

Your ER diagram will appear here

Why use GraphMyDB?

GraphMyDB helps teams understand complex database structures fast. Upload a MySQL, PostgreSQL, or SQLite dump, CSV datasets, JSON schemas, or Excel spreadsheets — and get an interactive ER diagram in seconds. Compare schema versions, preview migrations, collaborate live in the code editor and ER diagram, and click any table or column to focus on its relationships.

Local-first and stateless by default: your files are parsed in the browser and are not uploaded for project storage. When you start co-op, peers join with an invite code and authenticate with a room secret before syncing.

Private by Default

Analyze schemas directly in your browser with no account, no project storage, and no locked workflow around a backend service.

Live Co-op Reviews

Start a room after loading a database and share an invite code. Up to four people can review the live code tab and ER diagram together.

VS Code Extension

Right-click any .sql, .json, .csv, or .xlsx file in VS Code and instantly visualize its schema. The extension now supports the same invite-code co-op flow, so browser and VS Code sessions can review the same live schema together.

Install from Marketplace

How to compare DB migrations easily

Use the Compare tab for full snapshot-to-snapshot checks and the Migration tab for base-plus-migration analysis. The changelog explains changes in plain language so non-technical stakeholders can follow.

1. Upload before schema

Drop the old SQL dump or paste DDL to create your baseline.

2. Upload after schema

Add the new version to compute table, column, FK, and index differences.

3. Read visual + text diff

Inspect highlights in the diagram and confirm details in plain-English changelog.

Supported formats

Upload SQL, CSV, JSON, or Excel files. All parsing happens in your browser — your data never leaves your machine.

.sql

SQL

  • Full support for MySQL, PostgreSQL, and SQLite dialects.
  • Handles CREATE TABLE, ALTER TABLE, FOREIGN KEY, INDEX, and all common DDL.
  • Migration SQL with ALTER COLUMN, MODIFY, CHANGE, ADD/DROP supported across dialects.
.csv

CSV / TSV

  • Upload files of any size — large files are auto-sampled for fast inference.
  • Column types inferred automatically (INTEGER, FLOAT, BOOLEAN, DATE, TEXT).
  • Multi-file relationship detection based on naming patterns.
.json

JSON

  • Tables array format ({ tables: [...] }).
  • JSON Schema-like structures with definitions and properties.
  • Full round-trip: import, edit, and export back to JSON.
.xlsx

Excel

  • Import .xlsx and .xls spreadsheets.
  • Each sheet becomes a table with column headers.
  • Export back to Excel with one sheet per table.

Features

SQL to interactive ER diagrams
MySQL, PostgreSQL & SQLite support
CSV/TSV analysis — any file size
Excel (.xlsx/.xls) import & export
JSON schema visualization
Click table to focus its relationships
Click column to highlight its edge
Compare old vs new schema versions
Migration impact preview
Human-readable schema changelog
Visual editing — add tables, columns, links
9 relationship types with distinct styles
Invite-code co-op for code + ER diagrams
Grid, left-right & top-bottom layouts
Export diagram as PNG or SVG
Live code editor with instant refresh
100% private — no server, no sign-up
Fullscreen diagram mode

Frequently Asked Questions

What is GraphMyDB?

GraphMyDB is a free, browser-based tool that lets you visualize SQL schemas as interactive ER diagrams, compare database versions, and preview migration impact — all without uploading data to any server.

Which SQL dialects does GraphMyDB support?

GraphMyDB supports MySQL, PostgreSQL, and SQLite — including CREATE TABLE, ALTER TABLE, FOREIGN KEY, INDEX, and all common DDL statements. Code generation is also dialect-aware.

What file formats can I upload?

You can upload SQL files (.sql), CSV/TSV files of any size, JSON schema files (.json), and Excel spreadsheets (.xlsx, .xls). All parsing happens entirely in your browser.

Is my data private when using GraphMyDB?

Yes. By default GraphMyDB parses files locally in your browser and does not upload your schemas for storage. Optional accounts only cover hosted limits and billing metadata. If you explicitly start co-op, the app uses invite-code collaboration with authenticated peer connections so collaborators can sync the live session without durable project storage.

Can I collaborate live with other people?

Yes. Start co-op after loading a database, copy the invite code, and your collaborators can join the same live code and ER diagram session from the browser or the VS Code extension. Hosting may require signing in if hosted limits apply.

Can I compare two database schemas?

Yes. Use the Compare tab to upload old and new SQL dumps (any dialect) for full snapshot-to-snapshot diff, or the Migration tab for base-plus-migration analysis. Changes are shown visually and as a plain-English changelog.

Can I upload large CSV files?

Yes. Files of any size are supported. Large CSVs (100 MB+) are automatically sampled — the first ~2,000 rows are read for fast schema inference. Your browser won't freeze.

How do I trace a specific column relationship?

Click any table node to focus on its relationships (unrelated items dim). Then click a specific column to highlight the exact edge connected to it in amber. Click the canvas to reset.

What export formats are available?

You can export the diagram as PNG or SVG from the toolbar, and the schema as SQL DDL, CSV, JSON, or Excel (.xlsx) from the Export tab.