Show HN: No-Code SQL Builder

craftsql.com

15 points·craftsquick··6 comments

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/

Open articleView on HN

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.

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!

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

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

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.

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 :)

Reply on news.ycombinator.com