SQLite Schema Visualizer - View Database Structure

Visualize SQLite database schema with tables, columns, types, and relationships. See foreign keys and indexes. Browser-based.

Load Database

Load a database to view its schema

Security: Only process files from sources you trust. All processing happens locally in your browser.

Tables, columns with data types, primary keys, foreign key relationships, indexes, and row counts for each table.

Yes. Foreign key relationships are shown with arrows indicating which columns reference other tables.

Yes. Click on any table to view its original CREATE TABLE statement from sqlite_master.

All indexes are listed with their columns and whether they're unique. Auto-generated indexes are marked.

No. The schema is extracted locally using SQL.js. Your database file never leaves your browser.

Yes. Export as SQL (CREATE statements), JSON (structured schema), or copy to clipboard.

Yes. Views and triggers are listed separately with their definitions.

Standard SQLite files: .sqlite, .db, .sqlite3, .db3

SQLite's type affinity is shown (INTEGER, TEXT, REAL, BLOB, NUMERIC) along with any declared type.

Yes. Use the search box to filter tables and columns by name.