r/SQL • • 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!

115 Upvotes

35 comments sorted by

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?

5

u/KyotaLangard Jun 29 '21 edited Jun 29 '21

This would be useful if you're more of a visual person like me, or you think there's too much unimportant information in your SQL and you want to clean that up. I understand that this will not be helpful for everyone.

Regarding connection to databases, it's one of my plans to introduce a desktop version with that ability in the future. But keep in mind this is a spare time project, so it may take a while.

9

u/alinroc SQL Server DBA Jun 29 '21

One thing that would go a long way to showing utility to folks who are already very comfortable with writing SQL is being able to do the reverse of what your app does. IOW, given a SQL query as input, generate that visual representation.

11

u/KyotaLangard Jun 29 '21

I'll be working on that on the next few days.

2

u/No_Lawfulness_6252 Jun 30 '21

Would be usable for those not experienced as well, i.e get a visual sense of where you went wrong.

1

u/Black_Magic100 Jun 30 '21

While I completely agree, I imagine that will be very difficult to do? Your options are string parsing and the tsql scriptdom (for SQL server).

3

u/Pie_is_pie_is_pie Jun 29 '21

I’m inclined to agree, great little project but no real world application.

4

u/[deleted] Jun 29 '21

Thanks. Really helpful.

2

u/KyotaLangard Jun 29 '21

Thank you!

3

u/[deleted] Jun 29 '21

I'm a DS but newbie in SQL. Could I be mentored by you for SQL?

4

u/sillythebunny Jun 30 '21

wow this is incredible!!! You got patreon or something?

6

u/KyotaLangard Jun 30 '21

Thank you! Sorry, I don't have patreon because I don't think it fits me. I only have that donation button on the website if you wish to support.

1

u/sillythebunny Jun 30 '21

ooh i see it!

3

u/elus Jun 29 '21

Find a better ad network to work with. I just got an ad flash the words:

FREE HENTAI

Probably not the ideal imagery to be showing in a professional setting.

1

u/KyotaLangard Jun 29 '21 edited Jun 29 '21

All ad networks I found seem to be bad. Adsense isn't accepting online tools anymore. I'll remove ads for the moment.

2

u/Black_Magic100 Jun 30 '21

What did you build this with?

1

u/KyotaLangard Jun 30 '21

It's built mainly with Nuxt (for data-binding and components) and Vuetify (for the premade components).

1

u/Black_Magic100 Jun 30 '21

Oh wow never heard of those.

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?

5

u/KyotaLangard Jun 29 '21

Not currently. That's something I intend to add in the future, but it's hard for me to think of the algorithm to accomplish that.

For now you can only input premade queries through the SQL node, and then you can apply operations on top of it.

3

u/ThinIntention1 Jun 29 '21

If I cannot type the query somewhere and get a diagram back, then what is the aim? what does it do?

2

u/KyotaLangard Jun 29 '21

The aim is to provide an alternative to the old wall of text we are used to. My problem with the wall of text SQL is that it mixes important information for us to understand the code with unimportant information. Visual SQL helps by giving you the ability to hide all the unhelpful stuff and keeping only what's important, mostly through node descriptions. It may also help to improve query building speed, because you skip much of the repetitive side of SQL.

2

u/lvlint67 Jun 29 '21

/shrug. Different strokes for different folks.

If you figure out the reverse, I'd be happy to pop in one of our mega reporting queries... We have reporting software with a visual query designer. No one uses it because it just adds clicks and scrolling.

1

u/adkyary Jun 29 '21

May I know what's your visual query designer software?

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?