Hacker News Board Hacker News, browsed like a classic message board
Live data from Hacker News

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

logicloop.com

Post reply on HN
Print view View original

51–60 of 65 posts

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

#51

Post by topthendown »

pxue wrote: post #45

Unfortunately, we had a recent discussion internally amongst the execs and have decided to not allow anyone use tools like this. There's just no way to know for sure how securely data are stored and what possible attack vectors are. It's a great idea but imho the only path forward is allowing custom deployments against pretrained models.

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.

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

#55

Post by Fire-Dragon-DoL »

topthendown wrote: post #51
pxue wrote: post #45

Unfortunately, we had a recent discussion internally amongst the execs and have decided to not allow anyone use tools like this. There's just no way to know for sure how securely data are stored and what possible attack vectors are. It's a great idea but imho the only path forward is allowing custom deployments against pretrained models.

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

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

#56

Post by pxue »

topthendown wrote: post #51
pxue wrote: post #45

Unfortunately, we had a recent discussion internally amongst the execs and have decided to not allow anyone use tools like this. There's just no way to know for sure how securely data are stored and what possible attack vectors are. It's a great idea but imho the only path forward is allowing custom deployments against pretrained models.

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.

Db schemas sometimes contain important information themselves, as well as proprietary architecture.

I see it same as slack leaking private channel names.

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

#57

Post by akisej »

chatmasta wrote: post #33
skilled wrote: post #30

This seems like spam. The blog is mostly ChatGPT generated content by authors who have no bio's or profile pictures. The pricing is absolutely out of this world. Particularly if you consider that most of the legwork is done by the OpenAI API anyway.

The submitter is active in the comments and has a long history of submissions related to similar ideas. That seems to indicate to me that this is a real project and an iteration on a premise they've been thinking about for a long time. I do notice even their comments follow a suspiciously GPT-like template with three bullet points. But even if they're using GPT to generate the comments and blog posts, is that really…

Appreciate the vouch, @chatmasta! I actually did write those comments myself, and think that the 3-point explanation makes for a clear explanation. My cofounder and I both started our careers as software engineers, and I've been in the data space for over a decade.

A quick Google search for LogicLoop will also show you that we're both featured on Forbes 30 Under 30, and are funded by Tier 1 Silicon Valley VCs. https://www.forbes.com/profile/logicloop/?sh=67ca2b047a89

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

#58

Post by akisej »

xisun wrote: post #46

The concept looks great. One comment here will be easier flow in the suggestion bit. Instead of letting user input for suggestion on the sql improvement, perhaps doing it with a button click, and with sql automatically populated for each suggestion, without another round trip letting user "ask AI for giving me the queries" in the text input.

That's a great idea for future improvements, thank you for trying it out!

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

#59

Post by akisej »

panamaniac wrote: post #28

Pretty cool if you have all your business data centralized. But for business users, it could be useful to do something similar directly with APIs of the tools they use (e.g. SFDC, Gainsight, NetSuite, etc.). Is that in the roadmap or are you familiar with another tool that does that?

Yes, we can actually connect to third-party apps via APIs https://docs.logicloop.com/data-sources/supported-data-sourc...

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

#60

Post by akisej »

blyang wrote: post #32

The demo video really just seems like a form input for something I could already just type into ChatGPT myself. Maybe it's because I'm not a LogicLoop user with the integration, but this doesn't seem all that useful nor novel as a standalone product.

Yup, our bet is that people are going to want better integration into data sources and actions resulting from their queries, and that a lot of business value will come from that.
Post reply on HN