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
- Download DBeaver Community from dbeaver.io.
- Create a new connection and choose your database type.
- Enter host, port, database name and credentials; test the connection.
- 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.