# AI Anomaly Investigation Agent Case Study: TNBT Tech

> Operational questions in plain language; data-backed answers without writing SQL. How DevOps TechLab built it on AWS.

- Page: https://devopstechlab.com/resources/cases/tnbt
- Last updated: 2026-11-14
- Contact: sales@devopstechlab.com · +91 90670 77200 (call or WhatsApp) · Monday to Friday, 10 AM to 7 PM IST
- This is a plain-text copy of the page above for AI tools. The page itself is the reference.

---
1. [Home](https://devopstechlab.com/)
2. [Resources](https://devopstechlab.com/resources/)
3. [Case studies](https://devopstechlab.com/resources/case-studies)
4. TNBT Tech

AI & GenAI AWS QueryDash Client story

TNBT Tech

# Unusual operational changes found and explained, without a single line of SQL

DevOps TechLab deployed an agentic AI investigation platform on Amazon Bedrock that lets TNBT Tech’s teams ask what changed in their operations and why, and receive data-backed answers, with production data protected by read-only controls.

By Janak Thakkar, Founder & CEO, DevOps TechLab Operations 5 min read

operations · metric investigating

**Unusual change found** Agent is looking for the likely cause…

“Identify unusual operational changes and determine their likely causes.”

Illustration, not client data

In short

TNBT Tech uses QueryDash, DevOps TechLab's agentic investigation platform on AWS, for operations. Staff ask in plain language to identify unusual operational changes and their likely causes. An agent on Amazon Bedrock with Amazon Nova Pro runs validated, read-only SQL and returns data-backed answers, so nobody has to write SQL.

Official references: [What is Amazon Bedrock](https://docs.aws.amazon.com/bedrock/latest/userguide/what-is-bedrock.html) · [AWS Well-Architected Framework](https://docs.aws.amazon.com/wellarchitected/latest/framework/welcome.html)

ISO 27001 · SOC 2 · Working with companies across India and abroad from Ahmedabad, in IST

## Executive summary

TNBT Tech needed a faster way to investigate its operational data and spot unusual changes or patterns. Every investigation depended on technical staff to identify the data, write SQL, run several queries and interpret the results. DevOps TechLab deployed QueryDash, its agentic investigation platform built on Amazon Bedrock, so users can ask operational questions in plain language and receive data-backed findings, with every query validated as read-only before it touches production data.

**Client:** TNBT Tech · Operations

**Business problem:** Investigating unusual operational changes meant manual SQL across many queries, run by technical staff.

**What we delivered:** An AI investigation agent (QueryDash) on Amazon Bedrock with Amazon Nova Pro, connected read-only to TNBT Tech’s operational data.

**Engagement:** Discovery, build and onboarding, then managed operations and continuous optimisation by DevOps TechLab.

**Outcome:** Teams ask operational questions in plain language and get data-backed answers about what changed and why.

## The business challenge

TNBT Tech’s traditional analysis required technical teams to manually identify the relevant data, prepare SQL, execute multiple queries and interpret the results. Complex investigations took time and depended heavily on technical resources.

### Why it mattered

- **Anomalies found late**

  Spotting an unusual change, and its likely cause, needed a technical investigation every time.
- **Dependence on a few specialists**

  Only people who could write SQL could investigate the data, so questions waited for them.
- **Many queries per question**

  A single operational question could need several queries and manual comparison of the results.
- **Causes hard to connect**

  Linking a change to its likely cause meant relating several operational data points by hand.

## What TNBT Tech set out to achieve

1. Let teams ask operational questions in natural language, without writing SQL.
2. Find unusual changes and their likely causes through multi-step analysis.
3. Return data-backed findings that people can act on.
4. Keep the context of an investigation for follow-up questions.
5. Remove any risk to production data from AI-generated queries.

## The solution: an AI investigator for operational data

Users describe the objective in plain language, for example *“Identify unusual operational changes and determine their likely causes.”* The agent interprets the objective, discovers the data it needs, generates and runs validated queries, analyses the results and decides whether more investigation is needed, recovering on its own when a query fails.

The agent loop

**Understand the goal.** The agent restates what you are trying to find out.

**Production data stays protected.** Every SQL statement is validated before it runs; write and schema-changing operations are rejected.

### Key design choices

- **Managed generative AI**

  Amazon Bedrock with Amazon Nova Pro handles reasoning and tool use. There are no models to host and no GPU infrastructure to run.
- **No servers to manage**

  The application runs on Amazon ECS on AWS Fargate behind an Application Load Balancer, so it scales with demand.
- **Works on the data where it lives**

  The agent queries the existing operational databases directly, read-only, instead of copying data into a new warehouse.
- **Investigations that remember**

  Amazon DynamoDB keeps the conversation and investigation history, so follow-up questions build on what the agent already found.

## Security and governance

For leadership, the first question about AI on production data is risk. The platform is built so that AI-generated queries never touch the database directly.

- **Read-only by design**

  Only read statements (SELECT, WITH, SHOW, DESCRIBE, EXPLAIN) are allowed. Any write or schema change is rejected before it runs.
- **Validated before execution**

  Every query the AI writes passes through a server-side validation layer. The model never has a direct line to production data.
- **Protected performance**

  Results are capped, so a broad question cannot turn into a runaway query on a production database.
- **Managed credentials**

  Database credentials sit in AWS Secrets Manager, and access is governed by AWS IAM roles, not stored in code.

## Architecture on AWS

Architecture as built (QueryDash platform)

| AWS service | Role in the solution |
| --- | --- |
| Amazon Bedrock · Amazon Nova Pro | Agent reasoning, planning and tool use |
| Amazon ECS on AWS Fargate · Application Load Balancer | Runs the investigation service without servers to manage |
| Amazon RDS (MySQL) · Amazon Aurora PostgreSQL | The business data the agent investigates, read-only |
| Amazon DynamoDB | Conversation and investigation memory |
| Amazon CloudFront · Amazon S3 | Delivers the web application securely |
| AWS Secrets Manager · AWS IAM | Credentials and access control |
| Amazon CloudWatch | Application, infrastructure and agent monitoring |

## How we delivered

1. 01 **Discover**

   Mapped the questions TNBT Tech’s users need answered, the data behind them and how it relates, and defined secure, read-only access to production.
2. 02 **Build & onboard**

   Connected TNBT Tech’s data, configured Amazon Bedrock and Nova Pro, set up read-only validation, conversation memory and real-time streaming, and tested against representative investigation scenarios.
3. 03 **Run**

   DevOps TechLab operates the service: monitoring the application, the AWS environment and the agent, supporting queries and resolving production issues.
4. 04 **Improve**

   Ongoing tuning of agent planning, query generation and recovery, plus reviews of performance, cost and security as new questions are added.

## Business outcomes

TNBT Tech’s teams now move from “something changed” to a data-backed explanation in one conversation, instead of a chain of requests to technical staff.

- **Self-service investigation**

  Teams investigate operational data themselves, in natural language, without SQL.
- **Anomalies with likely causes**

  The agent identifies unusual changes and works through the data to find their likely causes.
- **Evidence for every finding**

  Answers come with the data behind them, so teams can act with confidence.
- **Zero write access to production**

  AI-generated queries are validated and read-only, so production data is never changed by the agent.
- **Less dependence on SQL specialists**

  Fewer manual SQL investigations for technical staff, on a platform that extends to new questions.

## What’s next

Because the architecture is reusable, TNBT Tech can extend the agent to new business questions without building a separate analytics workflow for each. DevOps TechLab continues to advise on new investigation scenarios and further opportunities for AI-driven automation.

The same platform, other teams

- [**Chatwit** “Investigate why sales performance changed and guide me through the findings.”](https://devopstechlab.com/resources/cases/chatwit)
- [**Dexlyn** “Determine the main factors affecting quarterly revenue.”](https://devopstechlab.com/resources/cases/dexlyn)
- [**Trueestate** “Investigate why property bookings declined.”](https://devopstechlab.com/resources/cases/trueestate)

**About DevOps TechLab**

DevOps TechLab is an AWS Advanced Tier Services Partner with the AWS Generative AI Competency and AWS SMB Competency. We design, build and run cloud and generative AI solutions on AWS for growing businesses, with 265+ cloud environments under management.

### Want answers like these from your own data?

Share the questions your leadership team asks most often. We will show how an AI investigation agent on Amazon Bedrock could answer them, safely and read-only.

[Next story · AI & GenAI **Dexlyn: Autonomous BI agent that explains what drives revenue** Driver tree design · 2 min read](https://devopstechlab.com/resources/cases/dexlyn)

## More client stories

[**S3** automatic off-site copies Backup & DR **Dynawiild Engineering: Business data copied to Amazon S3 automatically, for disaster recovery**](https://devopstechlab.com/resources/cases/dynawiild) [Cost & security **SMB on AWS: AWS infrastructure, security and cost optimisation for an SMB workload**](https://devopstechlab.com/resources/cases/smb-optimisation) [AI & GenAI **Spotem: Visual product search: upload a photo, get similar products in seconds**](https://devopstechlab.com/resources/cases/spotem)

Keep exploring

## The work behind this story

- [Service **AI consulting services** Assistants, chatbots and agents on Bedrock, Azure OpenAI or Vertex AI.](https://devopstechlab.com/solutions/generative-ai-data/)
- [Partner **AWS partner in India** Advanced Tier Services Partner with SMB and Generative AI Software Competencies.](https://devopstechlab.com/partners/aws/)
- [Case study **AI BI agent case study** Dexlyn: an agent that explains what drives revenue.](https://devopstechlab.com/resources/cases/dexlyn)
- [Case study **Real estate AI analytics agent** Trueestate: why bookings dropped, with the evidence shown.](https://devopstechlab.com/resources/cases/trueestate)

FAQ

## Questions about the TNBT Tech operations agent

**Still have a question?**

Send it with the form below and an engineer will reply.

Ask us

###

It restates the goal, plans the steps and finds the relevant tables. It then writes SQL, validates it as read-only, runs it and analyses the results, replanning until it can explain the likely cause.

The agent runs on Amazon ECS Fargate with Amazon Bedrock and Amazon Nova Pro. A React app sits on CloudFront and S3, with memory in DynamoDB, credentials in Secrets Manager and monitoring in CloudWatch.

No. Every SQL statement is validated before it runs, and write or schema-changing operations are rejected. The agent only reads production data, so operational records stay as they are.

Yes. Follow-up questions keep the context of the investigation. The agent runs multi-step investigations, recovers from failed queries and shows the evidence behind each of its findings.

DevOps TechLab monitors the application, infrastructure and agent, and provides query support and troubleshooting. It also keeps tuning how the agent plans, generates SQL and recovers from errors.

Talk to an engineer

## Start with a 20-minute review. Leave with a plan.

An engineer looks at your current setup, points out what’s costing you money or risk, and tells you what we’d fix first. No sales deck, no obligation to go ahead.

[Sales and general enquiries **sales@devopstechlab.com**](mailto:sales@devopstechlab.com) [Call us **+91 90670 77200**](tel:+919067077200)

Every month you wait, the bill grows, the audit gets harder and the AI project waits another quarter.
