Home · Our Work · Local-LLM Graph API Agent
Case Study  ·  Local LLM  ·  Tool Use

Local-LLM
Graph API Agent

Identity visibility should not require knowing Microsoft Graph internals. Ask a plain-English question. The agent writes the query, executes it against live Entra ID data, and returns the answer.

Ollama / qwen2.5:7b Microsoft Graph API Tool-Calling Agent Entra ID Auditing Local LLM Architecture Live Identity Data
Ask.
Identity audits reduced from script work to plain-English questions  ·  No Graph expertise required
01
The Problem

Enterprise identity environments generate a constant stream of audit questions. Which accounts are stale? Who has privileged roles? Which users bypass MFA? How many guest users exist? Which accounts haven't signed in recently? The data exists inside Microsoft Graph, but getting answers requires knowing exactly how to retrieve it.

That creates a real operational bottleneck. Most technicians do not work fluently in Microsoft Graph. They may understand the identity problem itself, but not the API structure behind it — which endpoints to call, how to authenticate, how to filter results, how to interpret nested data structures, or how to chain queries together properly. So the work falls to the handful of engineers who understand Graph deeply enough to build the query manually.

And when those engineers are busy, the audit often simply does not happen. The issue was never lack of data. The issue was query friction. Open Graph Explorer. Find the endpoint. Build the filter. Test the request. Fix the permissions issue. Parse the response. Repeat. Ad-hoc identity audits became skill-gated operational work instead of simple questions the team could ask naturally.

Specialist
Identity audits depended on technicians
who understood Graph API structure
Skipped
Ad-hoc investigations rarely happened
because writing the query took too long
Fixed
Prebuilt reports only answered
questions they were designed to answer
02
The Build

AOtech built a local-LLM Graph API agent designed specifically to remove the query barrier between technicians and Entra ID visibility. The system sits in front of Microsoft Graph behind an Ollama-hosted qwen2.5:7b model running locally. Instead of requiring technicians to understand Graph query syntax, the agent accepts plain-English identity questions and handles the Graph interaction layer automatically.

When a user asks a question like "Which guest accounts haven't signed in within 90 days?" or "Who has privileged roles without MFA enabled?", the model determines which Graph API endpoints are required, structures the appropriate query, executes it against live tenant data, and returns the results in readable operational language. No PowerShell session. No Graph Explorer. No pre-authored scripts or static reports.

The architecture intentionally avoided hardcoded reporting logic. Traditional identity reporting systems answer the questions they were explicitly designed to answer. AOtech wanted something operationally flexible instead — an interface layer capable of handling ad-hoc identity questions dynamically. The local-LLM tool-calling model effectively turned Microsoft Graph from an API technicians had to program against into a system they could interrogate conversationally.

Runtime & Model
Ollama · qwen2.5:7b
Local execution · No cloud dependency
Data Source
Microsoft Graph API · Microsoft Entra ID
Live tenant data · Dynamic query execution
Architecture
Tool-calling agent · Plain-English translation
Human-readable identity audit responses
03
The Outcome

Identity auditing shifted from specialist work into operational workflow. Questions that previously required manual Graph research and scripting now get answered interactively in seconds. Technicians no longer need to understand Graph endpoint structure just to investigate identity posture inside Entra ID.

The operational impact was less about speed and more about accessibility. Before the agent existed, many audit questions simply were not asked because the effort required to retrieve the data outweighed the urgency of the request. The agent lowered the skill floor required to perform identity investigations without lowering the quality of the underlying data retrieval.

It also fundamentally changed how the team interacted with Microsoft Graph. Instead of building one-off scripts and maintaining scattered reporting logic, the organization gained a reusable operational interface sitting directly in front of live Entra ID data. The result was consistent identity visibility without requiring every technician to become a Graph API specialist first.

Plain English
Technicians ask operational questions naturally
instead of writing Graph queries manually
Live Data
Results from current Microsoft Graph data
instead of stale exported reports
Team-wide
Identity visibility accessible to everyone
instead of a small specialist group
"Before this, half the battle was remembering how to structure the Graph query. Now we just ask the question and move on to the actual problem."
Enterprise Identity Architect  ·  Industrial manufacturing firm
Ready to stop gating identity visibility on Graph expertise?

The data is already there.
The question is whether
your team can reach it.

We build AI interfaces that sit in front of complex APIs and let operational teams ask the questions they've always needed answered. No specialist required.

Schedule an AI consultation ← Back to Our Work
Related work
Internal AI Platform (Foundry + RAG)
AI projects from months to two weeks
Related work
GenAI Parts & Support Assistant
16,240-part catalog — instant retrieval
Related work
Network Engineering AI Assistant
60% faster incident resolution
Call Schedule a Call