An open-source database client for PostgreSQL with automatic ER diagrams, performance analysis, and visual metrics.
DB Lens is an open-source database client specifically for PostgreSQL that provides automatic ER diagrams, performance analysis, and visual metrics. It helps users explore database structures, understand data relationships, and monitor database health through an intuitive graphical interface.
PostgreSQL developers and database administrators who need to visualize schema relationships, analyze query performance, and monitor database metrics without writing complex SQL queries.
It offers a free, open-source alternative to commercial database clients with unique features like automatic ER diagram generation and integrated performance visualization, all in a cross-platform desktop application.
Database explorer for Mac, Windows & Linux
Open-Awesome is built by the community, for the community. Submit a project, suggest an awesome list, or help improve the catalog on GitHub.
Generates visual schema diagrams instantly from PostgreSQL databases, eliminating the need for manual querying as highlighted in the README.
Provides metrics on index utilization, sequential scans, and slow queries to help optimize database performance, as shown in the feature images.
Allows quick connection with a single click using connection strings, simplifying database access without complex configuration.
Offers a free, community-driven alternative to commercial database clients with visual tools, fostering transparency and customization.
Limited exclusively to PostgreSQL databases, making it unsuitable for projects using other database systems like MySQL or SQLite.
As a desktop app built with Electron, it lacks web accessibility and may not integrate well with cloud-based or remote team workflows.
Running from source requires NodeJS and yarn, as per the README, which adds complexity compared to standalone installers or web-based tools.