Skip to contentNew: use your SOPs, data and agents from Claude and other AI apps over MCPSee MCP

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. 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. 2

    Knowledge is indexed

    Documents keep their original access rules, so each person only gets answers from what they could already open.

  3. 3

    Build your agents

    Give each agent instructions, sources, skills and tools, and pick the model it runs on.

  4. 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.

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.