awesome-db-tools
Everything that makes working with databases easier (by mgramin)
pev2
Postgres Explain Visualizer 2 (by dalibo)
SurveyJS: Build JSON-Driven Surveys and Forms with Full Data Control
Add the SurveyJS UI components to your JS app (React/Angular/Vue3). Securely collect and analyze data without sending it to 3rd-party servers. Fully customizable, works with any backend, and ideal for data-heavy apps. Learn more.
surveyjs.io
featured
| awesome-db-tools | pev2 | |
|---|---|---|
| 19 | 47 | |
| 4,906 | 3,261 | |
| 1.8% | 2.4% | |
| 5.0 | 9.1 | |
| 6 days ago | 1 day ago | |
| TypeScript | ||
| Creative Commons Zero v1.0 Universal | PostgreSQL License |
The number of mentions indicates the total number of mentions that we've tracked plus the number of user suggested alternatives.
Stars - the number of stars that a project has on GitHub. Growth - month over month growth in stars.
Activity is a relative number indicating how actively a project is being developed. Recent commits have higher weight than older ones.
For example, an activity of 9.0 indicates that a project is amongst the top 10% of the most actively developed projects that we are tracking.
Stars - the number of stars that a project has on GitHub. Growth - month over month growth in stars.
Activity is a relative number indicating how actively a project is being developed. Recent commits have higher weight than older ones.
For example, an activity of 9.0 indicates that a project is amongst the top 10% of the most actively developed projects that we are tracking.
awesome-db-tools
Posts with mentions or reviews of awesome-db-tools. We have used some of these posts to build our list of alternatives and similar projects. The last one was on 2025-05-03.
- Why uber ditched postgres for mysql: What every developer can learn from it
Awesome Database Tools An ongoing GitHub list of cool tools for DB monitoring, analysis, backup, and migration.
- SQLedge: Replicate Postgres to SQLite on the Edge
- What are your favourite books and maybe online courses on databases?
- Looking For Personal Database
Check IDE and GUI sections of https://github.com/mgramin/awesome-db-tools, some of them should be able to work with SQLite. My use case is different from yours (I'm developer and have no need for manual data entry) so I'm not sure what's best for you, try them yourself.
- Is there a good alternative for the tool DataQuant (IBM)?
Looking forward to my special db tools list https://github.com/mgramin/awesome-db-tools especially IDE and GUI sections
- Learning Resources and Puzzles for SQL
I have been starting to gathering learning resources and puzzles for SQL. Feel free to add new ones https://github.com/mgramin/awesome-db-tools#learning
- Learning resources and puzzles for SQL. Feel free to add new
- Lazy beginner MySQL dev wants opinions
I think sharing database access across Internet is quite dangerous decision because of security. Instead of LAMP (or something like that) you might to use special tools or platforms for building/generating API or even a whole application over your DB https://github.com/mgramin/awesome-db-tools (API and "Application platforms" sections)
- Can I master beginners level SQL in a week?
I have an idea to create special section for SQL learning resources and SQL puzzles in my database tools list https://github.com/mgramin/awesome-db-tools/issues/336 because I see similar questions everyday. Lets do it together! 😉
- SSMS alternative for Mac?
Take a look at awesome-db-tools list, especially IDE section https://github.com/mgramin/awesome-db-tools
pev2
Posts with mentions or reviews of pev2. We have used some of these posts to build our list of alternatives and similar projects. The last one was on 2024-12-01.
- PostgreSQL Performance Tuning: The Power of work_mem
If you're a visual person (like me), there are tools that can help you understand the EXPLAIN output, such as https://explain.dalibo.com/. Below is an example showing a node with the Sort step, including details like Sort Method: external merge and Sort Space Used: 2.2MB:
- Top 🐘👀 Postgres Monitoring Tools 🧰 and Best Practices in 2024 🔝
explain.dalibo.com is a web UI to visualize the Postgres EXPLAIN query plans. It's also open sourced on GitHub and can be embedded into your own web applications.
- Best Practices for Bulk Optimization of Queries in PostgreSQL
No mention of https://explain.dalibo.com/ ?
- PEV2: PostgreSQL Execution Plan Visualizer
Created an issue on the repo suggesting it: https://github.com/dalibo/pev2/issues/652
Hopefully that goes ok. :)
- Retrieving the latest row per group from PostgreSQL
This runs in about 250ms. Let's have a look at the explain plan to understand it better. To visualise it, I am using the excellent visualisation tool from Dalibo.
- Pg_hint_plan: Force PostgreSQL to execute query plans how you want
The PEV2 is open source and give you a good visualization. I never used this pgmustard to compare.
https://explain.dalibo.com/
- Efficient Database Queries in Rails: A Practical Approach
Visualize Your Plan: Visit explain.dalibo.com and paste the generated plan text and query. Then, hit Submit. The tool will generate a visualization of your query plan. Here's an example of the visualization for the fifth attempt version of the query from this post. It shows the different types of scans that were used and how the data gets combined. The duration of each operation is also shown:
- What's new in the Postgres 16 query planner (a.k.a. optimizer)
You can download the whole analyzer as a simple html file and use it this way. No need to obfuscate or sanitize anything at all.
https://github.com/dalibo/pev2
- Visualizing and understanding PostgreSQL EXPLAIN plans made easy
What are some alternatives?
When comparing awesome-db-tools and pev2 you can also consider the following projects:
Replibyte - Seed your development database with real data ⚡️
hypopg - Hypothetical Indexes for PostgreSQL
awesome-dbdev - Awesome materials about database development.
cloudbeaver - Cloud Database Manager
vscode-tips-and-tricks - Collection of helpful tips and tricks for VS Code.
sysbench - Scriptable database and system performance benchmark
SurveyJS: Build JSON-Driven Surveys and Forms with Full Data Control
Add the SurveyJS UI components to your JS app (React/Angular/Vue3). Securely collect and analyze data without sending it to 3rd-party servers. Fully customizable, works with any backend, and ideal for data-heavy apps. Learn more.
surveyjs.io
featured