Menu

Letting AI agents query production databases without giving them a database account
📰

Letting AI agents query production databases without giving them a database account

DEV Community: database·Yasin YAMAN·1 day ago
#fyeZVSAj
#devtodatabase#devto#dev#truejoin#model
Reading 0:00
15s threshold

The problem

Once a company has an AI assistant, someone asks whether it can answer questions over production data. I do data consulting for companies that keep everything on-premises, and I kept hearing that question.

The usual answer is a read-only database account plus a text-to-SQL prompt. That leaves three things unsolved:

The account sees every row. Other tenants, other regions and personal data are all in reach.

The model writes joins from column names it has to guess at.

Nobody can say afterwards who read what.

I built Truejoin to close those three, on your own servers, with Oracle and SQL Server included.

What Truejoin is

Truejoin is an open-source (Apache 2.0) data gateway.…

Continue reading — create a free account

Join HashtagPLUS to read full articles, follow hashtags, vote, and join the conversation.