MagicSQL - SQL Client & Editor

The first true mobile SQL IDE. SSH tunneling, multi-tab data browser, pro editor with autocomplete. Five databases — for developers on the go.

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.