MagicSQL vs SQLite Editor & DB Viewer

Manage your databases on the go — like a pro. MagicSQL is the first mobile SQL client that brings together MySQL, PostgreSQL, MS SQL Server, MariaDB and SQLite with SSH tunneling, a full-featured editor and a multi-tab interface. Not a stripped-down viewer — a real professional tool for your phone and tablet. ▸ FIVE DATABASES, ONE INTERFACE MySQL · MariaDB · PostgreSQL · MS SQL Server · SQLite Switch between servers without leaving the app. ▸ CONNECT SECURELY - SSH tunneling with password OR private key - SSL/TLS encryption - Live status: green dot + ping time in ms show instantly which servers are reachable - Connection test with clear diagnostics: SSH, DB, or network errors are reported separately ▸ MULTI-TAB DATA BROWSER - Open multiple tables simultaneously in tabs — like on the desktop - Split View: compare two tables side by side - Inline cell editing with double-tap - Column filters, full-text search, pagination - Duplicate, delete, or export rows as JSON - Column sorting and adjustable column widths ▸ PRO SQL EDITOR - Syntax highlighting for keywords, strings, numbers, comments - Context-aware autocomplete (knows your tables and columns) - Live error detection with wavy-underline markers - Snippet toolbar for common statements - Query history with copy & re-run ▸ TABLE DESIGNER WITHOUT SQL Create tables visually with every professional property included: - Primary key, Auto-Increment, Unique - UNSIGNED for numeric types (MySQL) - ON UPDATE CURRENT_TIMESTAMP for updated_at columns - Default value with quick picks: NULL, NOW(), 0, '', UUID() - Comment, charset, collation, engine ▸ VIEWS, FUNCTIONS AND TRIGGERS Beginner-friendly builders with templates, or full SQL code control. Create views, stored functions and triggers without spending hours in the docs. ▸ USER MANAGEMENT Create MySQL users and assign privileges through three clear tabs: Account, Privileges, Password. ▸ AUTO-RECONNECT App went to background? No problem. MagicSQL keeps the connection alive with keep-alive pings and reconnects automatically when needed — no data loss, no need to re-enter anything. ▸ DARK THEME, CODING FONT Eye-friendly design with a professional monospaced font built for code. No distracting animations, no ads, no tracking — just tools that work. ▸ WHAT MAKES MAGICSQL DIFFERENT? Other mobile SQL apps often just display data. MagicSQL is a real mobile IDE: SSH tunneling for secure remote connections, multiple tables in tabs at once, an editor with live assistance, a visual designer — and all of it for five database systems. Optimized for fast thumb input, uncompromising on professional features. ▸ PRIVACY Your server credentials stay exclusively on your device. No cloud, no tracking, no ads. MagicSQL talks directly to your servers — nothing goes through third parties. ▸ SETTINGS Adapt to your workflow: connection timeout, keep-alive, auto-reconnect, default row limit, text size, NULL highlighting, syntax highlighting, query history, destructive-action confirmation — everything is respected. For developers, DBAs, DevOps and anyone who wants their databases under control everywhere. Download MagicSQL and work like a pro — from your couch, on the train, or in the server room.

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/