DBeaver
One interface for every database you'll ever need to query.
What it is
About DBeaver
DBeaver provides a visual client for writing and running SQL, browsing schemas and table data, and editing rows across dozens of database engines including PostgreSQL, MySQL, Oracle, SQL Server, SQLite and MongoDB. Its free Community edition covers the vast majority of day-to-day querying and administrative work that would otherwise require engine-specific tools, with the paid PRO tier adding enterprise-database support and collaboration features.
What you can do with it
Capabilities
Connect to and browse virtually any relational or NoSQL database
Write, run and save SQL queries with autocomplete and syntax highlighting
View and edit table data directly in a spreadsheet-like grid
Generate ER diagrams and inspect schema structure
Export query results to CSV, Excel, JSON or another database
How to learn it
Learning Resources
DBeaver's official documentation and wiki
YouTube tutorials on connecting DBeaver to PostgreSQL and MySQL
Practise against a free sample database such as PostgreSQL's Northwind dataset
General SQL courses from Codecademy or Mode SQL tutorial, applied inside DBeaver
Pro Tip
Use the soft-delete confirmation setting and always run SELECT before UPDATE or DELETE in the same tab — DBeaver's data editor makes accidental row edits easy to commit if auto-commit is left on.
Skills that use this tool
Roles that use this tool