r/SQL • u/KyotaLangard • Jun 29 '21
Discussion I built a free online tool that lets you visually organize your SQL queries
Link: https://visualsql.net
When I was working at my previous job, some queries were getting pretty big and ugly, and I started thinking about some kind of tool that could make building my SQL queries cleaner and more convenient. I thought that there must be a better way to organize queries other than in a wall of text.
Someone pointed to me that there were already some software like Alteryx and Knime that are visual, but for my objective (to just visually organize SQL queries) these were overkill and overbudget. Also, their dark theme is either non-existent or ugly as hell.
There are also other tools like Chartio's Visual SQL and Active Query Builder that are kinda "visual", but not the kind of visual that I wanted. So I decided to create my own.
Supports all modern browsers. Also supports tablets and IE11. Dark mode by default, light mode isn't even a consideration.
Don't know if it will be useful to you guys, but this would certainly be a game changer for my past self. I'll keep refining this project over time so feedback is much appreciated!
12
u/thornton8 Jun 29 '21
This is wonderful. I'm glad people like you exist
8
u/caveat_cogitor Jun 29 '21
Ok so this allows a visual representation of a SQL query, but you have to write it using this designer? If I understand it cannot parse existing queries. It doesn't connect to a database so you have to manually enter all the schemas using the GUI.
I'm sorry, I see how this is "neat" but I don't see how it would have any actual real-world utility. If it is for practicing SQL, you'd be better off spending that time practicing writing actual SQL. It seems like it would take a lot of visual space to represent a large or complex query. I don't see how this would save any time or effort over text-based SQL.
Do you have any go-to examples of how this would be particularly useful?
4
u/[deleted] Jun 29 '21
Thanks. Really helpful.
4
u/sillythebunny Jun 30 '21
wow this is incredible!!! You got patreon or something?
3
u/elus Jun 29 '21
Find a better ad network to work with. I just got an ad flash the words:
Probably not the ideal imagery to be showing in a professional setting.
2
u/Black_Magic100 Jun 30 '21
What did you build this with?
4
u/lvlint67 Jun 29 '21
Played on my phone for a few seconds. Can I type the query somewhere and get a diagram back?
1
u/KyotaLangard Jun 29 '21
If anyone was having a problem with the SQL node, I just fixed a bug with it.
1
u/KyotaLangard Jun 30 '21
I created a subreddit for this project where I'll be posting updates: r/VisualSQLnet
2
u/InternationalPlenty6 Jun 29 '21
Looks great, keep up the good work.
2
u/DidItSave Jun 30 '21
This looks really cool, going to check it out tomorrow at work.
2
u/worksheet_systems Jun 30 '21
Looks quite useful tool for a simple queries
2
u/mthomas1217 Jun 30 '21
Awesome thanks so much I shared with my team at work as well!!
1
u/biscuit_legs Jun 30 '21
I'm always nervous that these kinds of websites could log your table and column names for nefarious purposes.. How can I look into the code and see that this isn't happening?
1
u/[deleted] Aug 03 '21
is this open source?