Read-only by design
The agent cannot modify data, even if asked.
Our own cores
AI data query agent
Questions in plain language, answers from your databases.
.NETAngularPrimeNGPostgreSQL
The challenge
Business teams depended on the technical team for every database query. Giving direct access was risky, and using AI without control could expose sensitive data or run dangerous queries.
How we solved it
We designed an agent that interprets the question, builds a reviewable query plan and runs it read-only, enforcing permissions down to the column. It is installed on the client’s infrastructure, so data never leaves the company.
Architecture
How it is built.
Simplified view of the components and how information flows.
01
User
Plain-language question
Plan review
02
Agent
Intent & data catalog
Query plan
03
Controls
SQL validation
Permissions & masking
04
Sources
SQL Server & PostgreSQL
MySQL
.NETAngularPrimeNGPostgreSQLRedisClaudeOpenAIOllama (local models)
Technical decisions
Why we built it this way.
Reviewable plan before running
Users see what will be queried and with what confidence.
Permissions per connection, table and column
Each role sees only what it should.
Sensitive data masking
Personal or financial data is hidden according to policy.
AI provider of choice
Claude, OpenAI or local models with Ollama.
Outcome
What changed.
- Business teams query without writing SQL.
- Every query is audited with user, plan and result.
- Over two hundred automated tests back the engine.
Ready to build what’s next?
Let’s find the right solution for your business.
Tell us about your goals and one of our engineers will get back to you personally.