DBeaver Database Tool Free 6.2.0

24/10/2019 - DBeaver Corporation (Freeware)
1 Star2 Stars3 Stars4 Stars5 Stars (No Ratings Yet)
Loading...

DBeaver Database Tool is an easy to use and reliable piece of software geared towards users who need to manage multiple SQL databases, execute SQL scripts, migrate connections and view diagrams.

When you launch DBeaver for the first time, you can choose a new connection type, then specify the information that allows you to connect to the selected database. After that

It 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. Download DBeaver Database Tool For Windows PC.

It is a free and open-source universal database tool for developers and database administrators.

DBeaverMain Features of DBeaver Database

Connection to various data sources
  • Choice of database driver from the variety of supported types. The list of drivers includes drivers for relational, document-oriented, key-value, time-series and other databases.
  • Support of user-defined connection types and creation of custom drivers an the Driver Manager
  • Configuration of standard (host, port, user credentials) as well as advanced connection properties:
    1. SSH tunnel
    2. SOCKS proxy
    3. Shell commands to be executed before/after actual database connection
  • Bootstrap SQL queries executing in the database session immediately after connecting

generic Setting

NoSQL / BigData databases

DBeaver Enterprise has special extensions for:

  • MongoDB
  • Amazon DynamoDB
  • Google Bigtable
  • InfluxDB
  • Apache Cassandra
  • Redis
  • Apache Hive

All these databases have SQL interface and you can work with them as with good old relational databases.

And this is not some kind of JDBC driver abstraction – DBeaver database supports all native data types and databases structure explorer for these databases.

All-in-one
  • It comes with all existing extensions, you don’t need to install anything else. This includes:
    1. Office formats support
    2. Vector graphics support
    3. SQL debugging framework
    4. Advanced SSH algorithms
  • Most popular database drivers are included in the distribution
  • A number of Eclipse extensions are included for advanced security and easy installation of 3rd party extension using Eclipse Marketplace
Data viewer and editor
  • Multiple data views to fit the variety of users’ needs, for example, display of image contents (gif, png, jpeg, BMP) as images
  • Editing of data inline and in a dedicated space
  • Convenient navigation among data
  • Custom filters for table contents or query results, including filters based on cell values
  • Results ordering by column
  • Data export with all applied filters and orderings
  • Generation of SQL statements based on selected rows
  • Basic statistics for selected columns

data_edit

Mock-Data Generator

You can generate random data (or “mock” data) for tables. And this data should look like the real data.

Enterprise edition includes basic and advanced data generators. Including:

  • Numbers
  • Random strings
  • Names
  • Addresses
  • Credit cards
  • Domains and IP addresses
  • Custom regular expressions
  • Flexible numeric generators

mock-test of DBeaver Database Tool

SQL editor
  • Organization of scripts into folders and reassignment of database connections for particular scripts
  • SQL syntax highlighting determined by the database associated with a script
  • Support for different sets of reserved keywords and system functions for different databases
  • Import and export of scripts

sql_script

Visual Query Builder
  • You may construct complex SQL queries without actual knowledge of SQL
  • Make table joins/filtering/ordering visually
  • Open your existing SQL queries in visual mode, edit and save them – that’s easy
  • Execute your visually constructed query at any moment and get results on the screen
  • Analyze complex SQL queries visually

visual-query-builder

Metadata browser
  • A tree of database connections with their metadata structures down to the lowest level: tables, views, columns, indexes, procedures, triggers, storage entities (tablespaces, partitions), and security entities (users, roles)
  • Ability to modify most metadata entities, depending on the database driver capabilities
  • Display of database objects` DDL and generation of standard SQL92 DDL according to object structure for some databases
  • Ability to edit/rename/delete connections and most database objects
  • Global and local filters, ability to filter database objects by name
Data transfer
  • Export of data to a file or to another database table with the option to create the destination table if it does not exist
  • Supported file formats: CSV, HTML, XML, JSON, XLS, XLSX
ER diagrams
  • Automatically generated ER diagrams for a database/schema (with all tables) or for a single table (with all referenced/referencing tables)
  • Customization of columns visibility
  • Export of diagrams to the formats: GIF, PNG, BMP, GraphML

ERD Diagram

Data and metadata search
  • Full-text data search against all chosen tables/views with search results shown as filtered tables/views
  • Metadata search among rows in database system tables
  • Ability to set an exact object name or a search mask

Database structure comparing

  • Ability to compare several database objects of any type: tables, schemas, entire databases, etc
  • Comparison results presented in HTML reports

Other Features of DBeaver Database

  • SQL queries execution
  • Data browser/editor with a huge number of features
  • Syntax highlighting and SQL auto-completion
  • Database structure (metadata) browse and edit
  • SQL scripts management
  • DDL generation
  • ERD (Entity Relationship Diagrams) rendering
  • SSH tunneling
  • SSL support (MySQL and PostgreSQL)
  • Data export/migration
  • Import, export, and backup of data (MySQL and PostgreSQL)
  • Mock data generation for the database testing
  • 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 an 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

System requirements

Operating System Windows XP, Windows Vista, Windows 7, Windows 8, Windows 10

Mac OS X

Linux Debian 64 Bit

Java And JRE Required 1.8 and higher version
Additional Information 3rd-party JDBC drivers

Technical Specification

Software Name DBeaver Database Tool V6.2.0
File Name Windows OS- dbeaver-ee-6.2.0-x86_64-setup.exe

Mac OS- dbeaver-ee-6.2.0-macos.dmg

Linux OS- dbeaver-ee_6.2.0_amd64.deb

File Size Windows OS- 117 MB

Mac OS- 210 MB

Linux OS- 2019 MB

Language English
License Open-source
Developer DBeaver Corp

DBeaver comes packed with useful and easy to handle tools and editors that come in handy for users who need to manage multiple database connections, triggers, procedures, and views, as well as execute SQL scripts, from simple to complex. Download DBeaver Software For Linux.

Add a Comment

Your email address will not be published. Required fields are marked *