Everything you need to know about SQLManager Pro — concise and clear.
SQLManager Pro is a professional macOS application for managing and editing databases — local SQLite files as well as MySQL and MariaDB servers. With smart import for CSV, JSON and XML, a powerful SQL editor and extensive export functions, it's the ideal tool for developers, data analysts and anyone working with databases.
SQLManager Pro is built for developers managing and inspecting app and web databases, data analysts who want to import and analyse CSV/JSON data quickly, mobile developers (iOS/Android) inspecting app databases, database administrators who manage MySQL or SQLite databases professionally, and students learning SQL and database design.
Your databases stay exactly where you keep them. For a file that is your Mac, for a server connection it is your own server — SQLManager Pro works with them directly. There is no cloud synchronisation, no intermediate storage on our side and no transfer to third parties. Passwords for server connections are kept solely in your Mac's keychain.
You can open databases in several ways: via "File → Open" in the menu, by double-clicking on .db, .sqlite or .sqlite3 files (when SQLManager Pro is set as the default app), or by creating a new empty database via "File → New". For a server, choose "Connect to MySQL Server".
SQLManager Pro always uses the latest stable SQLite version. Databases created with older SQLite versions are fully compatible and can be opened without issues.
MySQL from version 5.7 and MariaDB from version 10. Older releases speak a different protocol and are rejected with a clear message when connecting, instead of behaving unpredictably.
Via "Connect to MySQL Server" — in the welcome window, in the File menu or in the menu behind the database symbol. You enter host, port, database and credentials, and you can test the connection before opening it. It then appears in the list of recently opened databases and is one click away.
If you want it to be, yes. You have three options: unencrypted, encrypted without certificate check, or encrypted with a check. The middle one suits your own server on the home network whose certificate you issued yourself; the strictest one suits a server on the internet where you want to be sure who you are talking to.
Solely in your Mac's keychain — never in the app settings and never in a file in plain text. The connection list holds nothing but a reference to it.
Yes, in both directions. Export a table from an SQLite file and load it onto a MySQL server — or the other way round. When exporting you choose which dialect is written, so the resulting file also runs at its destination.
One connection opens one database. To open a second one on the same server, duplicate the connection in the settings and change only the database name — the remaining credentials stay as they are.
SQLManager Pro supports the most common data formats: CSV with flexible separator options (comma, semicolon, tab), JSON with arrays and nested objects, and XML with arbitrary structure. The smart import wizard analyses your data automatically and detects column types.
You choose your CSV/JSON/XML file, SQLManager Pro analyses the data structure automatically and detects column types intelligently. You get a proposal for the optimal table structure, can adjust column types as needed and import into a new or existing table — into a file just as well as onto a server. A progress indicator keeps you informed during large imports.
You can export your data in several formats: CSV for Excel, Numbers and other spreadsheet apps, JSON for modern web applications and APIs, XML for structured data exchange, and SQL for database dumps and backups including schema. Choose between data-only export or a full schema export with structure.
Yes. You can export individual tables selectively. Pick the table you want and use the export function — only the selected table will be exported.
Yes. The SQL editor supports multi-query execution. Write several SELECT, INSERT, UPDATE or DELETE statements in the editor and run them all at once. Each result is shown in a separate tab.
The SQL editor offers all the essentials for productive work: line numbers for easy navigation, multi-query execution with tab-based results, detailed error messages for failing queries, and a clear presentation of query results.
Yes. SQLManager Pro has full BLOB support: images (PNG, JPG etc.) are displayed directly in the data view, BLOB data can be exported as files, and you can import files as BLOB data into your database. Perfect for apps that store images or documents in the database.
Yes, your data is safe: there is no cloud connection to us, no telemetry and no tracking. SQLManager Pro works directly with your files, or with the server you specify yourself — without copies or temporary data. Server connections can be encrypted, and passwords are kept in the keychain.
No, never. SQLManager Pro does not collect, store or transmit any usage data. The app connects only to the servers you enter yourself and respects your privacy 100%.
SQLManager Pro runs on macOS 14.6 (Sonoma) or later. The app is optimised for both Apple Silicon (M1/M2/M3/M4) and Intel Macs.
Yes. SQLManager Pro is compiled as a Universal Binary and runs natively on both Apple Silicon and Intel processors. You get maximum performance on every Mac model.
Currently SQLManager Pro is only available for macOS. An iOS/iPadOS version is planned for the future.
SQLManager Pro can open databases of any size. Performance depends on your Mac, and with servers also on the connection and the complexity of your queries. Even databases of several gigabytes are supported without issues.
If you have questions or need help, you have two options: use the contact form for direct enquiries, or visit the support forum to talk to other users and find answers.
SQLManager Pro is fully available in seven languages: German, English, French, Spanish, Italian, Danish and Chinese (Simplified). The interface adapts automatically to your system language.
Yes. All updates for SQLManager Pro are free and delivered via the Mac App Store. You are notified automatically when a new version is available. You can find an overview of all changes on the release notes page.
Get in touch via the contact form or visit the support forum.