dbForge Studio for PostgreSQL
dbForge Studio for PostgreSQL is a GUI tool for database development and management. The IDE for PostgreSQL allows users to create, develop, and execute queries, edit and adjust the code to your requirements in a convenient and user-friendly interface. The tool provides a data editing tool to customize your queries and property window so that users can view all the required information of PostgreSQL database objects they are interested in.
Key features:
* AI Assistant Integration.
* SQL Development. Save your time and improve code quality when creating and editing queries.
* Explorer. Navigate through the object tree and find any PostgreSQL object you want.
* Data Editor. Users can manage the settings of tables.
* Data Export and Data Import. Supports 10+ widely used data formats, a number of advanced options, and templates for recurring scenarios.
* Query Profiler.
* Data and Schema Compare.
* Data Generator.
* Pivot Table.
Learn more
HeidiSQL
HeidiSQL is free software, and has the aim to be easy to learn. "Heidi" lets you see and edit data and structures from computers running one of the database systems MariaDB, MySQL, Microsoft SQL, PostgreSQL and SQLite. Invented in 2002 by Ansgar, HeidiSQL belongs to the most popular tools for MariaDB and MySQL worldwide. Free for everyone, OpenSource. Connect to multiple servers in one window. Supported database systems: MariaDB, MySQL, MS SQL, PostgreSQL and SQLite. Connect to servers via commandline. Connect via SSH tunnel, or pass SSL settings. Create and edit tables, views, stored routines, triggers and scheduled events. Generate nice SQL-exports, compress these afterwards, or put them on the clipboard. Export from one server/database directly to another server/database. Manage user-privileges, import text-files, export table rows as CSV, HTML, XML, SQL, LaTeX, Wiki Markup and PHP Array. Browse and edit table-data using a comfortable grid.
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
ScaleGrid
ScaleGrid is a fully managed Database-as-a-Service (DBaaS) platform that helps you automate your time-consuming database administration tasks both in the cloud and on-premises. Easily provision, monitor, backup and scale your open source databases with high availability, advanced security, full superuser and SSH access, query analysis, and troubleshooting support to improve the performance of your deployments. Supported databases include:
- MySQL
- PostgreSQL
- Redis™
- MongoDB® database
- Greenplum™ (coming soon)
The ScaleGrid platform supports both public and private clouds, including AWS, Azure, Google Cloud Platform (GCP), DigitalOcean, Linode, Oracle Cloud Infrastructure (OCI), VMware and OpenStack. Used by thousands of developers, startups, and enterprise customers including Atlassian, Meteor, and Accenture, ScaleGrid handles all your database operations at any scale so you can focus on your application performance.
Learn more