Show HN: No-Code SQL Builder (craftsql.com)

Hey everyone!

I built a tool to help you visually build SQL queries - if you write a lot of SQL at work (or help people write it), check it out!

You can try it out without needing to sign up, or integrate with any databases.

Would love all your thoughts!

Link: https://craftsql.com/

6 comments

[ 4.7 ms ] story [ 24.5 ms ] thread

mritchie712 4y ago ↗

Why did you decide not to connect to the database and pull the schema info automatically? If you don't want to connect, you could write a query against the information_schema to give to your users to run and paste the results back into craft.

craftsquick 4y ago ↗

The primary reason was that this was built in one weekend! The information_schema query is a great idea actually, I'll build that in -- thank you!

ano88888 4y ago ↗

Wow , a lot got done in one weekend. Could you please share which framework/libraries/tools you use to build it ?

craftsquick 4y ago ↗

Thanks! Frontend: React/Redux and React Flow (for the graph) Backend: Node and Knex.js (for the query generation)

dirslashls 4y ago ↗

Nice work and great use of React Flow.

What level of sophisticated queries can be created with it? For example, can it do "Top N and Other"? Which BTW, was recently added for SQL Frames ( https://sqlframes.com/docs/data_sets/top_n_other_sets )

Most of these visual SQL builders I have seen only tackle the basic level of SQL. I am interested in an advanced SQL builder myself to plug as a no-code SQL builder to front the SQL Frames API.

craftsquick 4y ago ↗

You should be able to build every SQL query with this. I built an example Top-N query here: https://imgur.com/a/2xKLltl

Right now building Top-N (and my example) assumes you know the rank function exists, but over time it should be easy enough to pre-build "nodes" that do things like this automatically :)