With this free app you can create and edit SQlite databases

DB Browser SQLite for Mac
Report    Share

Browse by Company

Adobe, Apowersoft, Autodesk, Avast, Corel, Cyberlink, Google, iMyFone, iTop, Movavi, PassFab, Passper, Tenorshare, Wargaming, Wondershare

DB Browser SQLite for Mac

  -  43.5 MB  -  Open Source
Free Download

Security Status

DB Browser SQLite for Mac (DB4S) is a high-quality, visual, open source tool to create, design, and edit database files compatible with SQLite. DB4S is for users and developers who want to create, search, and edit databases.

Database Browser SQLite for macOS uses a familiar spreadsheet-like interface, and complicated SQL commands do not have to be learned.

Controls and wizards are available for users to:
  • Create and compact database files
  • Create, define, modify, and delete tables
  • Create, define, and delete indexes
  • Browse, edit, add, and delete records
  • Search records
  • Import and export records as text
  • Import and export tables from/to CSV files
  • Import and export databases from/to SQL dump files
  • Issue SQL queries and inspect the results
  • Examine a log of all SQL commands issued by the application
  • Plot simple graphs based on table or query data
This program was developed originally by Mauricio Piacentini from Tabuleiro Producoes as the Arca Database Browser.

The original version was used as a free companion tool to the Arca Database Xtra, a commercial product that embeds SQLite databases with some additional extensions to handle compressed and binary data.

How to Use
  • Install by dragging to the Applications folder
  • Launch the app from Applications or Spotlight
  • Create a new database or open an existing one
  • Use the "Execute SQL" tab to run SQL queries
  • Browse tables using the "Browse Data" tab
  • Edit table structure via the "Database Structure" tab
  • Save changes using the "Write Changes" option
  • Export database or tables as SQL or CSV
  • Close the database before exiting the app
FAQs

What is DB Browser for SQLite used for?
DB Browser for SQLite is an open-source tool designed to create, design, and edit database files compatible with SQLite. It provides a visual interface that simplifies managing tables, running SQL queries, and editing records without requiring command-line interaction.

Is DB Browser for SQLite available for macOS?
Yes, DB Browser for SQLite is fully compatible with macOS. It can be downloaded from the official website or installed via package managers like Homebrew for easy setup and updates.

Does DB Browser for SQLite support importing and exporting data?
Yes, it supports importing and exporting data in multiple formats, including CSV, SQL, and JSON. This allows seamless data migration and integration with other applications or databases.

Is DB Browser for SQLite free to use?
Yes, it is completely free and open source under the GNU General Public License (GPL). Users can use, modify, and distribute it without any cost.

Can I execute SQL commands directly in DB Browser for SQLite?
Absolutely. The built-in SQL editor lets you write, edit, and execute SQL commands directly on your database, making it suitable for both beginners and advanced developers.

Does DB Browser for SQLite support encrypted databases?
Yes, it supports encrypted SQLite databases, allowing users to open, modify, and create password-protected database files securely.

System Requirements
  • macOS 10.12 (Sierra) or later
  • Intel or Apple Silicon (M1/M2) processor
  • Minimum 2 GB RAM
  • Around 100 MB of disk space
  • Internet connection for downloads and updates
PROS
  • Free and open-source software
  • User-friendly graphical interface
  • No installation required for portable version
  • Supports SQL query execution easily
  • Lightweight and fast performance
CONS
  • No built-in data visualization
  • Limited support for advanced SQL features
  • No real-time collaboration features
  • Manual save required for changes
  • Interface can feel outdated to some users
Also Available: Download DB Browser for SQLite for Windows

Download DB Browser SQLite for Mac Latest Version
Why is this app published on FileHorse? (More info)

  • DB Browser for SQLite 3.13.1 Screenshots

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

    DB Browser for SQLite 3.13.1 Screenshot 1

What's new in this version:

Added:
- Add links to the wiki as help for many dialogs

Changed:
- Change the default to install a shortcut to the Start menu when installing on Windows
- Improve icon image for links in 'Help' menu
- Pragma names and values can now be translated
- Remove trailing characters when copying a single cell
- Update AppImage binary to use the latest SQLCipher library
- When editing the DB cells, expanded queries with parameters are included in the SQL Log

Fixed:

ExtendedTableWidget:
- Fix an issue that prevented autocomplete from working in some race conditions
- Use Tab to close autocomplete popup and move to next item
- Troubleshoot 'Copy as SQL' action on a cell results in string being copied

Global:
- Fix "Argument Missing" error in Korean translation
- Fix an issue that caused apps to crash on some older versions of macOS
- Fix an issue when freezing after stopping a pragma
- Fix an issue with outputting the wrong version on macOS
- Troubleshooting poor HiDPI support on Windows
- Troubleshoot SQL queries containing VACUUM that run incorrectly

MainWindow:
- Fix an issue when selecting queries containing multi-byte strings

TableBrowser:
- Fix a bug where the first row was not adjusted

etc:
- Fix misleading links to Qt license information
- Replace 'http' with 'https' in the 'AboutDialog' and 'MainWindow'
- Translation
- German
- Indonesian
- Japanese
- Korean
- Simplified Chinese
- Spanish

Top Downloads

More Popular Software »