Setup and Manage your macOS SQLite database easily!

SQLiteStudio for Mac

SQLiteStudio for Mac

  -  30.38 MB  -  Open Source
  • Latest Version

    SQLiteStudio 3.4.16 LATEST

  • Review by

    Daniel Leblanc

  • Operating System

    macOS 10.12 Sierra or later

  • User Rating

    Click to vote
  • Author / Product

    SalSoft Pawel Salawa / External Link

  • Filename

    SQLiteStudio-3.4.16-macos-x64-installer.dmg

  • MD5 Checksum

    4cc3c613e7d8882c70710a37ad08a16e

SQLiteStudio for Mac is an advanced SQLite database manager for macOS with an intuitive user interface, with no installation needed (single executable file to run).

SQLiteStudio for macOS has recently migrated to GitHub. This affects the source code repository, as well as the issue tracker (bugs & feature requests). This should improve collaboration with potential contributors and also make it more readable, as GitHub has a well-established platform for the same. All bug reports from the old tracker have been migrated to GitHub.

Features and Highlights
  • Portable - no need to install or uninstall. Just download, unpack and run.
  • Intuitive interface in SQLite Studio for macOS platform
  • Powerful, yet light and fast,
  • All SQLite3 and SQLite2 features wrapped within simple GUI,
  • Cross-platform - runs on Windows 9x/2k/XP/2003/Vista/7, Linux, MacOS X and should work on other Unixes (not tested yet).
  • Exporting to various formats (SQL statements, CSV, HTML, XML, PDF, JSON),
  • Importing data from various formats (CSV, custom text files [regular expressions]),
  • Numerous small additions, like formatting code, history of queries executed in editor windows, on-the-fly syntax checking, and more,
  • Unicode support,
  • Skinnable (interface can look native for Windows 9x/XP, KDE, GTK, macOS, or draw widgets to fit for other environments, WindowMaker, etc),
  • Configurable colors, fonts, and shortcuts.
  • Open source and free
Also Available: Download SQLiteStudio for Windows

  • SQLiteStudio 3.4.16 Screenshots

    The images below have been resized. Click on them to view the screenshots in full size.

    SQLiteStudio 3.4.16 Screenshot 1
  • SQLiteStudio 3.4.16 Screenshot 2
  • SQLiteStudio 3.4.16 Screenshot 3
  • SQLiteStudio 3.4.16 Screenshot 4

What's new in this version:

- Added: Added safe-mode command line option to bypass issues caused by corrupted session

Changed:
- Database Export dialog has now Export Indexes and Export Triggers options, just like the Single Table Export dialog
- SQLite updated to 3.49.0
- Config options for WxSQLite plugin extended to support AEGIS and Ascon-128 ciphers

Fixed:
- Fixed crash when opening a View's Trigger and enabled trigger-related entries in context menu for a View's Trigger
- Fixed result column name when using [] quoting operator for column alias name
- Fixed SQL formatter for INSERT statement when database prefix is used, so the dot is not removed after database name
- Fixed SQL formatter for GENERATED ALWAYS column in CREATE TABLE statement, so it doesn't quote type name
- Enterprise SQL formatter preview is no longer resetting vertical scroll when updating preview contents
- Fixed handling Views that reference columns with spaces in their name, when commits table modifications