Chat With Your SQL Database Using LLM

adrelien@lemmy.radio to Technology@lemmy.world – -32 points –
Chat With Your SQL Database Using LLM
adrelien.com

Unlock the power of LLMs like ChatGPT and Ollama to effortlessly query and analyze your SQL database using natural language. Learn to set up and use LangChain for complex queries, making data-driven decisions easier and accessible to all, even without technical expertise.

13

Misread the summary to say data driven delusions and that seems accurate.

Put my entire dataset into an LLM so whoever developed the LLM can steal it and use it for training? No. Thank. You.

massive security / data protection issue.

Both langchain as well as ollama run locally and are open source.

To be very frank: your post sounds like fear mongering without having even clicked on the link.

I did read the article. Do you arbitrarily trust any code you run locally without reviewing it?

I have reviewed the tiniest fraction of code that I have ever used.

$  dpkg -l|wc -l
4526
$

That's about 4500 software packages I have installed on one Linux system, to say nothing of other computing devices I've used or the other packaging systems in use on this system alone. I have probably looked at any portion of...I don't know, maybe 20 of those? And that's to work on a small portion of any one's codebase, certainly not to audit the software package.

Nobody using any kind of a remotely normal and modern computing environment, even if they are a software developer and know at least one programming language used by some of the software on their system and if they have the relevant domain knowledge to assess security concerns, has the realistic ability to conduct a review of the code that runs on their system, even in environments, like Linux, where the code is available.

It's like asking a mechanical engineer to validate the design correctness of every mechanical device they've ever used prior to using it.

So yes, is the answer. No matter the code; you happily run it

Are you trying to tell us that before installing anything on your computer, you read every single line of code in Ghidra? You must be a Gentoo user.

if you review the source of everything you run, you must have a very stressful life

1 more...
1 more...
1 more...
1 more...
1 more...

Just learn the syntax? It's not super complicated, and the whole reason we have strict syntax is because you can't reliably convey intent without it.

Or build a better front end.

And their directions for setting this up are vastly more complicated than a basic SQL query.

There's almost nothing I want less than chatting with my database(s). These people are desperate.

I mean you kinda of looking at from the wrong way, In the company I work for, it was a time saver. A department of engineers in embedded systems can upload some measurements then another department can quicky run some questions to write the findings for a customer. They both don't know anything about SQL and ti is even faster than the tool we built for them. Since they have to filter through 1TB of data. Yes it needs a lot of optimization to get it perfect.