Protheus Data Dictionary Lookup

What it does

When your agent uses it

• Finding which fields and types a Protheus table has
• Checking indexes or triggers on a field
• Looking up what an MV_ parameter does
• Validating dictionary impact before a migration

Example prompts

• “What fields does SA1 have?”
• “Show the index of SE1 and the triggers for field A1_COD.”
• “Look up parameter MV_ESTADO and explain its purpose.”

Requirements

• An execute-sql tool connected to the Protheus database

Workflow steps

4 steps, taken from the first numbered list in SKILL.md.

1. 1Always include d_e_l_e_t_ = ' ' (soft-delete filter)
2. 2Columns are lowercase — never use X3_CAMPO, always x3_campo
3. 3Use TRIM() in character field comparisons (trailing spaces)
4. 4Use base table without suffix: sx3, sx2, six — never sx3t10, sx2t10

What it can do on your machine

Read from SKILL.md and the folder at commit 3908e4e. It shows what the files ask for, not the result of running them.

• Tool permissions

  Pre-approves nothing: there is no allowed-tools line, so your agent's usual permission prompts apply.

  From allowed-tools in the SKILL.md frontmatter.

• Runs code

  No scripts in the folder and no shell commands in SKILL.md (its code samples are markdown).

  From the folder's file list and the shell code blocks in SKILL.md.

• Network

  No URLs in SKILL.md.

  From URLs in SKILL.md, links to its own repository left out.

• Credentials

  Names no API keys, tokens, secrets or passwords.

  From names ending in _API_KEY, _TOKEN, _SECRET, _KEY or _PASSWORD in SKILL.md.

Context cost

Protheus Data Dictionary Lookup loads about 1.5k tokens when it runs, and up to ~6k if it reads all its reference files. Until then it costs about 161 tokens; SKILL.md has 561 words of instructions outside code blocks.

Always · name and description, kept in context so the agent knows when to use it

~161

When it runs · the whole SKILL.md, loaded when a task matches

~1.5k

With references · SKILL.md plus every file in references/, read only if the agent opens them

~6k

Estimates: characters ÷ 4, the usual rule of thumb; real counts depend on the model's tokenizer. Scripts and assets cost tokens only if the agent reads them.

Safety

Automated static check — not a guarantee. Review scripts before installing. It scans the text of SKILL.md for risky patterns (piping downloads into a shell, reading credential files, hidden Unicode, destructive commands); files beside SKILL.md are not scanned.

SKILL.md

The full file from totvs/engpro-advpl-tlpp-skills at commit 3908e4e, republished under its MIT licence (© totvs). 561 words, ~1,549 tokens.

name

data-dictionary-lookup

description

Query the TOTVS Protheus ERP data dictionary (SX2 tables, SX3 fields, SIX indexes, SX6 parameters, SX5 generic tables, SX7 triggers, SX1 questions, SX9 relationships, SXB standard lookups, SXG/SXA groups). Use when the user asks 'what fields does SA1 have', 'what is the index of SE1', 'parameter MV_ESTADO', 'generic table 12', 'triggers for field A1_COD', 'standard lookup SA1', 'table structure', 'data dictionary'. Also use during refactoring, migration, or code improvements when dictionary impact validation is needed to confirm whether changes affect fields, triggers, indexes, parameters, or table relationships.

license

MIT

metadata.domain

Protheus

metadata.maintainer

Customizações ADVPL/TLPP

metadata.author

Thalion Starforge

metadata.version

4.1.0

metadata.category

Documentation

## SA1 — Customer Registry

**Mode**: Shared (C/C/C)
**Unique key**: A1_FILIAL+A1_COD+A1_LOJA
**MVC Routine**: CRMA980

### Main Fields

| Field | Title | Type | Size | Dec | Required | Context |
|-------|-------|------|------|-----|----------|---------|
| A1_FILIAL | Branch | C | 8 | 0 | Yes | Real |
| A1_COD | Code | C | 6 | 0 | Yes | Real |
| A1_LOJA | Store | C | 2 | 0 | Yes | Real |
| A1_NOME | Name | C | 40 | 0 | Yes | Real |
...

### Indexes

| Order | Composition | Description |
|-------|-------------|-------------|
| 1 | A1_FILIAL+A1_COD+A1_LOJA | Customer Code+Store |
| 2 | A1_FILIAL+A1_NOME | Name |
...

© totvs, MIT. Rendered from Markdown: HTML in the file is shown as text, images as links, and headings moved down two levels. Raw file

Files

SKILL.md and 2 other files (references) in skills/advpl-tlpp/data-dictionary-lookup of totvs/engpro-advpl-tlpp-skills.

• SKILL.md
• references/column-reference.md
• references/sql-queries.md

Open the folder on GitHubat commit 3908e4e