pgStudio
Updates & Improvements

Release Notes

Everything new in pgStudio. We ship fast and often.

v2.0.4

Latest
October 24, 2023
Schema Designer AI & Performance Boosts

Schema Designer AI & Performance Boosts

This release introduces the highly anticipated Schema Designer AI, allowing you to generate complete database schemas from natural language descriptions. We've also significantly improved the performance of the virtualized data grid.

New Features

  • Schema Designer AI: Generate tables, columns, and foreign keys from text.
  • Data Grid: 40% faster rendering for result sets over 100k rows.
  • SQL Editor: Added inline error hints for syntax mistakes.

Bug Fixes

  • Fixed an issue where the connection pool would occasionally drop.
  • Resolved a UI glitch in the dark mode toggle.

v2.0.0

Major
September 12, 2023
The Native macOS Rewrite

The Native macOS Rewrite

We've completely rewritten pgStudio from the ground up using Rust and Tauri. This means no more Electron bloat, instant startup times, and a native macOS feel.

New Features

  • Rust Core: Memory usage reduced by 80%.
  • Zero-Trust Security: All credentials are now encrypted on-device using the Secure Enclave.
  • Command Palette: Hit ⌘K to access any action instantly.

v1.4.2

August 05, 2023
Query Plan Visualizer

Query Plan Visualizer

Understanding slow queries is now easier than ever. The new Query Plan Visualizer takes EXPLAIN ANALYZE output and turns it into an interactive node graph.

New Features

  • Visual EXPLAIN: See exactly where your query is spending time.
  • Index Recommendations: Get AI-powered suggestions for missing indexes.

Bug Fixes

  • Fixed a crash when exporting large CSV files.