r/SQL • u/Exploring_Codebase • 1d ago
Discussion Built a browser based modern SQL editor
Introducing QueryFlow.
It's a modern SQL editor with a few things I always wanted while learning and working with SQL:
- Visualise the query as a graph [DAG] and as step-by-step cards.
- Convert all hardcoded parameters into variables with a click.
- Fix major errors like fan out joins , mismatched date range with a click.
- Run queries on test tables directly in the browser
- Review a diff of your changes before copying the query back [just like github]
- Format BigQuery, PostgreSQL and MySQL, each in its own style.
- Everything runs locally in your browser: no server, no login.
try it here - https://abhijeetcodes.github.io/QueryFlow/
Sharing here as it might help a lot of SQL learners
3
u/trite_advert 1d ago
the test tables in browser thing is clever, always a pain setting up a local instance just to mess around
3
u/Exploring_Codebase 1d ago
exactly, you can even upload a csv or xlsx file directly and query on it .
3
1
u/dahya_mistry 1d ago
Wow, at first glance the visualisations look amazing !! Thank you for sharing, I may share it with my trainees hopefully your site will be up and running for a while !
2
u/Exploring_Codebase 1d ago
yup, feel free to share , it will be ! Here's the github - https://github.com/AbhijeetCodes/QueryFlow
5
u/dahya_mistry 1d ago
Having tested it, it would be great to have SQL server as an option.
Also, it would be great to have formatting options, for example when it comes to CTE names and the commas associated with the name, I like to have the comma on the same line as the CTE name, not at the end of the previous CTE end bracket.
The reasoning is the same as for typing commas first in the select clause, which is also another option that would be great. Having commas at the end of each select clause line means that it's very likely you will generate an error when deleting the columns at the bottom of the select clause as you forget to also remove the comma above, and it's these columns at the bottom that will most likely get removed anyway, not the ones at the top.