# MagicSQL - SQL Client & Editor — MySQL, Postgres, MariaDB & SSH

> Mobile SQL client and editor for MySQL, PostgreSQL, MS SQL, MariaDB, and SQLite. (iPhone/iPad app by Fatih Yesilbas.)

- Source: https://appshunter.io/ios/app/magicsql-sql-client-and-editor/id6781453187 (this page in markdown: same URL + `.md`)
- Developer: [Fatih Yesilbas](https://appshunter.io/developer/6779399524)
- Category: Developer Tools, Utilities
- Price: Free
- Rating: 5.00/5 from 1 App Store ratings · 1 written reviews indexed
- Age rating: 4+
- Requires: iOS 26.5 · 32 MB
- Languages: American English, German (Germany)
- Released: 2026-06-25
- Data updated: 2026-09-11
- Monetization: free
- User reviews in markdown: https://appshunter.io/ios/app/magicsql-sql-client-and-editor/id6781453187/reviews.md

## What is MagicSQL?

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.

## Key features

- Manage five database types in one interface
- Secure SSH tunneling with key or password
- Multi-tab data browser with split view
- Professional SQL editor with syntax highlighting and autocomplete
- Visual table designer
- User management and privilege assignment
- Auto-reconnect for uninterrupted sessions

## Recent user reviews (1 of 1)

All indexed reviews: https://appshunter.io/ios/app/magicsql-sql-client-and-editor/id6781453187/reviews.md

### 5/5 — Top SQL App!

*2026-06-26*

Super App zum Arbeiten mit sql Datenbanken. Tabellen lassen sich übersichtlich anzeigen und bearbeiten, Abfragen sind schnell erstellt. Super!

## Frequently asked questions about MagicSQL

### What databases can I manage with MagicSQL?

MagicSQL supports MySQL, MariaDB, PostgreSQL, MS SQL Server, and SQLite, all within a single, unified interface.

### How does MagicSQL ensure secure connections?

It offers secure connections through SSH tunneling, supporting both password and private key authentication, along with SSL/TLS encryption. Live status indicators and detailed connection diagnostics help troubleshoot issues.

### Can I edit data directly in MagicSQL?

Yes, MagicSQL allows for inline cell editing with a double-tap. You can also duplicate, delete, or export rows as JSON, and filter, search, and paginate through data.

### Does MagicSQL have a SQL editor?

Yes, MagicSQL features a professional SQL editor with syntax highlighting, context-aware autocomplete for tables and columns, live error detection, and a snippet toolbar for common statements. Query history is also available.

### Is MagicSQL suitable for creating new database structures?

Absolutely. MagicSQL includes a visual table designer that allows you to create tables with professional properties without writing SQL. It also supports creating views, functions, and triggers.

### What happens if my connection drops while using MagicSQL?

MagicSQL features auto-reconnect functionality. It keeps connections alive with keep-alive pings and automatically reconnects when needed, ensuring no data loss and no need to re-enter credentials.

### Does MagicSQL have ads?

No, MagicSQL is ad-free. The developer explicitly states 'no ads, no tracking — just tools that work' and emphasizes privacy, with server credentials staying exclusively on your device.

### What is the age rating for MagicSQL?

MagicSQL has an age rating of 4+, indicating it is suitable for a wide audience and does not contain mature content.

## Version history (last 1 release)

### 1.0 — 2026-06-25

No release notes.

## More apps by Fatih Yesilbas

- [MagicFTP: SFTP & FTP Client](https://appshunter.io/ios/app/magicftp-sftp-and-ftp-client/id6779399522)
- [MagicSSH – Server & Terminal](https://appshunter.io/ios/app/magicssh-server-and-terminal/id6783224129)

All apps by Fatih Yesilbas: https://appshunter.io/developer/6779399524

## Related topics

[sql server elite](https://appshunter.io/ios/topics/sql-server-elite) · [isqlprog sql server client](https://appshunter.io/ios/topics/isqlprog-sql-server-client) · [miladb mysql client](https://appshunter.io/ios/topics/miladb-mysql-client) · [mobile database client](https://appshunter.io/ios/topics/mobile-database-client) · [sql editor pro](https://appshunter.io/ios/topics/sql-editor-pro) · [sql server mobile client](https://appshunter.io/ios/topics/sql-server-mobile-client) · [sql server mobile client pro](https://appshunter.io/ios/topics/sql-server-mobile-client-pro) · [mysql mobile client](https://appshunter.io/ios/topics/mysql-mobile-client)

---

*Data collected daily from the US App Store and indexed by [AppsHunter](https://appshunter.io/). User reviews are verbatim App Store reviews. Ratings, prices and chart positions refresh continuously; this snapshot is from 2026-09-11.*