DBeaver Community — The Complete Guide: One Database Client for Monitoring, Test and GIS Data

DBeaver Community is an open-source (Apache-2.0) graphical database client that connects to PostgreSQL, MySQL, MariaDB, SQLite and other relational databases from one interface. When monitoring, inventory, test or GIS data lives in a database rather than a spreadsheet, DBeaver is a convenient way to ask it questions.

DBeaver Community

DBeaver Corp

A universal database client — PostgreSQL, MySQL, SQLite and more, with an SQL editor and convenient table editing.

Get it from the vendor

What you get

SQL editor — with auto-completion and query execution.
Table viewing and editing — spreadsheet-style, directly in the database.
Import and export — move data into and out of the database.
Schema diagram — a graphical view of tables and their relationships.
Many connections — several databases side by side in one interface.

Engineering uses

A monitoring engineer can pull sensor readings for a date range and export them for analysis; a GIS engineer can inspect tables in a spatial database; and a lab can keep test results in a small SQLite database instead of dozens of files. The Community edition is free for any use, including commercial. Support for NoSQL databases and cloud services is reserved for the PRO editions, which are separate commercial products with technical support.

Related tools

For focused work with SQLite files — DB Browser for SQLite. For cleaning and organising data before loading — OpenRefine. For quickly browsing large tables in the terminal — VisiData.