🧩
AI EngineeringShell

Query Builder

by thalysjuvenal

Query Builder is an AI Engineering skill for Claude Code, published by thalysjuvenal in advpl-specialist.

186 stars37 forkson thalysjuvenal/advpl-specialistAdded 2026/09/06+1% in starsRepository updated 2026/08/21
advpladvpl-projetosadvprclaude-codedevopsiaorientacao-a-objetosprotheussmartxsqltdntirtlpptotvstotvs-protheus
Install in seconds
Install Query Builder
Copy Query Builder into your Claude Code skills folder. Run the command in your terminal, or review the source on GitHub before installing.
terminal
npx degit https://github.com/thalysjuvenal/advpl-specialist/tree/main/skills/query-builder ~/.claude/skills/query-builder

Requires Node.js. Downloads this skill only — not the rest of the repository — into your Claude Code skills folder.

Without Node.js

git clone https://github.com/thalysjuvenal/advpl-specialist.git

Clones the whole repository, then copy the skill’s own directory into your skills folder yourself.

In this catalog

Source file
skills/query-builder/SKILL.md in thalysjuvenal/advpl-specialist
Installs to
~/.claude/skills/query-builder
Collection
One of 18 skills cataloged from this repository
Category
AI Engineering3278 skills

What Query Builder does

Query Builder helps build, choose, and optimize SQL against Protheus ERP tables. It covers DbSeek versus Embedded SQL, mandatory D_E_L_E_T_/xFilial filters, index-aligned WHERE clauses, and parameterized queries for safer cross-database use.

Query Builder is cataloged under AI Engineering on DirSkills. Query Builder comes from a repository tagged advpl, advpl-projetos, advpr, claude-code and devops.

Documentation

README

Protheus Query Builder

This skill helps build correct, safe, and optimized SQL against Protheus ERP tables, respecting the platform's database conventions: mandatory soft-delete (D_E_L_E_T_) and multi-branch (xFilial) filters, Hungarian-notation field names, dictionary-driven physical schemas (RetSqlName()), and SIX index alignment. It guides the agent to choose the right access pattern -- Workarea navigation vs Embedded SQL vs raw TCSqlExec -- enforce mandatory filters, order WHERE clauses to match available indexes, and parameterize every dynamic value with FWPreparedStatement to eliminate injection risk.

This is the opening of the README. Read the full README on GitHub.

Frequently asked about Query Builder

  • What else does thalysjuvenal publish alongside Query Builder?

    Query Builder is one of 18 skills that DirSkills catalogs from thalysjuvenal/advpl-specialist, the repository it ships in. Its siblings there include ADVPL Code Generation, ADVPL Code Review and ADVPL Debugging. Each one is a separate skill with its own page in this directory, installs the same way Query Builder does, and is maintained by thalysjuvenal in that same repository. The rest of the collection is listed on the thalysjuvenal/advpl-specialist page.

  • How does Query Builder compare to other AI Engineering skills?

    Query Builder ranks #3002 by stars among the 3278 AI Engineering skills in this catalog. The most-starred ones next to it are Architecture Decision Records, AI-First Engineering and Agentic OS. DirSkills ranks by the star count of the repository each skill ships in, so that order reflects how popular those repositories are rather than any review of Query Builder against them. Open each page to compare what they document and how they install.

More from thalysjuvenal/advpl-specialist

Query Builder is one of 18 skills cataloged on DirSkills from thalysjuvenal/advpl-specialist.

See all 18 skills
🧩
4h ago

ADVPL Code Generation

ADVPL Code Generation generates new ADVPL and TLPP code for TOTVS Protheus, including functions, classes, MVC screens, REST/SOAP services, reports, jobs, and workflows. Use it when creating new .prw or .tlpp files with required naming and structure rules.
AI Engineering
18637
🔍
4h ago

ADVPL Code Review

ADVPL Code Review inspects existing ADVPL/TLPP code for best practices, performance, security, and modernization issues. Use it before merge or deploy, or when checking TLPP migration readiness and TOTVS SonarQube rule alignment.
Quality
18637
🐞
4h ago

ADVPL Debugging

ADVPL Debugging helps diagnose and fix ADVPL/TLPP errors in TOTVS Protheus, including compilation failures, runtime exceptions, locks, slow routines, and AppServer log analysis. Use it when you have an error message, stack trace, or failing routine to investigate.
Quality
18637
🛠️
4h ago

ADVPL Refactoring

ADVPL Refactoring helps restructure existing ADVPL/TLPP code without changing behavior. Use it to extract long functions, simplify nested conditionals, remove dead code, improve naming, and reduce duplication or parameter bloat.
Quality
18637
🛠️
4h ago

ADVPL To TLPP Migration

ADVPL To TLPP Migration converts legacy ADVPL procedural routines into TLPP classes for TOTVS Protheus. Use it when migrating User Functions and Static Functions to namespaced classes while preserving backward-compatible wrappers.
AI Engineering
18637
🧪
4h ago

ADVPR Test Automation

ADVPR Test Automation helps write, run, and troubleshoot automated regression tests for TOTVS Protheus routines with ADVPR. It covers FWTestHelper, TestSuite setup, headless execution, routine preparation, and common patterns like MVC, ExecAuto, reports, webservices, SmartLink, and Smart View.
Quality
18637