Schema Studio: DB & DDL

Design tables, relationships, and indexes visually. Generate dialect-aware DDL plus Excel, PDF, Markdown, and HTML documentation—all on device.

Database design without the ceremony.

Schema Studio turns tables, columns, relationships, indexes, DDL, and design documents into one visual workflow built for iPhone and iPad. Start with a blank design and add only the objects you need.

DESIGN VISUALLY • Create, edit, delete, and reorder tables and columns • Set logical data types, nullability, defaults, primary keys, uniqueness, and automatic numbering • See an inline explanation when a rule depends on the selected value type • Build single-column and composite indexes, including per-column sort direction • Connect tables and inspect the result as an interactive ER diagram

GENERATE FOR MAJOR DATABASES Choose PostgreSQL, MySQL, MariaDB, SQLite, Oracle Database, Microsoft SQL Server, or IBM Db2. Schema Studio maps identifiers, data types, identity syntax, constraints, and supported index options for the selected target.

PREVIEW BEFORE EXPORT Review generated DDL in a syntax-highlighted SQL preview. Validation messages identify unsupported or incomplete design choices before a file is created.

CREATE DOCUMENTATION Export the same design as Excel, PDF, Markdown, and HTML, together with a target-specific .sql file. After generation, choose Save to Files to select a folder or share a copy with another app. Documentation includes tables, columns, indexes, and relationship definitions.

WORK ACROSS LANGUAGES Switch the app interface among 15 languages, including English, Japanese, Simplified Chinese, Traditional Chinese, Korean, Spanish, French, German, Portuguese (Brazil), Italian, Arabic, Hindi, Indonesian, Thai, and Vietnamese. The documentation language can be selected independently.

PRIVATE BY DEFAULT No account, ads, analytics, tracking, or cloud service is required. Your schema stays in the app's local container unless you explicitly save or share generated files.

Schema Studio generates design artifacts and DDL; it does not connect to database servers or execute SQL. Review and test generated SQL against your target database before production use. The ER canvas itself is not exported as a standalone image in version 1.0.