✦ Autonomous Text-to-SQL Inventory Engine
Industrial Inventory AI Agent
Non-technical warehouse staff struggle to extract real-time inventory metrics, supplier data, and purchase order status due to complex SQL database structures and technical query bottlenecks.
Non-technical warehouse staff struggle to extract real-time inventory metrics, supplier data, and purchase order status due to complex SQL database structures and technical query bottlenecks.
Architected an autonomous text-to-SQL AI agent that connects non-technical warehouse personnel directly to relational inventory databases via plain English prompts. Orchestrated complex agent logic and webhook triggers using n8n paired with Google Gemini and strict system prompt guardrails. Integrated dynamic schema retrieval, conversation session memory, and custom Markdown response formatting for fast data visualisations. Enforced enterprise security policies by executing queries against a PostgreSQL database hosted on Supabase using restricted, read-only credentials.
Embedded WebChat Interface
User-friendly webchat interface letting operators query stock counts, purchase orders, and supplier updates using everyday language.
n8n Agent Workflow Architecture
Automated orchestration workflow showing n8n webhook nodes, AI agent reasoning blocks, and schema extraction steps.
Multi-Trigger Integration & API Gateway
Live deployment demonstrating dual interaction entry points: the embedded WebChat widget and the external POST API gateway.