n8n Workflow: Ask Sage X3 Sales & Stock via OpenRouter MCP

Ask Sage X3 Sales & Stock in Natural Language—Powered by OpenRouter and MCP

This n8n workflow lets you ask sales, stock, and revenue questions about your Sage X3 database using plain English. An AI agent interprets your request with a Claude model via OpenRouter, selects the correct predefined Sage X3 SQL tools, and returns a concise answer from live Sage X3 data. You can also expose the same tools through an MCP endpoint protected by Bearer authentication.

What this workflow does

• Receives your question through the n8n chat interface.
• Uses a Claude model on OpenRouter (with conversation memory) to understand intent and support follow-up questions.
• Resolves customer and item names to Sage X3 codes by querying Sage X3 reference data when needed.
• Runs parameterized SQL tools to retrieve stock levels, stock movements, sales order history, or revenue aggregates/details.
• Formats a concise response using only the returned Sage X3 data, including currency and relevant time horizon when applicable.
• Optionally exposes the same tools as an MCP server endpoint for MCP clients, using Bearer-auth protection.

Use cases

• “How much stock do we have for item X3-123?”
• “Show recent stock movements for customer Y and this time period.”
• “What are the sales order details and revenue for product Z over the last 30 days?”
• Enable an MCP client to reuse the same Sage X3 querying tools with standardized access.

Technical details

• Nodes / integrations: `n8n-nodes-nx3nx3` (Sage X3 SOAP/SQL tools via community package), LangChain Agent, LangChain Chat Trigger, LangChain MCP Trigger, and LangChain LM Chat OpenRouter.
• Required setup: install `n8n-nodes-nx3`; configure Sage X3 SOAP credentials (server URL, folder, username, password); add an OpenRouter API key; set up Bearer Auth for the MCP endpoint path.