← Back to profile View diagram ↓

Conceptual design · 9 views of the implemented system

Intelligent Agent for Automated Reporting over Relational Databases

Python · SQLAlchemy · Gmail Client · MySQL · SQL Server · PostgreSQL · Oracle. An LLM-driven agent that receives natural-language report requests, resolves them into read-only SQL, and delivers rendered reports — under strict administrative and security segmentation.

Diagram views

09

Actor roles

03

DBMS supported

MySQL · MSSQL · Postgres · Oracle

DB access policy

SELECT only

Core of every view — the system under design

Intelligent Agent System

The LLM agent never touches the database directly. Every request passes through the Database Query Gateway, which is the sole component holding credentials and the sole issuer of read-only SELECT statements against the relational DBMS. This separation is what all nine views describe from different angles.

Click any diagram view to expand its contents

Legend

Actor — human role interacting with the system
Intelligent Agent System — LLM reasoning layer
Database Query Gateway — sole credential holder
Relational DBMS — read-only data source
Administrative domain — configuration and control
Reporting domain — rendering and delivery
Decision point — validation or branching
Denied / blocked path — rejected by policy

Full diagram — click to enlarge

↑ Go Top
↑ Go Top