Skip to content
APFerrer
P-DAT-04 · ProductCompanies with an ERP (services, distribution, manufacturing)

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.

Source codeExclusivity availableInstalledOEM

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.

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.

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.

FAQ

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.

Controller: APFerrer. Purpose: to answer your request. You can exercise your rights as described in the privacy policy.

Price upon request, depending on license type and scope. Maintenance and support are contracted separately.