DB Lens

DB Lens is a desktop application designed for working with PostgreSQL databases. It provides a centralized interface for developers and database administrators to explore their data, visualize the structure of their database, and monitor its health. You can view table contents, execute SQL queries in a built-in playground, and get a clear picture of how your data is interconnected through automatically generated entity relationship diagrams. It runs on MacOS, Windows, and Linux and can be quickly started using a command-line instruction with your database connection string.

The tool stands out by focusing on clarity and performance insights beyond basic data viewing. It gives you detailed metrics on disk usage for tables and indexes, shows index hit rates, identifies sequential scans, and highlights long-running queries. This information is crucial for diagnosing performance bottlenecks and optimizing your database. The ability to open connection strings directly from browsers or emails streamlines the process of connecting to different database instances.

DB Lens is most beneficial for software developers and DBAs who regularly interact with PostgreSQL and need to understand their database's inner workings beyond simple queries. It is practical for tasks like onboarding new team members to a complex database schema, performing routine performance checks, or investigating the cause of a slow application by analyzing query performance and resource utilization directly.