v3.0.0 · rebuilt in React + TypeScript →

The no-code PostgreSQL workstation

Explore data, visualize schemas, and run SQL from a fast, local-first web interface. No-code by default, raw SQL when you want it.

Get started. Copy the one-liner:

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

Local-first · MIT licensed · the one-liner installs Node.js and everything else for you.

Star on GitHub
pglens · 127.0.0.1:54321
pglens schema visualizer

Built on a modern, type-safe foundation

React 18TypeScriptViteTanStack MonacoTailwindZodPostgreSQL
Everything you need

A full workstation, not just a table viewer

From a secure local server to an interactive schema graph. pglens covers the whole loop.

Interactive schema visualizer

Auto-laid-out relationship graph (dagre) with hover spotlight, live filtering, a synced minimap, and one-click export to SVG or Mermaid ER.

Per-install auth

Token-gated routes, 127.0.0.1-only binding, and passwords stored in the OS keychain.

Query runner

Advanced-mode SQL escape hatch in a Monaco editor. Run with Cmd/Ctrl+Enter.

Spotlight search

Fuzzy-jump to any table with Cmd/Ctrl+K. No scrolling long lists.

Virtualized data explorer

Browse millions of rows in a virtualized grid with server-side sorting and pagination, with JSON/JSONB cells in a collapsible, syntax-highlighted tree.

Take the tour

Designed for the way you actually work

01

Centralized connection hub

Manage every server from one clean landing grid. Connections persist between sessions and secrets live in your OS keychain, so you pick up right where you left off, securely.

  • Parameters or connection-URL modes
  • SSL modes: Disable, Require, Prefer, Verify CA / Full
  • Schema picker: browse any schema, not just public
Connection manager
02

Smart data explorer

A virtualized grid built for large datasets, with server-side sorting and pagination. Open complex cells in a focused popup featuring a collapsible, syntax-highlighted JSON/JSONB tree.

  • Multiple tabs: tables, visualizer & query runner side-by-side
  • Column visibility, row numbers, timezone-aware timestamps
  • Streaming backup export with live progress & cancel
Data explorer
03

Raw SQL when you need it

No-code is the default, but the escape hatch is always one tab away. The query runner is a full Monaco editor with a scoped SET search_path per statement.

  • Run with Cmd/Ctrl+Enter
  • Server-side parameterized, never raw fragments from the UI
  • Results land in the same virtualized grid
Query runner
04

Move at the speed of thought

Hit Cmd/Ctrl+K to open Spotlight and fuzzy-jump to any table in any schema, with no hunting through long sidebars.

  • Fuzzy match across tables & views
  • Keyboard-first navigation
  • Opens results in a new tab
Spotlight search
05

JSON & JSONB, finally readable

Double-click any cell to open it in a focused popup with a collapsible, syntax-highlighted JSON/JSONB tree. No more squinting at a single-line blob.

  • Collapsible, syntax-highlighted tree
  • One-click copy of any value
  • Timezone-aware timestamps
JSON/JSONB viewer

Up and running in one command

Local-first, open source, single-command install on macOS, Windows & Linux.

$ curl -fsSL https://pglens.org/install.sh | bash
Or star it on GitHub →