SQLite Schema Visualizer

1. Open your SQLite client (the sqlite3 CLI, DB Browser for SQLite, or DBeaver), open the database file you want to visualize, and run this query:

SELECT sql || ';' AS ddl
FROM sqlite_master
WHERE type IN ('table', 'index')
  AND sql IS NOT NULL AND name NOT LIKE 'sqlite_%';

2. Copy the result (all rows), paste it below, and click Visualize Schema.

Go to the "Query your DB" tab for a query that extracts your DDL.