SQLite Schema Designer

Design new tables and relationships. Generate SQLite SQL, review it, and download a script to open in the workspace. Nothing runs automatically.

SQL for review

Opening the downloaded .sql file stages it in the workspace. Create an empty database and press Run to apply it. Existing tables are not altered or replaced.

Relationships

Supports composite primary and foreign keys, SQL literal defaults, and unique or ordinary indexes. Use the workspace Schema tab to migrate existing tables. Up to 30 tables and 50 columns per table.

View an ER diagram from an existing database · Learn foreign keys