← All Apple listings

MagicSQL - SQL Client & Editor

by Fatih Yesilbas more by this developer →

#573,665 of 726,788 by ratings on Apple · #1,210 of 1,699 in Developer Tools

View in the Apple store ↗

Compare with another extension

Category: Developer Tools

Description

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.

Alternatives to MagicSQL - SQL Client & Editor

Name	Ratings	Rating
MySQL Mobile Client by Filippo Maguolo	204	4.5	compare
SQLite Mobile Client by Filippo Maguolo	196	4.4	compare
PostgreSQL Client by Filippo Maguolo	153	4.6	compare
MySQL Client by SQLPro by Hankinsoft Development Inc	96	3.9	compare
SQLPro Studio database client by Hankinsoft Development Inc	63	4.3	compare
SQL Server Mobile Client by Filippo Maguolo	56	4.2	compare
SQL Database Manager DB Client by Cloudbit d.o.o.	12	4.3	compare
SQLite database client by Hankinsoft Development Inc	2	3.0	compare
Index - SQL Client by Patrizio Pezzilli	—	—	compare
Caliope — SQL Client by David Villalobos Cambronero	—	—	compare

Growth

Change in ratings, scaled to each window from the real gap between crawls. A window needs a full period of history before it reports anything.

History

Tracking since 09/05/2026. History accumulates as changes are observed — check back soon.