From .db file to ER diagram in seconds

SQLite ER Diagrams and Visual Schema Design

DbSchema opens a local SQLite file straight from disk — no server, no configuration — and turns it into an ER diagram you can edit, query, document, and keep in Git with the code that ships it.

  • Browse to any .db or .sqlite file and the schema appears as a diagram right away
  • The SQLite JDBC driver is bundled, so there is nothing extra to download
  • Edit tables, columns, and keys visually — changes are saved back to the file
  • Publish HTML documentation of the schema your application depends on
available for ISO-27001 certified ISO-27001 certified
Free Community Edition No signup required 15-day Architect trial included
Free Download
DbSchema showing a SQLite database file as an ER diagram with documentation
100+ Databases
|See All   >

Trusted by teams at

The Most Deployed Database on Earth
Deserves More Than a Command Line

SQLite ships inside Android, iOS, Firefox, and Python's standard library — the most widely deployed database engine there is. Yet the schema inside a .db file is usually inspected through a terminal, one table at a time.

DbSchema treats that file as a full database: open it, see every table and relationship on one diagram, edit visually, and document what you found — with no server between you and the schema.

Design, Query & Document
SQLite Files Like Any Server Database

The workflow DbSchema applies to server databases works unchanged on the file on your disk.

Reverse engineer a SQLite file into an ER diagram
See the Whole File as a Diagram

Open a .db or .sqlite file and DbSchema draws the tables, keys, and relationships inside — an instant map of a database another application created.

Edit a SQLite table structure visually in DbSchema
Edit Tables Without Writing DDL

Add columns with SQLite affinity types, set NOT NULL, UNIQUE, and CHECK constraints, and define composite primary keys in a structured editor — no CREATE TABLE or ALTER TABLE by hand.

Generate realistic test data for SQLite tables
Fill a Fresh File With Believable Data

Generate names, dates, numbers, and foreign-key-consistent values from per-column patterns — a populated test database for unit tests or performance runs, without exporting from a live system.

HTML5 documentation generated from a SQLite schema
Document the Schema Behind the App

Export interactive HTML5 documentation with zoomable diagrams and column comments — a reference for embedded and mobile teams that opens in any browser.

Write SQL against a SQLite file in the DbSchema editor
Query the File With Autocomplete

Write and run SQL against the open file with completion that knows your tables, then edit results inline and export them to CSV, Excel, or JSON.

Explore related SQLite records across tables
Follow Rows Through Their Keys

Walk related records across tables through real or virtual foreign keys — useful when the application declares its relationships only in code.

The design is a file too — version them together.

The .db File Holds the Data
The Model Holds the Design

DbSchema keeps your schema design in a model file separate from the database file, so the design can be reviewed, versioned, and shared without passing data around.

Design a SQLite schema offline
Design Before the File Exists

Sketch tables and keys first, then create the SQLite database from the finished model.

Keep the SQLite design model in Git
Version It With the App

Commit the model next to the code that reads the file and diff schema changes like source.

Preview generated SQLite DDL
Read the DDL First

Every visual change becomes SQL you can read before it touches the file.

Apply reviewed schema changes to SQLite
Apply Changes Deliberately

Bring any copy of the database up to date, one reviewed change at a time.

Pull Requests
for an Embedded Database

Because the design lives in a model file, a SQLite schema follows the workflow your code already has: branch, review, merge. After approval, DbSchema generates the SQL that brings the .db file up to date.

SQLite schema synchronization between the Git model and the database file
Read Git Workflow Docs

Documentation for the Database
Your Application Carries Around

One click renders the model as interactive HTML5 documentation — searchable diagrams, comments, hover details — readable in any browser. New teammates learn the schema from a page, not from the source code that writes it.

See the Documentation Tool

Interactive HTML5 documentation of a SQLite schema

Ask the AI Assistant

Describe the query you need in plain English, or paste one and ask what it does. The Assistant reads your design model, so the answers are about your tables rather than a textbook example.

See What the AI Assistant Can Do

DbSchema AI assistant answering questions about a SQLite schema

Open a SQLite File With Zero Setup

DbSchema bundles the Xerial SQLite JDBC driver, so opening a database requires no downloads: choose SQLite, browse to the file, done. The URL format is jdbc:sqlite:/path/to/file.db on macOS and Linux, jdbc:sqlite:C:/path/to/file.db on Windows, and jdbc:sqlite::memory: creates a throwaway in-memory database for prototyping.

DbSchema vs DB Browser for SQLite

DB Browser for SQLite remains a popular free companion for quick edits to a single file. DbSchema aims at a different job — understanding, designing, documenting, and versioning the schema — with the same workflow you use for server databases.

DbSchema DB Browser for SQLite
ER diagrams of the schema Yes — interactive, arrangeable, exportable —
Visual table editing and data browsing Yes Yes
Test data generator Yes (Pro) —
HTML schema documentation Yes (Pro) —
Works beyond SQLite 100+ databases with the same UI SQLite only
Price Free Community edition; paid Pro with 15-day trial Free, open source

Snapshot comparison; both projects evolve — check each tool's documentation for current features.

Your Next .db File Deserves a Diagram

Free Community Edition, no signup, and the installer includes a 15-day Architect trial.

Download Free

Tutorials and guides

Frequently asked questions

Yes. Point DbSchema at your .sqlite or .db file — no separate database server is required.

Yes. Reverse engineer the file into a visual model you can edit and document.

Yes, when you need ER diagrams, schema documentation, or test data generation. DB Browser is a lightweight file editor; DbSchema applies the same modeling workflow used for server databases to your SQLite files.

No. DbSchema bundles the SQLite JDBC driver, so opening a .db file requires no extra downloads.

Yes. DbSchema is a desktop application on all three platforms.

Teams working with SQLite often use these engines too. Explore dedicated guides and JDBC setup for each.

Browse all 100+ supported databases