Secure connections
Save PostgreSQL connection details with encrypted passwords, SSL settings, URL import, testing, search, edit, and delete actions.
Postgres desktop client
A focused desktop client for Postgres work.
PgDeck gives PostgreSQL users a local desktop workspace for connection management, table browsing, safe edits, SQL execution, and exports without the weight of a generic database suite.
Why developers use PgDeck
PgDeck is shaped around PostgreSQL tasks that happen every day: connect, inspect, filter, edit, query, manage structure, copy, and export.
Save PostgreSQL connections with encrypted passwords
Browse schemas, tables, columns, indexes, and row data
Stage row inserts, edits, duplicates, NULL values, and deletes
Run SQL in multiple tabs with interactive results
Export selected data as CSV, JSON, or SQL INSERT statements
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.
Built around PostgreSQL tables
PgDeck keeps schemas, table data, filters, row editing, and table actions close together, so common Postgres administration tasks stay in one screen.
Safer edits by default
Changes are staged first and committed intentionally. That gives you a chance to review edits, inserts, duplicated rows, and deletes before PgDeck sends them to the database.
SQL when you need it
Use the visual data grid for routine inspection, then switch to SQL tabs for SELECT, INSERT, UPDATE, DELETE, CREATE, ALTER, and DROP statements.
Is PgDeck a Postgres desktop client?
Yes. PgDeck is a desktop PostgreSQL client for secure connections, schema exploration, row editing, SQL execution, structure changes, and exports.
Does PgDeck work with remote PostgreSQL databases?
PgDeck can connect with host, port, database, username, password, SSL settings, or a postgres:// connection URL.
Can I edit Postgres rows in PgDeck?
Yes. PgDeck supports staged row editing, new rows, duplicated rows, NULL values, and deletes that can be committed in one transaction.