Live data from Hacker News

Show HN: AI SQL Copilot LogicLoop – AI to Generate, Optimize and Debug SQL

logicloop.com

61–65 of 65 posts

Re: Show HN: AI SQL Copilot LogicLoop – AI to Generate, Optimize and Debug SQL

#61
post #29

Congrats on the launch! We built something similar a few months ago but couldn't get the quality of the SQL generation to be that good without providing a ton of few-shot examples, especially with databases that contained more bespoke data. If you have enough few-shot examples the quality might be quite good!

Thanks for sharing your experience. By organizing and storing queries, we hope to be able to improve these suggestions as well behind the scenes.

Re: Show HN: AI SQL Copilot LogicLoop – AI to Generate, Optimize and Debug SQL

#62

This is great, but how is your performance on multi-table joins? We've been working on a homebrew solution using OpenAI internally conditioned on our schema, and can't bridge the multi-table gap. Also I'm skeptical if this generalizes, do you have measures in place to prevent query hallucination?

On simpler multi-table joins we've been able to product good results, and we've done a lot of prompt engineering to make sure it takes the schema very seriously so that prevents hallucinations too. We're always finding new edge cases and fixing those as we go.

Re: Show HN: AI SQL Copilot LogicLoop – AI to Generate, Optimize and Debug SQL

#63
post #49

It's against HN's rules to have promotional upvotes and/or comments in the threads. Especially not promotional comments. I suppose your friends were just trying to help you out, but HN users are acutely sensitive to this and consider it spamming. They're not entirely wrong, either, because the upvotes and comments we're talking about were not organic. We want genuine, curious conversation here, and this is not that.…

Thanks for sharing how you keep the discussion quality high here. We responded to some thought-provoking questions on this thread about differentiation vs ChatGPT, other SQL Copilots, edge cases like more complicated queries etc. that we believe other HN users and makers in this space will benefit from. As I responded in @chatmasta's vouch (thank you!), we're data and software engineering experts, and happy to provide our original perspective on any other questions you have for us. Thanks for your consideration!

Re: Show HN: AI SQL Copilot LogicLoop – AI to Generate, Optimize and Debug SQL

#64
post #63
post #49

It's against HN's rules to have promotional upvotes and/or comments in the threads. Especially not promotional comments. I suppose your friends were just trying to help you out, but HN users are acutely sensitive to this and consider it spamming. They're not entirely wrong, either, because the upvotes and comments we're talking about were not organic. We want genuine, curious conversation here, and this is not that.…

Thanks for sharing how you keep the discussion quality high here. We responded to some thought-provoking questions on this thread about differentiation vs ChatGPT, other SQL Copilots, edge cases like more complicated queries etc. that we believe other HN users and makers in this space will benefit from. As I responded in @chatmasta's vouch (thank you!), we're data and software engineering experts, and happy to provid…

The problem is that most of the upvotes and many of the comments on this post were completely inorganic. They were done by people trying to help promote your thread.

I'm not talking about the replies you posted; I'm talking about top-level comments that appeared to be organic and actually weren't.

If you didn't ask friends/fans/users to upvote or comment, or pass a link around (which is usually interpreted as such a request), then someone else did. No doubt they were trying to "help" you. Whoever it was, they need to understand that on HN, it doesn't help, it hurts. It's against HN's rules and we ban accounts and sites that do it. It's also something that the community here is extremely vigilant about and considers spamming.

If you don't want to get banned, and/or flagged and flamed by HN users, you should make sure this doesn't happen again.

Re: Show HN: AI SQL Copilot LogicLoop – AI to Generate, Optimize and Debug SQL

#65

Earlier quoted context omitted.

According to docs it only takes in your data schema and outputs the SQL query to run, so the AI model doesn't actually get information about your data, just the schema. Otherwise data is handled according to SOC II principles similar to any other BI tools.

Doesn't this penalize the tool though? Knowing the amount of data in a table is still important to determine the type of query, even more to optimize it

Yeah, in general the more data you're able to use (assuming the context window supports it), the better results tend to be. We arrived at the data schema being a good enough compromise at which the benefits outweigh the risks for several use cases. Besides, some data stores that are generated by third-parties actually have common schemas (think Sendgrid / Hubspot activity data), so you're not risking much but potentially gaining a lot of sales ops productivity.
Post reply on HN