AZ Tools MCP - Real-time Azure Infrastructure Querying
Custom MCP Tool for Secure Azure Resource Data Retrieval
Developed a custom MCP (Multi-protocol Communication Protocol) tool that enables real-time querying of Azure infrastructure resources through secure device login authentication, providing factually dense data for AI-powered analysis and executive reporting without persistent storage.
Client
Luxottica
Completion
2 months
Category
Automation & AI
Situation
The organization needed the ability to query Azure infrastructure data in real-time for AI-powered analysis and executive reporting. Traditional approaches required persistent storage of sensitive infrastructure data, creating security risks. There was also a need to integrate Azure resource querying seamlessly into conversational AI interfaces while maintaining strict security controls through proper authentication workflows.
Task
Design and implement a custom MCP tool that securely retrieves real-time Azure infrastructure data using device login and 2FA authentication, provides ephemeral data handling, and enables generation of factually dense executive reports without persistent storage of sensitive information.
Action
→Developed custom MCP tool for Azure resource querying using Python AZ CLI authentication model
→Implemented Microsoft Device login workflow with Multi-Factor Authentication (2FA) to retrieve secure bearer tokens
→Created real-time querying capability for Azure resources including subscriptions, resource groups, and Virtual Machines
→Successfully demonstrated retrieval of configuration data for 47 Virtual Machines across two Azure subscriptions
→Designed ephemeral data handling ensuring bearer tokens and associated infrastructure data are automatically erased upon conclusion of MCP discussions
→Integrated with Open Web UI (Lux GPT) to enable conversational queries of Azure infrastructure
→Developed executive reporting capabilities generating factually dense, real-time cybersecurity reports highlighting critical findings
→Implemented secure token management with automatic expiration and cleanup to prevent data persistence
Results
✓Enabled real-time, secure querying of Azure infrastructure resources without persistent data storage, significantly reducing security risks
✓Demonstrated successful retrieval of comprehensive infrastructure data (47 VMs across 2 subscriptions) for analysis and reporting
✓Generated factually dense executive reports with real-time data, such as identifying outdated Red Hat versions across infrastructure
✓Provided seamless integration with conversational AI interfaces, enabling natural language queries of Azure resources
✓Established secure authentication workflow using device login and 2FA, meeting enterprise security requirements
✓Eliminated security concerns around persistent storage of sensitive infrastructure data through ephemeral data handling
✓Enabled faster decision-making through real-time infrastructure insights and automated executive reporting
✓Created foundation for AI-powered infrastructure management and analysis workflows