Secure connections
Save PostgreSQL connection details with encrypted passwords, SSL settings, URL import, testing, search, edit, and delete actions.
PostgreSQL GUI client
A PostgreSQL GUI client for everyday database work.
PgDeck combines a visual PostgreSQL table browser, advanced filters, staged data editing, structure management, and a SQL workspace in a clean desktop interface.
Why developers use PgDeck
PgDeck is shaped around PostgreSQL tasks that happen every day: connect, inspect, filter, edit, query, manage structure, copy, and export.
Type-aware filters for text, numbers, booleans, and dates
Global table search using PostgreSQL ILIKE matching
Column inspector with indexes, defaults, nullable state, and data types
Quick Look editor for large text and JSON values
Keyboard shortcuts for repeated table and SQL tasks
Schema and data grid
Browse schemas and tables, search the table list, pin favorites, filter rows, sort columns, resize columns, and paginate results.
SQL workspace
Run SELECT and non-SELECT statements from multi-tab SQL editors with syntax highlighting and interactive query results.
Staged editing
Edit cells, add rows, duplicate rows, set NULL, stage deletes, review pending changes, and commit everything in one transaction.
Visual table browsing
Explore schemas and tables, search the table list, pin favorites, resize the sidebar, and move between adjacent tables from the data grid footer.
GUI editing with SQL transparency
Use the grid for edits and structure actions while keeping generated SQL previews and explicit confirmations where changes need extra care.
Designed for repeated Postgres tasks
Filtering, sorting, pagination, copy workflows, and exports are optimized for the everyday loop of checking data, making a change, and moving on.
What makes PgDeck a PostgreSQL GUI client?
PgDeck provides visual connection management, schema navigation, data grids, filters, row editing, structure tools, and SQL tabs for PostgreSQL.
Can I use SQL in the GUI?
Yes. PgDeck includes a multi-tab SQL editor for queries and database statements, alongside the visual table interface.
Does PgDeck support exports?
Yes. PgDeck can copy rows as JSON or CSV, export the current page to CSV, and generate SQL INSERT statements.