PostgreSQL
The PostgreSQL client built for full-stack developers
Connect to PostgreSQL and Amazon Redshift databases with a native desktop app. RowDex combines SQL querying, schema browsing, and saved queries — plus Redis and BullMQ monitoring your backend also needs.
PostgreSQL Features in RowDex
Query editor with autocomplete
Write SQL with intelligent autocomplete for table names, columns, and functions. Execute queries, view results in a spreadsheet-style grid, and export to CSV, JSON, or Excel.
Schema browser
Browse tables, views, functions, indexes, and constraints. View column types, nullable status, and foreign key relationships without writing SQL.
Multi-tab query sessions
Open multiple query tabs per connection. Each tab remembers its SQL and results across app restarts — no more lost queries.
Saved queries & history
Save frequently-used queries with names and descriptions. Full query history lets you recall and re-run past statements.
Connection management
Store multiple Postgres connections with OS keychain credential storage. Label environments (dev, staging, prod) and switch between them in one window.
Production safety
Enable read-only mode for production databases. RowDex shows warnings before running UPDATE, DELETE, or DROP statements.
Connection Options
- Direct TCP connection to local or remote PostgreSQL servers
- SSH tunnel for secure access to private databases
- SSL/TLS encrypted connections
- Amazon Redshift via PostgreSQL protocol
- Connection string import for quick setup
Common PostgreSQL Use Cases
- Daily development queries against local or Docker Postgres instances
- Debugging production data with read-only connections
- Schema exploration when onboarding to a new codebase
- Running ad-hoc analytics queries on staging data
- Managing multiple client projects with separate connections
Why Not Just Use Other PostgreSQL Tools?
pgAdmin
pgAdmin is web-based and Postgres-only. RowDex is a native app that also handles Redis, BullMQ, MongoDB, and MySQL — one tool for your full stack.
DBeaver
DBeaver is powerful but heavy (Java, 118 MB installer, typically 400–700 MB idle RAM). RowDex uses Tauri for a <50MB installer and lower RAM usage.
DataGrip
DataGrip requires a paid JetBrains subscription. RowDex Basic is free forever for PostgreSQL.
psql CLI
psql is great for scripts but lacks visual schema browsing and saved query management. RowDex provides a GUI while keeping keyboard-driven workflows.
FAQ
Does RowDex support all PostgreSQL versions?
Yes. RowDex connects to PostgreSQL 9.6 through 17, plus Amazon Redshift and other Postgres-compatible databases.
Can I connect to PostgreSQL over SSH?
Yes. RowDex supports SSH tunneling with password or key-based authentication.
Is RowDex free for PostgreSQL?
Yes. Basic tier is free forever and includes full PostgreSQL support, saved queries, and query history.
Does RowDex store my database password?
Credentials are stored in your OS keychain (macOS Keychain, Windows Credential Manager, or Linux Secret Service) — not in plain text files.
Can I use RowDex for Postgres and Redis together?
Yes. RowDex handles SQL databases, Redis key browsing, and BullMQ queue monitoring in one window — no need for separate tools.
Related
Try RowDex free
Native database client for macOS, Windows, and Linux. Basic is free — download and connect in minutes.