logoDB Lens
DB Lens - Explore data, execute SQL, metrics, disk usage & more | Product Hunt

Modern PostgreSQL explorer
simplified for everyone

Explore data, visualise entity relations & database performance metrics and
analyse disk usage from PostgreSQL

Quickstart with:

npx dblens <connection_string>
→ Read Docs
Hero

Understand more

DB Lens provide more information about your database such as data-relationships, internal metrics, resource utilisation, index tables, sequential scans, slow running queries and many more.

Storage
Get disk utilisation & record count for each tables and index tables separately.
Structure
Spend less time on understanding data relationships with autogenerated entity relationship diagrams
Scan
Index hit rates, table hit rate, sequential scans, long running queries will help you to understand & tune database for better performance.

Features

DB Lens is simply an DB client application that you can install on your computer running on MacOS / Windows / Linux

Database Viewer

DB Lens comes with in-built database viewer where you can explore tables

SQL Playground.

Use SQL playground to execute SQL queries on the database.

ER Diagrams

Understand the data relations from the automatically generated ER diagrams

Connect with a click

Open PG connectionstrings directly from Browsers / Emails etc.

Usage Analysis

Understand how the database is being used across tables.

Performance Overview

Understand how frequently table/index are scanned and the slow queries.

Want to know more?

Subscribe to our newsletter to get latest product updates.