6 ms·
Show HN: No-Code SQL Builder
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/ https://craftsql.com/
- mritchie712 4y agoWhy 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 agoThe 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 agoWow , a lot got done in one weekend. Could you please share which framework/libraries/tools you use to build it ?
- craftsquick 4y agoThanks! Frontend: React/Redux and React Flow (for the graph) Backend: Node and Knex.js (for the query generation)
- dirslashls 4y agoNice 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 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 agoYou should be able to build every SQL query with this. I built an example Top-N query here: https://imgur.com/a/2xKLltl 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 :)