SQLite Editor & DB Viewer vs Schema Studio

SQLite Editor & DB Viewer opens, browses, and edits SQLite and .db database files right on your iPhone and iPad — no computer, no setup, no account. Whether you're a developer inspecting an app's database, a student learning SQL, or an analyst exploring data on the go, everything runs locally and offline. OPEN & BROWSE ANY DATABASE • Open .db, .sqlite, and .sqlite3 files from Files, iCloud, or share sheet • Browse every table, view rows and columns, and inspect the full schema • Fast search across tables and values • Works completely offline — your data never leaves your device RUN SQL — OR SKIP IT • Full SQL editor with syntax highlighting to run any query • Visual Query Builder: tap tables, columns, and filters and the app writes the SQL for you — no syntax to memorize • Edit rows inline, add and delete records, and commit changes safely IMPORT & EXPORT • Import spreadsheets — CSV, JSON, and Excel — straight into a table • Export tables and query results to CSV • Save databases back to your device LEARN SQL AS YOU GO • 26 interactive SQL lessons — from SELECT and WHERE to JOINs and subqueries • A practice sandbox with a ready-made sample database — try queries with zero risk • Perfect for beginners moving from "no SQL" to confident queries BUILT FOR iPHONE & iPAD • Designed for both — a full workspace on the big iPad screen • Clean dark interface, easy on the eyes PRO (optional) • Remove ads and unlock the full set of power features • Available as a monthly subscription or a one-time lifetime unlock • A free trial of each Pro feature is included — no commitment Terms of Use (EULA): https://www.apple.com/legal/internet-services/itunes/dev/stdeula/

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.