/plugadvpl:tables

Locate Protheus/ADVPL table references with file, line, and operation details.

Updated Aug 27, 2026
One-click install
npx skills add https://github.com/JoniPraia/plugadvpl --skill plugadvpl-tables
Or copy as Structured Prompt for Agent
Please help me install this Agent Skill.
Skill: /plugadvpl:tables
Source: https://github.com/JoniPraia/plugadvpl/tree/main/skills/tables
Command: npx skills add https://github.com/JoniPraia/plugadvpl --skill plugadvpl-tables

SYSTEM DOCUMENTATION & REQUIREMENTS

What problem does it solve?

It helps you locate every place a specific ERP table (ADVPL/Protheus) is referenced in an indexed project, so you can understand impact and trace reads, writes, and lock usage without manually scanning thousands of lines.

Core Features & Use Cases

  • Reads/Writes/Reclock filtering: Narrow results to only Db* reads, write patterns (RecLock + Replace + MsUnlock), or lock/unlock operations.
  • Full project impact discovery: Shows all usages (including SQL) for a given table alias/name.
  • Actionable output: For each usage, it reports the alias/table, file and line, operation type, and the function that contains the usage.

Quick Start

Ask your AI to list all usages of table SA1 in the indexed project with read-only filtering by running the command: /plugadvpl:tables SA1 --read.

Frequently Asked Questions about /plugadvpl:tables

High-intent search queries and answers about installing and using this skill.

FAQPage Schema
How do I find all references to a Protheus table in an ADVPL project?

To find all references to a Protheus table, scan the indexed repository to locate every read, write, or lock usage, returning the file, line, operation type, and containing function for complete impact analysis.

What is the best way to trace read and write operations for a specific ADVPL table?

Tracing read and write operations for an ADVPL table involves filtering repository usages by operation type, allowing you to isolate Db* reads, RecLock write patterns, or lock/unlock behavior across the source code.

Can I filter Protheus table impact analysis results to show only RecLock usages?

Yes, you can filter Protheus table impact analysis results to show only RecLock usages by applying lock mode filters, isolating specific lock and unlock operations within the indexed source code.

How does table lineage analysis work for ADVPL source code?

Table lineage analysis for ADVPL source code works by indexing the project repository and locating all alias and table name references, mapping dependency tracing and auditing behavior for read, write, and lock operations.

Do I need a specific database setup to perform Protheus table dependency tracing?

Protheus table dependency tracing requires an indexed repository utilizing SQLite FTS5 to locate table references, meaning the source code must be indexed before executing any impact analysis queries.