Schema — Database Designer & SQL Builder

Schema — Database Designer & SQL Builder — a premium, 100% offline digital tool by Aceplore. Runs entirely in your browser: no accounts, no subscriptions, your data never leaves your device.

A private, offline database designer — tables, columns, keys, relations and indexes with an ER diagram, a scored schema audit, and dialect-correct DDL for Postgres, MySQL and SQLite.

30 built-in tools in one app. A dashboard of schema size and warnings; multiple schemas with a dialect setting; tables, columns and per-table detail; a type reference per dialect; primary keys with missing-key warnings; foreign keys and a schematic ER diagram; cardinality overviews and a many-to-many junction builder; indexes with suggestions for unindexed foreign keys; constraints, enums and defaults; a naming-convention linter and normalisation hints; CREATE TABLE DDL for the whole schema or one table; ALTER generation and a migration log with up and down SQL; INSERT seed generation; a visual SELECT builder with joins; a scored audit covering missing keys, unindexed foreign keys, nullable foreign keys, orphan tables and naming violations; a printable data dictionary and schema comparison.

The SQL is real. Correct types per dialect and safely quoted identifiers — a column named order won't break your output.

What's included:

• Schema.html
• Quick-Start-Guide.html
• How-To-Use-Guide.html
• README.txt
• LICENSE.txt

Includes a personalized welcome wizard, an interactive guided tour, a ⌘K command palette, light/dark themes with 8 accents, and one-click JSON backup & restore.

A design tool that runs entirely in your browser — it never connects to a database. Review all generated SQL against your own environment before running it.