POSTGRESQL IDE / FOR DEVELOPERS AND DBAs
Write SQL, explore relationships and prepare data. Review schema changes and manage database access in a connected desktop workspace.
dbHydratebiginttexttextbigintFKtext
INSIDE PG-dbHydrate
Move between query tabs, records, diagrams and reviewed changes without switching to a collection of separate tools.
THE POSTGRESQL TOOLBOX
One PostgreSQL edition brings these workflows together. Start with the tool your current task needs.
Write SQL in query tabs, inspect table structure and follow related records. Make a readable ER diagram, or design tables and links before reviewing the proposed SQL.
Explore SQL and ER designSelect object changes, inspect generated SQL and rehearse a plan using PostgreSQL's phased DDL approach.
Compare selected tables using common primary keys. Find changed and missing rows within the comparison limit, then read the generated sync SQL.
A WORKSPACE YOU CAN WORK THROUGH
Practical controls for the people building an application and the people responsible for its database.
Connect directly to the servers you choose. Saved workspace files are encrypted with your master password, with auto-lock when you step away.
Inspect differences, SQL and dry-run results. Target protection and confirmation help keep the environment and proposed operation visible.
Reuse sync and copy profiles, inspect local History and use the CLI for supported compare, plan and apply workflows.
Use the published 14-day PostgreSQL trial to investigate queries, map input, review roles and explore changes on your own databases.
POSTGRESQL, EXPLAINED
A few direct answers about the edition, its database tools and the limits worth understanding.
Explore the product trialQuery and edit data, import files, design ER diagrams, compare schemas and selected rows, refresh masked data, inspect activity and review supported roles and permissions in the desktop workspace.
Supported transactional DDL is handled in phases. Operations such as CREATE INDEX CONCURRENTLY need a separate phase. Inspect warnings and recovery SQL; a structural snapshot is not a backup of table data.
Yes. Choose a workbook sheet or CSV, map the columns, add fixed values or defaults and validate the rows. Choose supported append or primary-key matching behavior before importing.
No. It compares a bounded set of records in selected tables with common primary keys and produces synchronization SQL for review.
Yes. Inspect normal login roles, membership and supported database, schema, table, sequence and default privileges. Your account needs the appropriate database permissions, and inherited access is preserved.
The current product catalog lists PostgreSQL 13–17. Available packages: Windows x64 installer, Windows x64 portable. Check the published downloads and pricing for current availability and terms.
The published PostgreSQL product trial is 14 days. Current billing options: Monthly: $10.95 every month; 1 year: $99 every year; 2 years: $148.50 every 2 years; 3 years: $207.90 every 3 years. Each seat allows 2 device(s) for this edition. PostgreSQL, MySQL and SQL Server are separately licensed products.
WORKING WITH ANOTHER DATABASE?
The core desktop tools stay familiar, with the details adapted to each database engine.
Prepare imports, investigate records and review user/host access. Rehearse schema changes with MySQL's implicit commits in view.
Explore the MySQL editionWrite T-SQL, inspect sessions and blocking, and distinguish server logins from database users when reviewing access.
Explore the SQL Server editionSTART WITH YOUR POSTGRESQL DATABASE
Explore PG-dbHydrate with the available 14-day product trial. Current downloads and license terms come from the published catalog.
