Query Uniconta ERP Data with OpenAI AI Agent via Peliqan

This n8n workflow creates an in-house AI agent that answers natural language questions about data in your Uniconta ERP system. It leverages Peliqan.io as a data cache, syncing Uniconta data via one-click ELT to a built-in warehouse. The OpenAI-powered AI Agent converts user queries into SQL using Text-to-SQL, executes them via the Peliqan node (integrated as a tool), and interprets results for user-friendly responses.

Key benefits include rapid querying without direct ERP API limits, improved accuracy through cached data, and seamless natural language interaction. It's ideal for non-technical users needing real-time insights into inventory, finances, customers, or any Uniconta module, reducing manual reporting time from hours to seconds.

Use cases: Customer support agents checking stock levels; managers querying sales reports; accountants reviewing ledger entries. Setup requires a Peliqan trial, Uniconta API key connection, and pasting the data model into the AI Agent's system prompt for optimal performance. Highly valuable for SMBs automating business intelligence.