Awesome Universal Database Tool for multiple tables, scripts, triggers...

DBeaver for Mac

DBeaver for Mac

  -  117 MB  -  Open Source
  • Latest Version

    DBeaver 26.0.3 LATEST

  • Review by

    Daniel Leblanc

  • Operating System

    macOS 11.0 Big Sur or later

  • User Rating

    Click to vote
  • Author / Product

    DBeaver Corp / External Link

  • Filename

    dbeaver-ce-26.0.3-macos-x86_64.dmg

DBeaver for Mac is a free multi-platform database tool for developers, SQL programmers, database administrators, and analysts.

Supports all popular databases: MySQL, PostgreSQL, MariaDB, SQLite, Oracle, DB2, SQL Server, Sybase, MS Access, Teradata, Firebird, Derby, etc.

DBeaver for macOS is a free and open-source universal database tool for developers and database administrators.
  • Usability is the main goal of this project, program UI is carefully designed and implemented.
  • It is free and open-source (ASL).
  • It is multiplatform.
  • It is based on the opensource framework and allows writing of various extensions (plugins).
  • It supports any database having a JDBC driver.
  • It may handle any external data source which may or may not have a JDBC driver.
  • There is a set of plugins for certain databases (MySQL, Oracle, DB2, SQL Server, PostgreSQL, Vertica, Informix, MongoDB, Cassandra, Redis, InfluxDB in version 5.x) and different database management utilities (e.g. ERD, data transfer, compare, data export/import, mock data generation, etc).
What`s new:
  • Database navigator
  • Create object menu was improved (no redundant sub-menu)
  • Connection folders creation was fixed
  • Elements coloring was improved (for different connection types)
  • Shortcuts processing was fixed (broken shortcuts after some actions)
  • Table editor tabs activation was fixed
  • Columns editor: auto-completion was fixed in drop-downs.
  • Data transfer: export from multiple queries was fixed (target file names)
  • SQL Editor: SQL formatter was fixed (exp numbers and other minor fixes)
  • Spatial data editor:
  • Geography/geometry value editor (plaintext, WKT)
  • Numerous fixes in different SRIDs support
  • Oracle: metadata (constraints, foreign keys) reading performance was significantly improved
  • PostgreSQL:
  • Multiple query result sets support was added
  • Table partitions information was extended
  • Native database backup was fixed
  • Database creation was fixed (special characters in db name)
  • Sequence rename was fixed
  • Full schema DDL generation was fixed
  • Greenplum, Redshift: execution plan explain now supports plaintext format
  • SQLite: sample database was updated
  • Sybase (12 and older): stored procedures source reading was fixed
  • Apache Ignite: identifiers quoting was fixed
  • DB2 iSeries: schema reading was fixed
  • Extra command line parameters (connection opening)
  • Connections import from SQL Developer was fixed
  • Windows installer: config files (dbeaver.ini) backup
  • Extensions (Office, SVG, etc) installer was fixed
  • Checking for multiple DBeaver instances was added
How to Use
  • Open the downloaded .dmg file and install
  • Launch DBeaver from Applications folder
  • Create a new database connection
  • Enter connection details and test connection
  • Start running SQL queries in the SQL Editor
  • Use the Data Editor to view and edit data
  • Manage database structure via Database Navigator
  • Save queries and results for future use
  • Customize themes and UI in Preferences
System Requirements

macOS 10.11 or later

64-bit Intel or Apple Silicon processor

At least 4 GB RAM (8 GB recommended)

200 MB disk space for installation

Java JDK 11 or higher (can be bundled)

PROS
  • Supports many database types
  • Rich and intuitive user interface
  • Powerful SQL editor with auto-complete
  • ER diagrams and visual data tools
  • Open-source and regularly updated
CONS
  • Can be heavy on system resources
  • Initial setup may confuse beginners
  • Some features need Enterprise edition
  • Occasional UI lag on large datasets
  • Java dependency may cause issues
Note: Requires Java Runtime Environment.

Also Available: Download DBeaver for Windows

Why is this app published on FileHorse? (More info)
  • DBeaver 26.0.3 Screenshots

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

    DBeaver 26.0.3 Screenshot 1

What's new in this version:

Data Editor:
- Added keywords autocompletion for partially typed
- Added the source table name to column header tooltips for query results with JOIN
- Fixed an issue where the row count calculation icon did not reset after counting
- Fixed the display of spatial data when multiple columns were selected
- Fixed the ability to calculate row count for non-standard SELECT statements

Navigator:
- Added a key binding to focus the Database Navigator filter
- ER Diagram: Added preference option to load lazy comments in diagrams

Data Export:
- Fixed export in SQL format for values containing single quotes
- Fixed a corrupted UI area during the Extraction step in Export

Connectivity:
- Added the ability to set Navigator filters in connection settings
- Fixed an issue with filtering for embedded databases
- Miscellaneous: Fixed an issue with an inverted splash screen on macOS Tahoe

Databases:
- ClickHouse: Fixed the display of Array(JSON) types in the data grid

CUBRID:
- Fixed a CSV export error caused by a missing child object
- Fixed a binding failure in PreparedStatement for table names containing single quotes
- Fixed incorrect partitioning DDL generation for values containing commas
- Databricks: Added a logo and fixed the link on the connection page
- H2GIS driver was updated to the latest version
- MySQL: Fixed an issue when the Dump database tool did not work with URL-based connections
- MySQL/MariaDB: Fixed an issue when changing an auto-increment value generated an incorrect query on the first attempt
- Oracle: Fixed an issue in the Metadata Editor when clicking a procedure moved the cursor to a comment containing the procedure name instead of the procedure itself
- Redshift: Set the client_protocol_version driver property to default, which fixed an issue with the availability of external schemas

SQL Server:
- Fixed an issue where user-defined data types based on NVARCHAR were shown with double length
- Removed redundant spaces between CREATE and PROCEDURE in the procedure view
- Fixed an issue that prevented creating a view in the Metadata Editor