SQL Code Review
totvs/engpro-advpl-tlpp-skills
Universal SQL code review assistant that performs comprehensive security, maintainability, and code quality analysis across SQL databases (PostgreSQL, SQL Server, Oracle).
A skill your agent uses when the user needs to build, choose the pattern for, or optimize a SQL query against Protheus ERP tables -- covering Workarea (DbSelectArea/DbSeek) vs Embedded SQL vs…
Install Query Builder
$ npx skills add thalysjuvenal/advpl-specialist --skill query-builder -a claude-codeProject install by default; add -g for ~/.claude/skills/.
$ gh skill install thalysjuvenal/advpl-specialist query-builder --agent claude-codeProject scope by default; add --scope user for a personal install. Needs GitHub CLI 2.90.0 or later (public preview).
$ git clone --depth 1 https://github.com/thalysjuvenal/advpl-specialist.git skills-src && mkdir -p .claude/skills && cp -r skills-src/skills/query-builder .claude/skills/query-builder && rm -rf skills-srcUse ~/.claude/skills/ instead of .claude/skills for a personal install. The folder must contain SKILL.md.
Claude Code skills documentation · loads skills from .claude/skills/
Install the "query-builder" agent skill from https://github.com/thalysjuvenal/advpl-specialist/tree/main/skills/query-builder into .claude/skills/query-builder/ in this project. Copy the whole folder (SKILL.md and every file beside it), keep the folder name "query-builder", then confirm the skill loads.Claude Code copies the folder itself, the same result as the manual copy. Check what it changed before you commit it.
$skill-installer install https://github.com/thalysjuvenal/advpl-specialist/tree/main/skills/query-builderType this inside Codex. $skill-installer <name> installs a curated skill from openai/skills. The installer writes to $CODEX_HOME/skills (default ~/.codex/skills). Restart Codex if the skill does not show up.
$ npx skills add thalysjuvenal/advpl-specialist --skill query-builder -a codexProject install goes to .agents/skills/; add -g for ~/.codex/skills/.
$ gh skill install thalysjuvenal/advpl-specialist query-builder --agent codexProject scope by default (.agents/skills/); add --scope user for a personal install.
$ git clone --depth 1 https://github.com/thalysjuvenal/advpl-specialist.git skills-src && mkdir -p .agents/skills && cp -r skills-src/skills/query-builder .agents/skills/query-builder && rm -rf skills-srcUse ~/.agents/skills/ instead of .agents/skills for a personal install.
Codex skills documentation · loads skills from .agents/skills/
Install the "query-builder" agent skill from https://github.com/thalysjuvenal/advpl-specialist/tree/main/skills/query-builder into .agents/skills/query-builder/ in this project. Copy the whole folder (SKILL.md and every file beside it), keep the folder name "query-builder", then confirm the skill loads.Codex copies the folder itself, the same result as the manual copy. Check what it changed before you commit it.
$ npx skills add thalysjuvenal/advpl-specialist --skill query-builder -a cursorProject install goes to .agents/skills/; add -g for ~/.cursor/skills/.
$ gh skill install thalysjuvenal/advpl-specialist query-builder --agent cursorProject scope by default (.agents/skills/); add --scope user for a personal install.
$ git clone --depth 1 https://github.com/thalysjuvenal/advpl-specialist.git skills-src && mkdir -p .cursor/skills && cp -r skills-src/skills/query-builder .cursor/skills/query-builder && rm -rf skills-srcUse ~/.cursor/skills/ instead of .cursor/skills for a personal install.
Cursor skills documentation · loads skills from .cursor/skills/, .agents/skills/, .claude/skills/, .codex/skills/
Install the "query-builder" agent skill from https://github.com/thalysjuvenal/advpl-specialist/tree/main/skills/query-builder into .cursor/skills/query-builder/ in this project. Copy the whole folder (SKILL.md and every file beside it), keep the folder name "query-builder", then confirm the skill loads.Cursor copies the folder itself, the same result as the manual copy. Check what it changed before you commit it.
$ gemini skills install https://github.com/thalysjuvenal/advpl-specialist.git --path skills/query-builder--scope user (default) or --scope workspace; --path is the subfolder of the repo that holds the skill; --consent skips the security confirmation prompt.
$ npx skills add thalysjuvenal/advpl-specialist --skill query-builder -a gemini-cliProject install goes to .agents/skills/; add -g for ~/.gemini/skills/.
$ gh skill install thalysjuvenal/advpl-specialist query-builder --agent gemini-cliProject scope by default (.agents/skills/); add --scope user for a personal install.
$ git clone --depth 1 https://github.com/thalysjuvenal/advpl-specialist.git skills-src && mkdir -p .gemini/skills && cp -r skills-src/skills/query-builder .gemini/skills/query-builder && rm -rf skills-srcUse ~/.gemini/skills/ instead of .gemini/skills for a personal install, then run /skills reload.
Gemini CLI skills documentation · loads skills from .gemini/skills/, .agents/skills/
Install the "query-builder" agent skill from https://github.com/thalysjuvenal/advpl-specialist/tree/main/skills/query-builder into .gemini/skills/query-builder/ in this project. Copy the whole folder (SKILL.md and every file beside it), keep the folder name "query-builder", then confirm the skill loads.Gemini CLI copies the folder itself, the same result as the manual copy. Check what it changed before you commit it.
$ gh skill install thalysjuvenal/advpl-specialist query-builderInstalls for Copilot at project scope by default; add --scope user for a personal install. Preview a skill first with gh skill preview. Needs GitHub CLI 2.90.0 or later (public preview).
$ npx skills add thalysjuvenal/advpl-specialist --skill query-builder -a github-copilotProject install goes to .agents/skills/; add -g for ~/.copilot/skills/.
$ git clone --depth 1 https://github.com/thalysjuvenal/advpl-specialist.git skills-src && mkdir -p .github/skills && cp -r skills-src/skills/query-builder .github/skills/query-builder && rm -rf skills-srcUse ~/.copilot/skills/ instead of .github/skills for a personal install. Commit .github/skills so cloud agent and code review can use it.
GitHub Copilot skills documentation · loads skills from .github/skills/, .claude/skills/, .agents/skills/
Install the "query-builder" agent skill from https://github.com/thalysjuvenal/advpl-specialist/tree/main/skills/query-builder into .github/skills/query-builder/ in this project. Copy the whole folder (SKILL.md and every file beside it), keep the folder name "query-builder", then confirm the skill loads.GitHub Copilot copies the folder itself, the same result as the manual copy. Check what it changed before you commit it.
$ npx skills add thalysjuvenal/advpl-specialist --skill query-builder -a opencodeOpenCode documents no install command of its own. Project install goes to .agents/skills/; add -g for ~/.config/opencode/skills/.
$ gh skill install thalysjuvenal/advpl-specialist query-builder --agent opencodeProject scope by default (.agents/skills/); add --scope user for a personal install.
$ git clone --depth 1 https://github.com/thalysjuvenal/advpl-specialist.git skills-src && mkdir -p .opencode/skills && cp -r skills-src/skills/query-builder .opencode/skills/query-builder && rm -rf skills-srcUse ~/.config/opencode/skills/ instead of .opencode/skills for a personal install.
OpenCode skills documentation · loads skills from .opencode/skills/, .claude/skills/, .agents/skills/
Install the "query-builder" agent skill from https://github.com/thalysjuvenal/advpl-specialist/tree/main/skills/query-builder into .opencode/skills/query-builder/ in this project. Copy the whole folder (SKILL.md and every file beside it), keep the folder name "query-builder", then confirm the skill loads.OpenCode copies the folder itself, the same result as the manual copy. Check what it changed before you commit it.
Facts
- Skill name
query-builder- GitHub stars
- 186
- Token cost
- ~594 tokens
- SKILL.md length
- 190 words
- Files
- 6
- Skills in repo
- 19
- Repo updated
- First seen
- Licence
- MIT
At a glance
A skill your agent uses when the user needs to build, choose the pattern for, or optimize a SQL query against Protheus ERP tables -- covering Workarea (DbSelectArea/DbSeek) vs Embedded SQL vs…
- The user needs to build
- Instructions only: no scripts, shell commands, URLs or credentials in SKILL.md
- Choose the pattern for
- Optimize a SQL query against Protheus ERP tables -- covering Workarea (DbSelectArea/DbSeek) vs Embedded SQL vs TCSqlExec pattern choice
What it does
Query Builder is an agent skill from thalysjuvenal/advpl-specialist. Use when the user needs to build, choose the pattern for, or optimize a SQL query against Protheus ERP tables -- covering Workarea (DbSelectArea/DbSeek) vs Embedded SQL vs TCSqlExec pattern choice, mandatory DELET/xFilial filters, SIX index-aligned WHERE ordering, FWPreparedStatement parameterization to prevent SQL injection, and cross-database (PostgreSQL/MSSQL/Oracle) portability. Also triggers on Portuguese phrasing like "consulta SQL", "montar query", "otimizar consulta", "qual indice usar", "escolher entre…
Its SKILL.md is about 590 tokens, which your agent loads only when the skill is triggered. The skill folder holds 5 other files (for example `cross-database.md`, `index-awareness.md` and `patterns-fwpreparedstatement.md`).
It sits in Databases, covering SQL, ORMs and data access and Web application vulnerabilities. It works with SQL, Microsoft SQL Server and PostgreSQL. The repository describes itself as: Plugin para Claude Code especializado em ADVPL e TLPP para desenvolvimento TOTVS Protheus. The licence is MIT.
When your agent uses it
- The user needs to build
- Choose the pattern for
- Optimize a SQL query against Protheus ERP tables -- covering Workarea (DbSelectArea/DbSeek) vs Embedded SQL vs TCSqlExec pattern choice
- Mandatory DELET/xFilial filters
Example prompts
- “consulta SQL”
- “montar query”
- “otimizar consulta”
- “/query-builder”
What it can do on your machine
Read from SKILL.md and the folder at commit d80599b. 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.
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
Query Builder loads about 594 tokens when it runs. Until then it costs about 148 tokens; SKILL.md has 190 words of instructions outside code blocks.
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
Auto-check passed
The automated check found no risky patterns in SKILL.md.
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 thalysjuvenal/advpl-specialist at commit d80599b, republished under its MIT licence (© thalysjuvenal). 190 words, ~594 tokens.
Download SKILL.mdSave it as
.claude/skills/query-builder/SKILL.md (or your agent's skills folder). This skill also uses 5 other files; get the full folder from GitHub.- name
- query-builder
- description
- Use when the user needs to build, choose the pattern for, or optimize a SQL query against Protheus ERP tables -- covering Workarea (DbSelectArea/DbSeek) vs Embedded SQL vs TCSqlExec pattern choice, mandatory D_E_L_E_T_/xFilial filters, SIX index-aligned WHERE ordering, FWPreparedStatement parameterization to prevent SQL injection, and cross-database (PostgreSQL/MSSQL/Oracle) portability. Also triggers on Portuguese phrasing like "consulta SQL", "montar query", "otimizar consulta", "qual indice usar", "escolher entre DbSeek ou SQL", or "prevenir SQL injection no Protheus".
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.
Activate this skill when building any query against Protheus tables (standard SA*/SE*/SF* or custom Z*), deciding between DbSelectArea/DbSeek and Embedded SQL, reviewing code for missing mandatory filters, adding parameterized queries, diagnosing slow queries via index misalignment, or writing cross-database code. It does not cover BeginSQL/EndSQL macro syntax itself (see embedded-sql, its companion skill for macro details), nor record locking semantics during writes (see protheus-locks-deadlocks).
| Reference file | Read when |
|---|---|
| reference.md | Always -- database conventions, table/field naming, mandatory filters, pattern-choice overview |
| patterns-workarea.md | Generating record-by-record code with DbSelectArea + DbSeek + RecLock |
| patterns-fwpreparedstatement.md | Building parameterized TCQuery/TCSqlExec, LIKE clauses, INSERT/UPDATE/DELETE |
| index-awareness.md | Choosing/validating an index, ordering WHERE clauses, common SIX key expressions |
| cross-database.md | Using ChangeQuery(), TCGetDB(), DBAccess macros, MSSQL/PostgreSQL/Oracle equivalents |
© thalysjuvenal, 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 5 other files in skills/query-builder of thalysjuvenal/advpl-specialist.
- SKILL.md
- cross-database.md
- index-awareness.md
- patterns-fwpreparedstatement.md
- patterns-workarea.md
- reference.md
Open the folder on GitHubat commit d80599b
Compare with similar skills
Query Builder next to the 5 skills that share the most tags, products or categories with it. Stars are the repository's; “used in” counts other GitHub owners with a copy.
| Skill | Stars | Used in | Tokens | Auto-check | Licence | Repo updated |
|---|---|---|---|---|---|---|
| Query Builder this skillthalysjuvenal/advpl-specialist | 186 | — | ~594 | Automated safety check: Pass | MIT | |
| SQL Code Reviewtotvs/engpro-advpl-tlpp-skills | 143 | — | ~3.5k | Automated safety check: Pass | MIT | |
| SQL Code Reviewgithub/awesome-copilot | 40k | 1 repos | ~2.2k | Automated safety check: Pass | MIT | |
| Frappe Syntax Query BuilderImpertio-Studio/Frappe_Claude_Skill_Package | 188 | — | ~1.7k | Automated safety check: Pass | MIT | |
| Matlab Use Databasematlab/matlab-agentic-toolkit | 1.1k | — | ~3.1k | Automated safety check: Pass | Custom licence | |
| Tsh SQL And Database UnderstandingTheSoftwareHouse/copilot-collections | 284 | — | ~11k | Automated safety check: Pass | MIT |
Similar skills
- Official
SQL Code Review
github/awesome-copilot
Universal SQL code review assistant that performs comprehensive security, maintainability, and code quality analysis across all SQL databases (MySQL, PostgreSQL, SQL Server, Oracle).
Frappe Syntax Query Builder
Impertio-Studio/Frappe_Claude_Skill_Package
A skill your agent uses when building database queries with frappe.qb in Frappe v14-v16.
Matlab Use Database
matlab/matlab-agentic-toolkit
Reads from, writes to, and manages relational databases using MATLAB Database Toolbox.
Tsh SQL And Database Understanding
TheSoftwareHouse/copilot-collections
SQL writing and database engineering patterns, standards, and procedures.
- Official
Safe SQL Execution
supabase/supabase
A skill your agent uses whenever code will build, return, fetch, or execute SQL that runs against a user's real Postgres database — even when the request reads like an ordinary feature or bug fix…
More from thalysjuvenal/advpl-specialist
All 19 skills in this repoAdvpl Code Generation
thalysjuvenal/advpl-specialist
A skill your agent uses when the user asks to generate, create, or scaffold ADVPL/TLPP code for TOTVS Protheus -- User Functions, Static Functions, TLPP classes, MVC (Model/View/Controller), REST…
Advpl Code Review
thalysjuvenal/advpl-specialist
A skill your agent uses when the user asks to review, audit, or check the quality of ADVPL/TLPP code for TOTVS Protheus before merge or deploy -- covering best practices (RecLock/MsUnlock pairing…
Advpl To Tlpp Migration
thalysjuvenal/advpl-specialist
A skill your agent uses when the user asks to migrate, convert, compatibilize, or modernize legacy ADVPL procedural code to TLPP object-oriented classes on TOTVS Protheus -- turning User…
Advpr Test Automation
thalysjuvenal/advpl-specialist
A skill your agent uses when the user wants to write, run, or troubleshoot automated regression tests for Protheus routines with ADVPR (Advanced Protheus Robot) -- covering FWTestHelper API…
Protheus Business
thalysjuvenal/advpl-specialist
A skill your agent uses when the user needs to understand a TOTVS Protheus ERP business process, module workflow, or cross-module integration -- covering Compras (COM), Estoque (EST), Faturamento…
Protheus Locks Deadlocks
thalysjuvenal/advpl-specialist
A skill your agent uses when the user needs to understand, diagnose, or prevent Protheus record locks and deadlocks -- covering RecLock/MsUnlock/SoftLock/LockByName semantics, BeginTran/EndTran…
Related
Works with
Categories
Questions about Query Builder
What does Query Builder do?
A skill your agent uses when the user needs to build, choose the pattern for, or optimize a SQL query against Protheus ERP tables -- covering Workarea (DbSelectArea/DbSeek) vs Embedded SQL vs…. Query Builder is an agent skill from thalysjuvenal/advpl-specialist. Use when the user needs to build, choose the pattern for, or optimize a SQL query against Protheus ERP tables -- covering Workarea (DbSelectArea/DbSeek) vs Embedded SQL vs TCSqlExec pattern choice, mandatory DELET/xFilial filters, SIX index-aligned WHERE ordering, FWPreparedStatement parameterization to prevent SQL injection, and cross-database (PostgreSQL/MSSQL/Oracle) portability.
When should I use Query Builder?
Query Builder fits situations like: the user needs to build; choose the pattern for; optimize a SQL query against Protheus ERP tables -- covering Workarea (DbSelectArea/DbSeek) vs Embedded SQL vs TCSqlExec pattern choice; mandatory DELET/xFilial filters.
How do I install Query Builder in Claude Code?
Run `npx skills add thalysjuvenal/advpl-specialist --skill query-builder -a claude-code`. Or copy the skill folder (skills/query-builder in thalysjuvenal/advpl-specialist) into .claude/skills/query-builder in your project. Claude Code loads it when a task matches its description.
How do I install Query Builder in Codex?
Run `npx skills add thalysjuvenal/advpl-specialist --skill query-builder -a codex`. Or copy the skill folder (skills/query-builder in thalysjuvenal/advpl-specialist) into .agents/skills/query-builder in your project. Codex loads it when a task matches its description.
Can I use Query Builder in Cursor, Gemini CLI or GitHub Copilot?
Cursor, Gemini CLI, GitHub Copilot and OpenCode also load SKILL.md folders. With the skills CLI, run `npx skills add thalysjuvenal/advpl-specialist --skill query-builder -a cursor` (or -a gemini-cli, github-copilot or opencode for the others). To copy it by hand, put the folder in .cursor/skills/query-builder, .gemini/skills/query-builder, .github/skills/query-builder and .opencode/skills/query-builder in your project.
What does Query Builder need to run?
SKILL.md names no scripts, command-line tools or credentials: Query Builder is instructions for the agent only.
Does Query Builder access the network?
SKILL.md contains no URLs. Any network use would come from the scripts or tools the agent runs. This is read from the text; nothing was executed.
Is Query Builder safe to install?
Our automated static check of SKILL.md found no risky patterns, such as piping downloads into a shell, reading credential files or hidden Unicode. It is not a guarantee. Review the folder before installing.
What licence does Query Builder use?
Query Builder is published under the MIT licence (the repository's licence). It allows redistribution, so the full SKILL.md is shown on this page.
How many tokens does Query Builder use?
About 594 tokens (SKILL.md is roughly 2.4k characters). Agents keep only the skill's name and description in context until a task matches; then they load SKILL.md in full.
What are the alternatives to Query Builder?
Skills that share tags, products or a category with Query Builder: SQL Code Review (totvs/engpro-advpl-tlpp-skills, 143 stars), SQL Code Review (github/awesome-copilot, 40k stars), Frappe Syntax Query Builder (Impertio-Studio/Frappe_Claude_Skill_Package, 188 stars) and Matlab Use Database (matlab/matlab-agentic-toolkit, 1.1k stars). The comparison table on this page puts their stars, adoption, token cost, safety result and licence side by side.
Who maintains Query Builder?
thalysjuvenal (a GitHub user) maintains it in thalysjuvenal/advpl-specialist, which has 186 GitHub stars. The repository holds 19 skills in this directory. The repository was last updated on September 14, 2026.
Source: thalysjuvenal/advpl-specialist on GitHub. Facts on this page come from the repository at the commit we read; the author's words are quoted as theirs.