AI agents accessing production data

Post by Eapz_06 » Tue, Jul 07, 2026, 9:20 PM UTC

gnat wrote: post #9

Eapz_06 wrote: post #6

Earlier quoted context omitted.

Thank you so much... One doubt I have is when we expose tools instead of this raw sql, how do ensure that agents are using the correct data like right source and not stale. Do we have to enforce some checks manually or is it not worth to worry(now it's read only right). And one more doubt, what's the reason u introduced a lite layer in between?

I’m dealing with invoices and customers and timesheets and tickets. I didn’t want to give an agent SQL access to the database for performance and security reasons, and we don’t have a read only replica (which would have been much more acceptable to give read access to). So my tools are get_invoices etc. and they pull data into the SQLite. My use case is a short conversation to answer a question like “has all the time…

Post by tomarai85 » Wed, Jul 08, 2026, 4:19 AM UTC

gnat wrote: post #9

Eapz_06 wrote: post #6

Earlier quoted context omitted.

Thank you so much... One doubt I have is when we expose tools instead of this raw sql, how do ensure that agents are using the correct data like right source and not stale. Do we have to enforce some checks manually or is it not worth to worry(now it's read only right). And one more doubt, what's the reason u introduced a lite layer in between?

I’m dealing with invoices and customers and timesheets and tickets. I didn’t want to give an agent SQL access to the database for performance and security reasons, and we don’t have a read only replica (which would have been much more acceptable to give read access to). So my tools are get_invoices etc. and they pull data into the SQLite. My use case is a short conversation to answer a question like “has all the time…