Get more insights from PostgreSQL
DB Lens is an open-source database client that helps you to explore database, understand data relations more quickly with automatic ER diagrams, visualise and analyse internal DB metrics such as index utilisation sequential scans, slow running queries, storage and many more.
Try running
npx dblens <connection_string>
# npx dblens postgres://user:pass@host/dbfrom your terminal
Read more from the official documentation from https://dblens.app/docs/quickstart
- Connect with a click: simply connect to a DB by clicking on the connection string 🪄
- Usage Analysis: Understand how the database is beign used across tables
- Performance overview: Understand how frequently table/index are scanned and the slow queries.
NodeJS & yarn (NPM should also work but we are maintaining a yarn lock file only
- install dependencies
yarn install
- to run the application
yarn start
- to build and package the application
yarn package
Pull requests are the best way to propose changes to the codebase (we use Github Flow). We actively welcome your pull requests:
- Fork the repo and create your branch from
main. - If you've added code that should be tested, add tests.
- If you've changed APIs, update the documentation.
- Ensure the test suite passes.
- Make sure your code lints.
- Issue that pull request!