SCHEMA STUDIO FOR IOS

Design the schema.
Get the right DDL.

A visual database designer for iPhone and iPad. Build tables, columns, relationships, and indexes, then generate product-aware DDL and design documents.

テーブル、項目、リレーション、インデックスを見たまま設計。製品差を考慮したDDLと設計書をまとめて書き出せます。

7 database dialects 5 export outputs 15 interface languages Local-first

Schema Studio DDL export screen with Microsoft SQL Server selected and syntax-highlighted SQL

ONE DESIGN, SEVEN DIALECTS

Product differences stay out of your way.

Schema Studio maps logical types, identity syntax, identifier quoting, constraints, and supported index options for each target. Generated SQL remains a starting point: validate it against your target engine before production use.

PostgreSQL MySQL MariaDB SQLite Oracle Database Microsoft SQL Server IBM Db2

Visual table design

Start from a blank design, then add, edit, reorder, and validate tables and columns without hand-editing a specification.

Index design

Create composite and unique indexes, order key columns, and configure supported INCLUDE or WHERE options.

ER diagram

See relationships, zoom the canvas, drag tables, and use automatic arrangement.

Highlighted DDL

Review generated SQL with syntax highlighting while retaining selectable, copyable plain SQL.

Files with a clear destination

Generate SQL plus Excel, PDF, Markdown, and HTML, then choose Save to Files or share a copy with another app.

Guidance before export

See why a rule is unavailable, what automatic numbering changes, and which incomplete or unsupported choices need attention.

BUILT FOR A SMALL SCREEN

Dense enough to work. Clear enough to learn.

Table management screen with separate edit and delete controls — Tables and indexes at a glance

Field editor explaining that Whole number must be selected before automatic numbering is available — Unavailable choices explain why

ER diagram showing a relationship callout directly above the selected connector — Relationships on the line

Language settings screen showing 15 supported languages — Language settings

GLOBAL BY SETTING

Choose the app language inside the app.

The interface language and document language can be selected independently. System language remains available for the interface.

LOCAL-FIRST

Your schema stays on your device.

No account, ads, analytics, or tracking SDKs. Schema data and language settings are stored locally. Generated files remain temporary until you explicitly save them to Files or share a copy with another app.

Read support Read the privacy policy

Design the schema.Get the right DDL.