Setup and Manage your macOS SQLite database easily!

SQLiteStudio for Mac

SQLiteStudio for Mac

  -  33.69 MB  -  Open Source
  • Latest Version

    SQLiteStudio 3.4.17 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.17-macos-x64-installer.dmg

  • MD5 Checksum

    71028951b077e27d272a63e0214df012

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,
  • 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,
  • Configurable colors, fonts, and shortcuts,
  • Open source and free.
How to Use

Open the downloaded DMG file and drag to Applications

Launch SQLiteStudio from Applications folder

Create or open an SQLite database file

Use the GUI to run SQL queries or browse tables

Edit table structures using the table editor

Manage indexes, triggers, and views with visual tools

Save your project or export data as needed

Access logs and SQL history for review

Use the built-in SQL editor with syntax highlighting

System Requirements
  • macOS 10.13 High Sierra or newer
  • Intel or Apple Silicon (Rosetta for M1/M2)
  • At least 100 MB of free disk space
  • Minimum 2 GB RAM
  • Java Runtime Environment (JRE) 8 or higher
PROS
  • User-friendly graphical interface
  • Portable and lightweight application
  • No installation required
  • Built-in SQL editor and debugger
  • Supports multiple database formats
CONS
  • No official dark mode support
  • Java dependency required to run
  • Interface can feel outdated
  • Limited support for large databases
  • Occasional performance lags on Mac
Also Available: Download SQLiteStudio for Windows

  • SQLiteStudio 3.4.17 Screenshots

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

    SQLiteStudio 3.4.17 Screenshot 1
  • SQLiteStudio 3.4.17 Screenshot 2
  • SQLiteStudio 3.4.17 Screenshot 3
  • SQLiteStudio 3.4.17 Screenshot 4