Integration
Lyxir + SQL databases
Read-only queries against your ERP or warehouse database: stock, orders, batches and invoices, with row limits and timeouts.
How it works
From SQL databases to cited answers
- 1
Connect your systems
SharePoint, Teams, Outlook, Google, your ERP database and AADE myDATA connect in a few clicks. Choose the sites, folders and mailboxes to bring in.
- 2
Knowledge is indexed
Documents keep their original access rules, so each person only gets answers from what they could already open.
- 3
Build your agents
Give each agent instructions, sources, skills and tools, and pick the model it runs on.
- 4
Review and approve
Replies, messages and invoice classifications wait in Review. Every answer links to its sources, and every decision records who made it.
Templates
What teams do with SQL databases
- Orders
Draft order confirmations
Read order mail and draft a confirmation from live stock.
- Supply
Daily low-stock alerts
Every morning, post the products below reorder level to Teams.
- Finance
Match invoices to POs
Compare myDATA supplier invoices with purchase orders and flag gaps.
Security
Secure by design, not bolted on.
We claim no certifications we do not hold. Here is what the platform actually does to protect your data.
Encrypted credentials
Every connection secret is encrypted with AES-256-GCM and masked after saving.
Company isolation
Each company's data is partitioned, and every query is filtered to its own workspace.
Source permissions kept
SharePoint, OneDrive and Drive sharing rules travel with each document into search.
Human approval
Actions that change anything outside the platform wait in Review until a person approves them.
Who decided, recorded
Every approval or rejection in Review records who made it and when.
Two-factor sign-in
Authenticator-app 2FA with recovery codes; admins can require it for everyone.
Built for the age of AI agents
Agents search with the asking person’s permissions, every answer shows its sources, and nothing leaves the platform without a person’s approval. Usage is metered per agent and per model, so you always know what ran.
Related integrations
FAQ
SQL databases questions
What does the SQL databases integration do?
Read-only queries against your ERP or warehouse database: stock, orders, batches and invoices, with row limits and timeouts. Answers drawn from it cite the original source.
Can I connect more than one SQL databases?
Yes. Connect SQL databases as many times as you need, each with its own name, settings and access.
Is my SQL databases data secure?
Yes. Credentials are encrypted with AES-256-GCM, your data stays in your own workspace, and actions wait for approval.
Put AI agents to work across your pharma operation
Connect your first system and see an agent answer from your own SOPs, mail and data.