pglens

A simple, powerful PostgreSQL database viewer.
Manage connections, explore data, and visualize schemas with ease.

curl -fsSL https://pglens.org/install.sh | bash

Works on macOS, Windows & Linux. The one-liner installs Node.js and everything else for you.

Centralized Connection Hub

Manage all your servers from a distinct landing page with a clear grid view. Your connections are persisted, so you can pick up offered where you left off.

Connection Screen

Smart Data Explorer

Browse rows with auto-formatted JSON/JSONB data. View complex cell values in dedicated popups. Enjoy server-side sorting and filtering for large datasets.

Dashboard View

Fast Navigation

Jump between tables instantly with Spotlight Search (Cmd+K). No more hunting through long lists of tables.

Spotlight Search

Everything you need

Background Service

Runs as a lightweight daemon process for persistent access whenever you need it.

JSON Formatting

Auto-formats JSON data with syntax highlighting for better readability.

Multiple Tabs

Open multiple tables simultaneously in separate tabs to multitask efficiently.

Cell Viewer

Double-click any cell to view full content in a focused popup window.

SSL Support

Secure connections with configurable SSL modes (Disable, Require, Verify CA).

Cross-Platform

Works seamlessly on macOS, Linux, and Windows.