DBeaver CE

One free tool for every database.

Overview

DBeaver Community Edition is a free, open-source database client that connects to almost any database through JDBC - PostgreSQL, MySQL, MariaDB, SQL Server, Oracle, SQLite and many more.

It gives you a SQL editor with auto-complete, a data viewer and editor, ER diagrams and data export, all in one application.

Where it is used

  • Developing and testing SQL queries
  • Exploring unfamiliar databases
  • Data export and migration
  • Teaching and learning SQL

Getting started

  1. Download DBeaver Community from dbeaver.io.
  2. Create a new connection and choose your database type.
  3. Enter host, port, database name and credentials; test the connection.
  4. Open a SQL editor and run your first query.

What you will cover

The key topics and features of DBeaver CE

Universal Connectivity

Connect to many databases with one tool.

SQL Editor

Auto-complete, formatting and script execution.

Data Viewer & Editor

Browse and edit table data in a grid.

ER Diagrams

Visualise tables and relationships.

Data Export / Import

Move data to CSV, JSON, Excel or another database.

SSH Tunnels

Reach databases on remote servers securely.