dbForge Studio for PostgreSQL
dbForge Studio for PostgreSQL is a GUI for PostgreSQL development, design, and management.
Key features:
AI Assistant: generate, fix, and optimize SQL with your choice of AI model, files, and instructions.
SQL Development: context-aware code completion, Parameter Info, Quick Info, and refactoring.
Query Builder: build complex queries visually without code.
Visual Object Editors: manage schemas, tables, functions, procedures, and event triggers.
Debugger: debug stored functions and procedures step by step.
Database Explorer: find any object, its data, or properties.
Data Editor: edit table data in a customizable grid.
Data Export and Import: 10+ formats and reusable templates.
Query Profiler: find slow queries and compare results after optimization.
Data and Schema Compare: sync data and schemas, and tables with Redshift.
Data Generator: realistic test data with real-time preview.
Pivot Table: group, summarize, and analyze data with charts.
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
Adminer
Replace phpMyAdmin with Adminer and you will get a tidier user interface, better support for MySQL features, higher performance and more security. Security is #1 priority in development of Adminer. Adminer does not allow connecting to databases without a password and it rate-limits the connection attempts to protect against brute-force attacks. Still, consider making Adminer inaccessible to public by whitelisting IP addresses allowed to connect to it, password-protecting the access in your web server, enabling security plugins (e.g. to require an OTP) or by customizing the login method. You can also delete Adminer if not needed anymore, it is just one file which is easy to upload in the future. Adminer had some security bugs in the past so update whenever Adminer tells you there is a new version available (ask your administrator if you could not update yourself). Connect to a database server with username and password. /Select an existing database or create a new one.
Learn more
Valentina Studio
Create, administer, query and explore Valentina DB, MySQL, MariaDB, PostgreSQL and SQLite databases for FREE. Design business reports running in Valentina Studio Pro, on Valentina Server or in an application with an Application Developer Kit. Backward Engineering in Standard with forwarding Engineering in Valentina Studio Pro. Reverse engineering and create diagrams for existing databases. Add new objects to diagrams. Write SQL queries with auto-completion, color syntax. Define, manage, save favorite queries; access recent queries. Function browser dictionary of each function. Consoles for errors, warnings, and performance. Search, Export result records into CSV, JSON, Excel. Edit properties of multiple objects at the same time. Drill down to tables and fields; incredible fast searching. Reverse engineering and create diagrams for existing databases. Add new objects to diagrams. Add/drop users, and groups, and manage privileges.
Learn more
