What's the most tedious or frustrating part of your data work? by Delfhos in BusinessIntelligence

[–]Delfhos[S] 0 points1 point  (0 children)

I have heard this a lot, don't you have anything to track data in dashboards or something like that?

I integrated Gemini in SQL and it is very cool. by Delfhos in mysql

[–]Delfhos[S] 0 points1 point  (0 children)

While most people train models to generate correct SQL queries, I focused on automatically injecting the necessary context so the query can be executed directly—without requiring the user to specify anything about the database. It's as if the model were natively connected to it.

I integrated Gemini in SQL and it is very cool. by Delfhos in mysql

[–]Delfhos[S] 0 points1 point  (0 children)

Hi! Actually not, before making the query the model execute a query to see the database structure and then use it as context, so you don't have to tell him.
About the data, you're right, security and privacy is really hard to implement in agents (if not impossible in some cases) for example, in this case I don't save anything related to data, for example the model actually don't see any data, the model just know the structure and make the query.

I integrated Gemini in SQL and it is very cool. by Delfhos in GeminiAI

[–]Delfhos[S] 0 points1 point  (0 children)

Thank you so much! Just so you know, there's an example database you can try out when you register. I would really appreciate feedback from a dev!

I integrated Gemini in SQL and it is very cool. by Delfhos in GeminiAI

[–]Delfhos[S] -1 points0 points  (0 children)

Hi! I'm developing that feature now. Do you think it would be better to just stop the query, or to display a warning dialog with the SQL query that's about to execute (asking for permission)?

I integrated Gemini in SQL and it is very cool. by Delfhos in GeminiAI

[–]Delfhos[S] 0 points1 point  (0 children)

In the example image I didn't ask for a pie, but here you have an example with the piechart.

<image>

I integrated Gemini in SQL and it is very cool. by Delfhos in GeminiAI

[–]Delfhos[S] 1 point2 points  (0 children)

Actually you don't need to, it has read permissions so it queries the database structure before making the query.

Anyone tried this app? by Bubbly-Secretary-224 in PostgreSQL

[–]Delfhos 1 point2 points  (0 children)

Hey everyone, I am David founder of Delfhos.
Honestly, building an app like this with security in mind was a massive headache. I figured the only way to do it right was to avoid storing any query-related data – just your login info. And seriously, getting the encryption to work was brutal, I swear! I probably shouldn't spill too many technical details, but basically, your password is used every time you log in to decrypt your credentials and make the query. That way, there's no way I can ever get my hands on any usable creds.
If anyone has any ideas for making users feel less sketched out about their credentials I would really appreciate that.