# pgjumbo 1.0.2 released as free cross-platform PostgreSQL desktop client

> **Key takeaway:** pgjumbo offers a native desktop administration tool for PostgreSQL 12+ with visual EXPLAIN diagrams, reviewed maintenance operations, and multi-format Linux packaging alongside Windows and macOS support.

**Published:** 2026-11-18T14:01:55.166168+00:00 
**Source:** PostgreSQL Official News 
**Category:** databases-storage 
**Canonical URL:** https://fosswire.org/news/pgjumbo-102-released-as-free-cross-platform-postgresql-deskt.html 

## Summary
pgjumbo has launched as a new free desktop client for PostgreSQL 12 and newer versions, available across Windows, macOS, and Linux with native installers for each platform. The application provides a comprehensive suite of database administration tools including query editing with PostgreSQL-native syntax validation, object exploration with dependency tracking, and visual EXPLAIN plan rendering.

Version 1.0.2 emphasizes operational safety through SQL review workflows: all object changes are previewed as SQL before execution, and servers tagged as Production require explicit confirmation for destructive operations. The client supports direct connections, SSL, and SSH tunneling, including Amazon Aurora and RDS deployments with IAM authentication.

## Tools and platform support in pgjumbo 1.0.2
- **Query Tool:** Provides auto-completion, live syntax error detection using PostgreSQL's own parser, parameterized queries, EXPLAIN output as both tables and diagrams, and result sets that support sorting, filtering, comparison, and export.
- **Backup and restore engine:** Wraps pg_dump, pg_dumpall, and pg_restore with granular object and row selection, server backups as folder-based archives, archive content inspection before restore, and targeted restoration into new databases.
- **Maintenance workflows:** Surfaces per-table VACUUM blocking analysis, presents VACUUM, ANALYZE, and REINDEX as reviewable step-by-step operations with progress tracking, and exposes autovacuum settings at the table level.
- **Cross-platform packaging:** Ships as Windows x64 and ARM64 installers, macOS universal binaries for Apple silicon and Intel, and Linux AppImage, .deb, and .rpm packages.
- **Safety controls:** Displays generated SQL for all object modifications before execution, and enforces confirmation prompts for destructive statements on servers marked as Production environments.

## Why it matters
pgjumbo fills a gap in the PostgreSQL tooling landscape by providing a native, no-cost alternative to proprietary desktop clients like TablePlus or Navicat, with explicit support for cloud-managed instances including Amazon RDS and Aurora. Its multi-format Linux packaging and ARM64 support for Windows and macOS align with the needs of developers on modern hardware and diverse distributions, while the SQL review and production safeguards address operational requirements in enterprise and managed-service contexts.