Secure connection management
Save PostgreSQL connections with host, port, database, user, SSL settings, keychain-encrypted passwords, URL import, testing, search, edit, and delete actions.
A faster desktop workflow for PostgreSQL
A fast desktop client for PostgreSQL.
Browse schemas, edit rows safely, run SQL, and export data from one focused workspace.
- Windows, macOS, Linux
- native desktop targets
- Staged edits
- transaction-safe changes
- SQL + structure
- queries and schema tools
What PgDeck handles
The common Postgres jobs, polished into one fast workspace.
The interface is shaped around real database administration: test the connection, inspect schemas, filter data, stage safe edits, change structure with previews, and run SQL when the task calls for it.
Schema explorer built for navigation
Browse schemas and tables, auto-expand public, search across tables, pin favorites across restarts, resize the sidebar, and run table admin actions.
Advanced data grid
Sort columns, combine type-aware filters, search visible columns with PostgreSQL ILIKE, paginate 100-row pages, resize columns, and select multiple rows.
Staged editing system
Double-click cells, edit boolean and enum values with dropdowns, set NULL, add rows, duplicate rows, stage deletes, then commit every change in one transaction.
Structure management
Inspect columns, indexes, nullable state, defaults, and data types. Add, rename, change type, or drop columns with SQL preview confirmation.
Multi-tab SQL editor
Run SELECT, INSERT, UPDATE, DELETE, CREATE, ALTER, and DROP statements with syntax highlighting, independent tab history, and interactive query results.
Copy and export workflows
Copy cell values, copy rows as JSON, copy selected rows as CSV, export the current page to CSV, generate INSERT SQL, or filter instantly by cell value.
Packaged auto updates
Support optional and mandatory updates, background downloads, progress indicators, restart-and-install flow, and version-gated update rules.
Keyboard-driven workflow
Use shortcuts for filters, table search, tab closing, cell editing, add row, duplicate row, commit changes, query execution, and zoom controls.
Built for Postgres flow
Start with tables. Drop into SQL. Commit only the changes you mean.
PgDeck keeps the sharp edges visible: pending edits are explicit, destructive actions require review, and table context stays close while you work.
- Connection strings can populate fields automatically, including SSL settings.
- Passwords are encrypted through Electron SafeStorage and the operating system keychain.
- Global table search uses PostgreSQL ILIKE matching across visible columns.
- New rows can use PostgreSQL DEFAULT values where applicable.
- All staged edits run inside a single transaction with rollback on failure.
- Large text and JSON values open in a dedicated Quick Look editor.
- Selected rows can be copied as JSON, CSV, or SQL INSERT statements.
- Adjacent table navigation is available directly from the data grid footer.
Shortcuts
Designed for developers who keep their hands on the keyboard.
Common table, editor, and zoom actions have direct shortcuts, so PgDeck feels fast during repeated database work.
Ctrl + F
Toggle filter bar
Ctrl + Shift + F
Focus table search
Enter / F2
Edit selected cell
Ctrl + S
Commit staged changes
Ctrl + Enter
Run query or save editor
Ctrl + D
Duplicate selected row
Ready for a lighter PostgreSQL client?
Download PgDeck for Windows, macOS, or Linux and keep your database workflow focused.
Get PgDeck