AI assistant for ERP data with nightly SFTP ingestion
A private AI chat that queries the data your ERP exports every night by SFTP (orders, invoices, customers, jobs), with permissions by role and scope, searchable attached documents, and automatic backups and monitoring.
The data is in the ERP, but getting one specific figure ("which of this customer's orders were not invoiced last month?") usually takes a custom report or an export to Excel. This AI assistant for ERP data picks up every night the exports your ERP leaves on an SFTP server, keeps the history of every record and lets you ask questions in a private chat. Each user sees only what their role allows, and sensitive data is filtered out before it reaches the AI.
Who it is for
- Companies with an ERP that want management, sales staff and the technical office to get quick answers on orders, invoices, customers and jobs.
- ERP resellers and integrators that want to offer their clients an AI assistant without touching the ERP core.
- IT managers who want it on their own server, with backups and monitoring.
The interface is in Spanish, and file loading and text search are set up for Spanish dates, numbers and text.
What an AI assistant for ERP data solves
- An ERP with no direct connection. All the ERP has to do is export files to an SFTP server. Importing the same data again does not duplicate it, and every change is kept as a new version.
- Permissions. Each user only sees the rows in their scope (customer, user or field worker) and the columns their role allows.
- Sensitive data. Each column has a sensitivity level. Critical columns never go out to the AI, and free text is cleaned of personal data, secrets and attempts to manipulate the AI.
- Loose documents. Delivery notes, work reports or invoices in PDF, image or Excel format are attached to the chat, read and matched against orders.
What you can do with it
Load the ERP data
- Receive the exports by SFTP every day. The system waits for the ERP to finish writing before reading.
- Load large export files, with dates and numbers in Spanish format.
- Check the version history of every record and always work with the current version.
- Work with a data catalog prepared for querying (orders, invoices, customers, jobs, field workers, rates, contracts and master data), adjusted to the ERP of each installation.
Ask in the chat
- Ask in natural language. The AI can only read, and permission filters always apply.
- See results of up to 5,000 rows in a paginated table, with charts and the query used shown as the source.
Work with documents
- Read blocks, tables and fields from PDFs and images, and Excel sheets.
- Search the full text in Spanish, even with typos in codes and references.
- Retrieve excerpts, browse sections or review complete tables, and open the original in a viewer.
- Link documents to orders.
- Organize chats in folders with members, favorites and an archive, and share them with other users.
Manage and protect
- Manage users, permissions by role and scope, and the AI model, with your key stored encrypted.
- Browse the audit log, export it to CSV and review every AI call.
- Enforce a password policy, lock access after several failed attempts and set up passwords by link.
Run the server
- Make an encrypted daily backup of the database and send it by SFTP, with daily and monthly retention.
- Test every month that the latest backup can be restored.
- Check the data load, the backup, the disk, the certificate and the network every day, and the software dependencies every week.
- Monitor the application every 5 minutes with automatic restart, plus optional external monitoring.
Benefits
- Questions about the ERP get answered on the spot, without asking for reports.
- There is no need to touch the ERP: an export is enough.
- Critical data does not leave your server.
- Backups, test restores and monitoring are already taken care of.
Industry context
General industry data with its public source. These are not results of this product.
- In the first quarter of 2026, 60.9% of Spanish companies with 10 or more employees and an Internet connection used enterprise resource planning (ERP) software. Source: INE (Spain's National Statistics Institute), "Encuesta sobre el uso de TIC y del comercio electrónico en las empresas. Año 2025 - Primer trimestre 2026" (survey on ICT and e-commerce use in companies), 2026.
What you get with each license
Price upon request, depending on license type and scope. Maintenance and support are contracted separately for every license type.
- The software installed on your server, under a license to use.
- Adapting the data load to your ERP's export format and classifying the sensitivity of your columns.
- Setting up backups and monitoring.
- Initial training for administrators.
- The complete source code, so your team or an integrator can adapt it to one or more ERPs and roll it out to their clients.
- Installation and operations documentation.
- A technical handover session with your team.
- A warranty against defects for the agreed period.
- Everything in the source code license.
- Our commitment not to license the product to third parties in the agreed sector, vertical ERP or territory for the agreed term.
- The right to embed the asset in a commercial product of your own, identified in the contract.
- The right to distribute it to your customers as part of that product, without asking for authorization for each installation and with no limit on end customers, unless otherwise agreed.
- It does not include reselling or sublicensing it on its own.
- It is not exclusive, unless otherwise agreed.
- Maintenance, support and adaptations are contracted separately.
Technical specifications
Language and runtime: TypeScript 5.9 on Node.js, with operations scripts in Bash. Minimum supported version: Node.js 20.9 (required by Next.js 16).
Frameworks: Next.js 16.4 and React 19.2, with Drizzle ORM 0.45, AI SDK 6 and Tailwind CSS 4.3.
Database: PostgreSQL with the pg_trgm extension.
Operating systems: Linux.
Interface languages: Spanish.
Required infrastructure:
- A Linux server with nginx, a TLS certificate and cron.
- PostgreSQL with the pg_trgm extension, local or managed.
- SFTP access to the server where the ERP drops its exports, and an SFTP destination for backups.
- GPG to encrypt backups.
- OpenAI (requires your own account).
Private deployment: Everything runs on your infrastructure except the AI, which needs a connection to OpenAI.
Main libraries:
| Library | Version | License |
|---|---|---|
| next | 16.4.2 | MIT |
| react | 19.2.4 | MIT |
| drizzle-orm | 0.45.4 | Apache-2.0 |
| postgres | 3.4.9 | Unlicense |
| next-auth | 5 | ISC |
| bcryptjs | 3.0.3 | BSD-3-Clause |
| ai (AI SDK) | 6.0.314 | Apache-2.0 |
| @ai-sdk/openai | 3.0.131 | Apache-2.0 |
| ssh2-sftp-client | 12.1.1 | Apache-2.0 |
| xlsx (SheetJS, bundled in the package) | 0.20.3 | Apache-2.0 |
| pdf-lib | 1.17.1 | MIT |
| zod | 4.6.7 | MIT |
Dependencies with specific license terms:
- @img/sharp-libvips-* 1.3.4 (libvips binaries used by sharp 0.35.5, an optional dependency of Next.js): LGPL-3.0-or-later. The @img/sharp-win32-* and @img/sharp-wasm32 0.35.5 packages: Apache-2.0 AND LGPL-3.0-or-later.
Compatibility and integrations: SFTP; OpenAI API v1 through AI SDK 6; Excel files through SheetJS; PostgreSQL with Spanish full-text search and pg_trgm.
Redistribution terms
The asset's own code can be embedded in the licensee's commercial products under the source code, sector or territory exclusive and OEM licenses, on the terms of the contract. With the installed license, the software is used and not redistributed. Specific license terms apply to the libvips binaries used by sharp (LGPL-3.0-or-later), as listed under Technical specifications.
Installation requirements
Installed on a Linux server of your own or in your cloud, with a TLS certificate. It needs a PostgreSQL database, local or managed, SFTP access to the server where the ERP drops its exports and an SFTP destination for backups. The AI works with an OpenAI account in your name.
Integrations
SFTP for data loading and backups, OpenAI with your key, PostgreSQL and Excel sheets.
Frequently asked questions
Does it work with our ERP?
If your ERP can export files on a schedule (JSON, CSV or Excel) to an SFTP server, yes, once the data load and the data catalog are adapted to its format. The rest of the product does not depend on the ERP.
Can the AI change data?
No. It only runs read queries, with permissions that do not allow writing, and each user's filters are applied before the query runs.
What data is sent to OpenAI?
The question, the description of the tables and the resulting rows, without the critical columns and with free text cleaned of personal data. Your company's key is used.
Can we query documents that are not in the ERP?
Yes. You attach PDFs, images or Excel files to the chat and they can be matched against orders.
Is maintenance included?
No. Maintenance (updates and bug fixes) and support (questions, training and adaptations) are contracted separately.
Request
Request information on P-DAT-04
Fill in the form with the asset reference and the license type you're considering. I reply in writing. If you need to review code, tick the NDA box and we'll sign one before anything is shared.