Postbird
Postbird is a cross-platform PostgreSQL GUI client, written in JavaScript, and runs with Electron. Supports views, material views, foreign tables, constraints, and schemas, and connects to Heroku's Postgres. Can manage extensions, procedures, users, filter tables, edit values, and import & export tables or databases. Have comfortable query editing with saving the last query, syntax highlighting, keyboard shortcuts, search, snippets, query history, viewing large results, explaining formatting, and saving results as CSV.
Learn more
Sqlectron
A simple and lightweight SQL client desktop/terminal with cross-database and platform support. A desktop application with a simple interface. Sign and notarize builds for macOS. Supports PostgreSQL and MySQL. Sqlectronhas also has a GUI interface called sqlectron-gui. Most of the time you should not worry about files, because Sqlectron will manage the configuration for you. The paging is not done in SQL query, instead, it is done during the results rendering. Supports PostgreSQL, Redshift, MySQL, MariaDB, Microsoft SQL Server, Cassandra, and SQLite.Although it is possible to change files manually, it is usually better to just use the UI since it allows you to change any of the settings from there.
Learn more
TablePlus
Modern, native client with intuitive GUI tools to create, access, query & edit multiple databases: MySQL, PostgreSQL, SQLite, Microsoft SQL Server, Amazon Redshift, MariaDB, CockroachDB, Vertica, Cassandra, Snowflake, Oracle, Redis.
Learn more
DBeaver Community
DBeaver Community is a free, open-source database management tool recommended for personal projects. Manage and explore SQL databases like MySQL, MariaDB, PostgreSQL, SQLite, Apache Family, and more.
Connect to popular SQL databases (PostgreSQL, MySQL, SQL Server, Oracle, SQLite, etc.)
SQL editor to create queries with syntax highlighting and autocompletion
AI assistant in SQL for building queries through natural language
SSL/TLS support for encrypted connections
SSH tunneling for secure remote access
Proxy configuration to work with databases behind a corporate firewall
Session Manager to terminate, disconnect, view and search for sessions
Lock Manager to monitor and manage database locks
Entity Relationship Diagrams to interactively explore and visualize database structure
Query manager to view all executed queries, including execution time, duration, affected rows, and errors.
Data editor to view, edit, and filter data
Learn more
