1259-UC Production Data Access Architecture for AI Agents Using a Proxy Layer Approach

Organizations increasingly rely on data to support business operations, evaluate performance, and make informed decisions. Traditionally, accessing and analyzing organizational data has required users to understand database structures, write SQL queries, or rely on specialized reporting tools and technical personnel. However, the development of AI and LLMs have offered possibilities for making data interaction possible as users no longer need to have specific tools to write queries and reports. They can now ask their questions in everyday language and receive meaningful responses. This transition provides the opportunity for AI-based reporting agents to serve as conversation interfaces to an organization’s data. Therefore, AI-powered reporting agents make accessing organizational information easier and lower the difficulty of traditional reporting methods. The purpose of this project is to design an AI-driven reporting agent that enables employees and managers to get the relevant organizational information by making use of conversational interface. In this proof of concept, there is a Gradio-based front-end, Python backend, and OpenAI’s GPT-OSS-120B model through the Groq Cloud API, and a PostgreSQL database. A primary consideration throughout development is protecting the database from unrestricted AI access. If the AI agent is given direct access to the database, it would be possible to expose sensitive information and create opportunities for unauthorized retrieval of data and unintended operations. To address these risks, the project heavily focuses on an intermediary API proxy that will include various role-based access controls and limitations on database operations. This approach is intended to ensure that requests made by the AI model to the database are properly validated and limited to available functionality.

Authors

Publication Details

Journal
DigitalCommons - Kennesaw State University (Kennesaw State University)
Published
2026-11-20
Primary Topic
Access Control and Trust
Type
article
Field-Weighted Citation Impact
0.00
Controls
|||
ALL TIME
JAN
FEB
MAR
APR
MAY
JUN
JUL
AUG
SEP
OCT
NOV
article

1259-UC Production Data Access Architecture for AI Agents Using a Proxy Layer Approach

Cam Dixon, Robert Russel, Janeil Chambers, Ambar Conde et al.
DigitalCommons - Kennesaw State University (Kennesaw State University)
Access Control and Trust
article

1259-UC Production Data Access Architecture for AI Agents Using a Proxy Layer Approach

Cam Dixon, Robert Russel, Janeil Chambers, Ambar Conde, Junaid Mohammed
article en

Abstract

Organizations increasingly rely on data to support business operations, evaluate performance, and make informed decisions. Traditionally, accessing and analyzing organizational data has required users to understand database structures, write SQL queries, or rely on specialized reporting tools and technical personnel. However, the development of AI and LLMs have offered possibilities for making data interaction possible as users no longer need to have specific tools to write queries and reports. They can now ask their questions in everyday language and receive meaningful responses. This transition provides the opportunity for AI-based reporting agents to serve as conversation interfaces to an organization’s data. Therefore, AI-powered reporting agents make accessing organizational information easier and lower the difficulty of traditional reporting methods. The purpose of this project is to design an AI-driven reporting agent that enables employees and managers to get the relevant organizational information by making use of conversational interface. In this proof of concept, there is a Gradio-based front-end, Python backend, and OpenAI’s GPT-OSS-120B model through the Groq Cloud API, and a PostgreSQL database. A primary consideration throughout development is protecting the database from unrestricted AI access. If the AI agent is given direct access to the database, it would be possible to expose sensitive information and create opportunities for unauthorized retrieval of data and unintended operations. To address these risks, the project heavily focuses on an intermediary API proxy that will include various role-based access controls and limitations on database operations. This approach is intended to ensure that requests made by the AI model to the database are properly validated and limited to available functionality.

DigitalCommons - Kennesaw State University (Kennesaw State University)
Access Control and Trust
AI Navigator

Ask Laika to Summarize, Analyze, and Connect papers live on the map.

Summarize Papers & Methodologies

Extract key findings, datasets, and comparative methods across publications.

Benchmark Rankings & Visual Analytics

Rank top research institutions, authors, funders, topics, and journals by Field-Weighted Citation Impact (FWCI) and paper volume with instant charts.

Connect Distant Disciplines

Bridge topological clusters on the map to find hidden collaborative intersections.

Laika access coming soon
1259-UC Production Data Access Architecture for AI Agents Using a Proxy Layer Approach — Cam Dixon, Robert Russel, et al. · DigitalCommons - Kennesaw State University (Kennesaw State University) (2026) | TGRS Research Map | TGRS