agentsclimarketplace

Sql

Skill tbc-servicos/dataagile-agent-kit/protheus/skills/sql

Plugin Claude Code para Protheus e ADVPL/TLPP — base 155k+ registros, Agent Teams, compilação TDS-CLI, testes TIR e MCP PO-UI

Install
npx -y skills add tbc-servicos/dataagile-agent-kit --skill sql

Assembled from the repository path, not quoted from the project. Check it against their README if it does not work.

One thing to look at

  • 3 stars3 stars. Stars are a popularity signal and not a quality one, but at this level it is likely that nobody has read this closely except its author, and you would be relying on your own review.

What its author says it does

Copied from the file, not written here

Referência e geração de SQL embarcado em ADVPL/TLPP para Protheus. Cobre BeginSQL/EndSQL, macros essenciais (%table%, %xfilial%, %notDel%, %exp%, %Order%), TCSqlExec para INSERT/UPDATE/DELETE, joins, subconsultas e anti-patterns de segurança.

SKILL.md

2.2 KB, 559 tokens by cl100k_base, as published. Nobody here has run it

ADVPL SQL — SQL Embarcado no Protheus

Referência completa para integração SQL em código ADVPL/TLPP para TOTVS Protheus.

Por que BeginSQL em vez de TCQuery?

Comparação de abordagens para consultas SQL em ADVPL.

Consulte a referência completa via MCP:

searchKnowledge({ skill: "protheus-sql", keyword: "BeginSQL TCQuery" })

Macros Essenciais

Macros padrão: %table%, %xfilial%, %notDel%, %exp%, %Order%, %noAlias%.

Consulte a referência completa via MCP:

searchKnowledge({ skill: "protheus-sql", keyword: "macros" })

Templates: SELECT

Exemplos de SELECT básico, com variável (binding seguro) e JOINs entre tabelas.

Consulte a referência completa via MCP:

searchKnowledge({ skill: "protheus-sql", keyword: "SELECT template" })

TCSqlExec — INSERT / UPDATE / DELETE

Exemplos de DML (INSERT, UPDATE, DELETE lógico) com TCSqlExec.

Consulte a referência completa via MCP:

searchKnowledge({ skill: "protheus-sql", keyword: "TCSqlExec" })

Funções de Suporte SQL

Referência de funções: RetSqlName, GetNextAlias, TCSqlExec, xFilial.

Consulte a referência completa via MCP:

searchKnowledge({ skill: "protheus-sql", keyword: "funcoes SQL" })

Regras Críticas

Regras essenciais: sem * em linha inicial, sempre incluir %notDel% e %xfilial%, evitar SQL injection, fechar alias, nunca full scan.

Consulte a referência completa via MCP:

searchKnowledge({ skill: "protheus-sql", keyword: "regras criticas" })

Quando usar BeginSQL vs ISAM

Decisão entre BeginSQL/EndSQL e ISAM (dbSeek/MsSeek) por cenário.

Consulte a referência completa via MCP:

searchKnowledge({ skill: "protheus-sql", keyword: "BeginSQL ISAM" })

Consulta de Conhecimento

Se precisar de informação não disponível no MCP, consulte o RAG:

searchKnowledge({ keyword: "<termo relevante>" })

What ships with it

Read from the repository

Just SKILL.md. No reference files, no scripts.

Keep looking

Skills are one crate of 328,083. Ordering is by how many stacks a row turns up in, so the top of any crate is what has actually been picked rather than what has the most stars.