DB Connect v2.4.0
What's new
- ✨ Full PostgreSQL support — DB Connect now supports MySQL, PostgreSQL, Amazon Redshift, and DynamoDB. PostgreSQL gets transactions (BEGIN/COMMIT/ROLLBACK + auto-commit), an index manager, table relations (outgoing + incoming foreign keys), a full Alter Table designer, CSV/SQL import, connection-string paste-to-parse, and EXPLAIN ANALYZE.
- ✨ PostgreSQL-native features with no MySQL equivalent — an extensions viewer/installer (pg_extension), custom ENUM types (creatable and selectable directly in the table designer), materialized views (create/refresh/drop), array column types (
TYPE[]), sequences (list/create/restart/drop, including SERIAL-owned sequence detection), table bloat stats (dead-tuple % and last-vacuum time) with one-click VACUUM/ANALYZE, and read-only visibility into Row-Level Security policies and declarative table partitioning. - 🐛 Fixed a cross-engine autocomplete bug — the query editor's suggestion provider only ever called MySQL's schema-loading functions regardless of which engine a tab was actually connected to, so PostgreSQL and Redshift tabs never fetched column/table data through that path. It also never told the editor to reopen the suggestion list once a lazy load finished, so the very first reference to any not-yet-loaded table showed an empty dropdown on any engine. Both are fixed — suggestions now load per-engine and reappear automatically as soon as the data is ready.
- 🐛 Fixed a broken EXPLAIN viewer — PostgreSQL and Redshift query plans were being run through MySQL's severity heuristics and always showed as a false "full table scan" warning, regardless of the actual plan. Postgres/Redshift's text-based plans now render correctly.
Downloads
| Platform | File |
|---|---|
| macOS (Intel + Apple Silicon, DMG) | DBConnect-macOS-v2.4.0.dmg |
| macOS (zip) | DBConnect-mac-v2.4.0.zip |
| Windows (installer) | DBConnect-Windows-Setup-v2.4.0.exe |
| Windows (zip) | DBConnect-Windows-v2.4.0.zip |
macOS users: curl -fsSL https://github.com/shubhesh07/db-connect/releases/latest/download/install.sh | bash
SHA256
f5648baec39481f37b39583593c78d561af207d4a7ebb00745db1ae947a6c13e DBConnect-mac.zip
f5648baec39481f37b39583593c78d561af207d4a7ebb00745db1ae947a6c13e DBConnect-mac-v2.4.0.zip
c9c72fc0936ab7ada59fa7d104df499e38188fb39a8450726ef1aaf80093ea95 DBConnect-macOS.dmg
c9c72fc0936ab7ada59fa7d104df499e38188fb39a8450726ef1aaf80093ea95 DBConnect-macOS-v2.4.0.dmg
972a2697e910fadb2c7bcb29b491a8b5272f915e9ae1be1373743f2a9da1193a DBConnect-Windows-Setup.exe
972a2697e910fadb2c7bcb29b491a8b5272f915e9ae1be1373743f2a9da1193a DBConnect-Windows-Setup-v2.4.0.exe
d4ec0e653b6318505dd02d53dee7a960ef473c28bf0b5c1897c11b8cff5a95a4 DBConnect-Windows.zip
d4ec0e653b6318505dd02d53dee7a960ef473c28bf0b5c1897c11b8cff5a95a4 DBConnect-Windows-v2.4.0.zip