We’re excited to announce the release of PgManage 1.3, packed with powerful new capabilities, user experience enhancements, and bug fixes. Whether you're working with PostgreSQL, MariaDB, MySQL, SQLite, or Oracle, this Community Edition release delivers improvements to streamline your workflow, improve performance, and enhance visibility across your databases.

What’s New in PgManage 1.3

This release brings a mix of much-requested features and UI/UX refinements designed to make your daily database tasks faster and more intuitive.

Feature Highlights

• Visual Data Filtering in the Data Editor
  A new filtering UI now lets you apply conditions to your data with ease—no manual queries required.
• Dashboard Improvements
  • The new dashboard configuration UI allows for easy widget reordering.
  • A redesigned widget layout presents data in a cleaner, easier-to-read format.
  • Dashboard graphs have been reimplemented for improved clarity and better handling of large datasets.
• MariaDB Support Extended
  The MySQL dashboard has been expanded to include MariaDB compatibility.
• JSON Export for Query Results
  You can now export query result sets directly to JSON.
• Query Editor Upgrades
  • Code folding support is now available for navigating complex queries.
  • You can run EXPLAIN/ANALYZE on a selected portion of a query.
  • Autocomplete now includes column aliases.
• Smarter Backups
  The backup type will now automatically adjust based on the file extension, and vice versa.
• PostgreSQL Documentation Integration
  SQL templates now include quick-access links to relevant sections of the PostgreSQL docs.
• Advanced Clipboard Options
  Query results can be copied as CSV, JSON, or Markdown, ideal for sharing or documentation.
• Improved SQL Preview Features
  A new “Copy to Editor” option is now available in the DDL tab and generated SQL preview boxes.
• New Cell Data Viewer
  This modal includes syntax highlighting and handles various data types elegantly.
• PostgreSQL 17 Support
  PgManage now supports the latest PostgreSQL release, ensuring compatibility with the latest advancements in PostgreSQL.
  

Bug Fixes

• Cleaned up info.plist entries on Mac builds to avoid inappropriate file associations.
• Correctly handle mutually exclusive --create and --single-transaction options in Database Restore.
• Resolved several dark theme visual inconsistencies, including disabled input colors and autocomplete switches.
• Fixed issues with the PostgreSQL Alter View template and loading of database object tree nodes.
• Prevented duplicate backup/restore jobs from being started.
• Ensured only one monitoring dashboard per DB workspace.
  

UI/UX Improvements

• The console tab now handles resizing more gracefully.
• Backends tab UI readability has been improved.
• The Data Editor tab now shows loading and saving indicators.
• Keyboard navigation is now supported in searchable dropdowns.
• Toolbar layout in the Server Configuration tab has been cleaned up.
• Query result messages now display across all supported databases.
• Enhanced the date-range picker and layout in command history modals.
• Widget font size and color now update live when theme settings change.
• Improved data grid rendering performance in both the Data Editor and cells containing large data.
• Combined "Run" and "Run Selection" into a single button group; Autocommit moved to the dropdown menu.
• Backup/restore jobs are now sorted by start time (newest first).
• Improved context menu behavior in the data grid when multiple cells are selected.
• Long backup/restore paths are now truncated in the middle for better readability.
• Added a "Discard Changes" warning when closing the Data Editor.
  

Get Involved

Thank you to all our contributors and testers. Your feedback and support were essential to making PgManage 1.3 our best release yet.

Found a bug? Have a feature suggestion? Want to contribute to the project?

We welcome your input and involvement. You can file an issue or submit a pull request on GitHub.

Check out the full PgManage 1.3 documentation on ReadTheDocs
See the full change log on GitHub

Want to receive blog updates straight to your inbox? Subscribe to the Command Prompt Substack here.