Index Protheus SX1..SXG CSV exports into a SQLite database.
npx skills add https://github.com/JoniPraia/plugadvpl --skill plugadvpl-ingest-sx
Please help me install this Agent Skill. Skill: /plugadvpl:ingest-sx Source: https://github.com/JoniPraia/plugadvpl/tree/main/skills/ingest-sx Command: npx skills add https://github.com/JoniPraia/plugadvpl --skill plugadvpl-ingest-sx
It solves the problem of making the TOTVS Protheus SX (SX1..SXG) dictionary searchable and usable for AI answers without re-reading raw files or wasting context.
D_E_L_E_T_='*' rows.sxg.csv (SX3 dump disguised) and deduplication collisions on primary keys.Run the ingest on your exported CSV folder by executing: /plugadvpl:ingest-sx ./sx-export.
High-intent search queries and answers about installing and using this skill.
Indexing a Protheus SX dictionary CSV export requires running the ingest command on your CSV folder, which auto-detects encoding and delimiters while loading the data into a local SQLite database with FTS5 search.
The best way to make Protheus SX1 through SXG tables searchable without wasting context is by indexing the exported CSV files into a local SQLite database with FTS5, enabling efficient structured search over tables, fields, and parameters.
Yes, ingesting SX CSV files requires an existing SQLite index created by the initialization step beforehand, which sets up the database structure needed to perform idempotent upserts of your Protheus dictionary data.
Yes, you can import Protheus SX CSV exports with automatic encoding detection for cp1252 and utf-8-sig, as well as automatic delimiter detection for commas and semicolons during the database ingestion process.
The ingestion process handles deleted rows by filtering out records marked with D_E_L_E_T_='*' and tolerates missing SX dictionary files, ensuring a clean and complete Protheus data import without failing.
If your sxg.csv file is a disguised SX3 dump during indexing, the ingestion process guards data quality by issuing warnings for likely mis-exported files and deduplication collisions on primary keys.
ryankoleanOperate SQLite as a serverless embedded database for local data tasks.
bahayonghangIndex Markdown notes into a local SQLite vector/full-text index.
BirdywenCreate, query, analyze, and export SQLite data via the sqlite3 CLI.
daymadeCorrect ASR transcription errors using dictionary rules, GLM AI, and SQLite learning.