Schema Studio: Database Design

Build tables, see their relationships, and export DDL and documentation. Schema Studio brings database design to iPhone and iPad. • Copy an existing table as the starting point for a new one. Fields, constraints, and indexes carry over; edit the name before saving. • Sort your table list by creation order, table name, or display name, with ascending and descending options. • Set data types, required fields, primary keys, uniqueness, and automatic numbering. • Design composite indexes with per-column sort directions. • Create relationships and inspect an interactive ER diagram. • Review generated SQL in a syntax-highlighted preview. • Save or share SQL plus Excel, PDF, Markdown, and HTML documentation. Generate for PostgreSQL, MySQL, MariaDB, SQLite, Oracle Database, Microsoft SQL Server, and IBM Db2. Choose the interface and documentation languages independently from 15 supported languages. No account, ads, tracking, or cloud service is required. Designs stay on your device unless you explicitly save or share exported files. Table copies do not include relationships. Schema Studio is a design and DDL generation tool; it does not connect to database servers or execute SQL.