AIHelperBot
p/ai-helper-bot
AI generates, explains and optimizes SQL/NoSQL queries
Lasse
AI SQL BOT — AI Bot writes SQL statements (& more) for you in seconds ⚡️
Featured
5
AI BOT writes simple or complex SQL statements for you in seconds (no SQL knowledge required). It prevents unnecessary time-wasting and enhances your problem solving capabilities using cutting-edge AI ⚡️
Replies
Best
Luis Carlos Moyano Medina
Congratulations! Looks like a very interesting project. I have two questions: - Does it work with "weirder" queries? let's say coalescing, nested queries, querying inside a jsonb field, etc... - Is there any chance fro this to become an IDE extension? I use cloud9 which makes educated guesses but fails miserably whenever I write SQL queries Thanks a lot!
Lasse
@luis_carlos_moyano_medina Thanks. 1): I ran a few complexer requests where AI Bot generated nested queries. Both "find second highest salary of employee" and "find duplicate rows in posts" generated nested queries. I will investigate this further and add it to the "How To". 2): I was considering a Chrome extension, but IDE extension could be a good idea too.
Lasse
Hi guys, AI technology (OpenAI in this case) has matured a lot in the last few years and is now at a point where it reliably can write high-quality SQL statements based on a regular sentences. You merely have to describe what you want and AI Bot will synthesize the correct SQL statement for you ⚡️. AI Bot helps: 👉 beginners or users who don't use SQL often to write high-quality and specific SQL statements in no time 👉 advanced users who need complex SQL and want to avoid wasting time googling for answers Main benefits: ✅ AI Bot turns a simple sentence into a SQL statement (e.g. "posts including comments and authors from current year" becomes an SQL statement in seconds) ✅ AI Bot enables you to solve problems confidently, creatively, and quickly ✅ AI Bot boosts your productivity Currently support: SQL, PostgreSQL, MySQL, MongoDB, GraphQL. Coming soon: Excel/Google Sheet formulas, Github Action Config. Anything you wish to see here? What you guys think? 🙂
Shushant Lakhyani
SQL devs are gonna love this one
Lasse
@shushant_lakhyani I am currently exploring how advanced SQL statements AI Bot is capable of creating from natural language sentences and the preliminary test are promising. It does simple SELECT, JOINS and so on without issue, but complex query logic like "user with the second highest score who was created current year" also isn't a problem.