DBeaver

DBeaver: A Universal Database Manager and SQL Client with a comprehensive set of features

DBeaver is a powerful database management solution, designed to assist database administrators that work with multiple databases into managing tables, triggers, stored procedures and views.

With support for commonly used databases such as Microsoft SQL Server, MySQL, SQLite, Oracle, Firebird, PostgreSQL and IBM DB2, the program allows you to work with multiple connections making it possible to edit and sort a wide array of database objects such as scripts, indexes and user accounts.

At first run, DBeaver will perform an automated scan of your machine, and display all working connections if any are detected. You can create a new connection using the related function, after which you’ll have to select the database type and enter your login information.

Then, the program will list the detected databases and users for the current connection. The database object and its data can be viewed in the Projects tab. For each table you can see related information like references, triggers, available columns, foreign keys, pre-defined constraints, indexes and more.

The built-in SQL editor lets you load existing SQL scripts, edit and run queries and scripts, and also analyze or validate a certain query. To run an SQL query, all you need to do press CTRL+Enter or use the options from the toolbar.