Visual filter & sort
Point-and-click filters and drag-to-reorder multi-column sorting. Save any combination as a named view.
New in v3.1 · edit, insert & import — no SQL
→
Work with PostgreSQL data
Work with PostgreSQL data
without writing SQL
Filter, sort, edit, insert, aggregate, export and import your tables by point-and-click. And every action shows you the SQL it ran — so you stay in control.
Free & open source · runs on your machine · nothing leaves your computer. One command installs everything for you.
Star on GitHubEverything you'd open a SQL client for — without typing a query
FilterSortEdit cellsInsert rows
Follow foreign keysAggregateExportImport CSV
Saved views
See it in action
Understand any database in seconds
An auto-drawn map of every table and how they connect — hover to spotlight relationships, filter live, and export the whole picture in one click.
Take the tour
A full database client. None of the SQL.
01
Filter and sort like a spreadsheet
Build a filter from a column, an operator, and a value — no WHERE clause to
remember. Stack multiple sorts by dragging them into the order you want, then save the whole
setup as a named view you can jump back to anytime.
- Type-aware operators: ranges,
LIKE,IN,IS NULL, JSON & array - Drag-to-reorder multi-column sort
- Saved views, shareable by link
02
Edit and add data, right in the grid
Double-click a cell to change it. pglens picks the right control for the column — a toggle for booleans, a date picker, a validated JSON editor — so you can't write a bad value. Adding a row is a guided form built from your schema.
- Type-aware editing with instant rollback on error
- Insert form that knows your defaults and required fields
- Edits run as safe, pinned-to-primary-key updates
03
Follow the data across tables
Click any foreign-key value to slide in the row it points to — no join to write, no second tab to open. Keep clicking to walk the relationships, with breadcrumbs back, or jump to every row that references it.
- One-click foreign-key navigation with breadcrumbs
- "Show all rows where this = that" in one tap
- Edit the referenced row without leaving the panel
04
Prefer SQL? It's always one click away
Every no-code action has a Show SQL button, so you see exactly what runs and learn as you go. Want to take over? The full query runner is one tab away — a real editor with results in the same grid.
- "Show SQL" on every filter, sort, edit, insert & export
- Monaco editor, run with
Cmd/Ctrl+Enter - No-code never sends raw SQL — queries are parameterized server-side
05
Find any table instantly
Hit Cmd/Ctrl+K to open Spotlight and fuzzy-jump to any table or view in any
schema — no scrolling through endless sidebars.
- Fuzzy match across tables & views
- Keyboard-first, opens in a new tab
- Works across every schema, not just
public
06
All your databases, one home
Every server lives in a single clean grid. Connections come back when you reopen pglens, and your passwords stay in your OS keychain — never in a config file, never in the cloud.
- Connect by parameters or a connection URL
- SSL modes: Disable, Require, Prefer, Verify CA / Full
- Secrets in your OS keychain, bound to
127.0.0.1
Why pglens
Built to do the work, not just show the rows
Other clients make you write SQL for everything, or lock the good parts behind a subscription. pglens does it all by point-and-click — for free.
Inline editing & insert
Edit cells with type-aware controls and add rows through a schema-built form. No bad values, no UPDATE statements.
Follow foreign keys
Click a value to open the row it references, walk relationships with breadcrumbs, and edit along the way.
One-click aggregations
Count, sum, avg, min, max, stddev and distinct counts pinned to the bottom of every grid — computed on the active filter.
Export & import
Export tables to CSV, JSON or SQL respecting your filter and columns. Import CSV with column mapping and conflict handling.
Schema visualizer
Auto-laid-out relationship graph with hover spotlight, live filtering, minimap, and export to SVG or Mermaid ER.
Show SQL, always
Every no-code action reveals the exact query it runs — and a full Monaco query runner is one tab away when you want it.
Private by default
Runs on your machine, bound to 127.0.0.1, secrets in the OS keychain. No account,
no telemetry, nothing in the cloud.
FAQ
Questions, answered
Do I need to know SQL?
No. Filtering, sorting, editing, inserting, aggregating, exporting and importing are all point-and-click. SQL is optional — and when you're curious, "Show SQL" reveals exactly what each action runs.
How is pglens different from pgAdmin, DBeaver or TablePlus?
Most clients are SQL-first — you write queries to do anything real, or pay for the no-code parts. pglens flips that: filter, edit, insert, follow foreign keys, aggregate and import/export without typing SQL, with the generated query always visible. Free, open source, and runs locally.
Is editing my data safe?
Yes. No-code actions never send raw SQL from the browser — the server turns your choices into parameterized queries. Edits are pinned to the primary key, type-validated, applied optimistically, and rolled back if the database rejects them.
Is pglens free?
Yes. pglens is open source and MIT licensed. No account, no telemetry, no paywall.
Is my data sent anywhere?
No. pglens is local-first — it binds to 127.0.0.1 only, routes are
token-gated, and passwords are stored in your OS keychain. Nothing leaves your machine.
Which platforms and Postgres versions are supported?
macOS, Linux and Windows, with any modern PostgreSQL server. One install command sets up Node.js and every dependency. Connect by parameters or URL, pick any schema, choose your SSL mode.