🗄️
AI EngineeringShell

Embedded SQL

by thalysjuvenal

Embedded SQL 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 Embedded SQL
Copy Embedded SQL 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/embedded-sql ~/.claude/skills/embedded-sql

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/embedded-sql/SKILL.md in thalysjuvenal/advpl-specialist
Installs to
~/.claude/skills/embedded-sql
Collection
One of 18 skills cataloged from this repository
Category
AI Engineering3278 skills

What Embedded SQL does

Embedded SQL helps write, review, and migrate SQL in ADVPL/TLPP using BeginSQL/EndSQL blocks, macro expressions, joins, aggregations, subqueries, and TCSqlExec. Use it when converting TCQuery code or building safer queries with filial and deletion filters.

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

Documentation

README

Embedded SQL in ADVPL/TLPP

This skill covers writing SQL inside ADVPL/TLPP using BeginSQL ... EndSQL blocks and their special macro expressions -- %table:TABLE% for physical table resolution, %xfilial:TABLE% for branch filtering, %notDel% for logical-deletion filtering, %exp:EXPRESSION% for safe variable binding, and %Order:TABLE% for primary-key ordering. It also covers column type declarations, JOIN and aggregation patterns, subqueries, and migrating legacy TCQuery string-concatenation code to Embedded SQL.

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

Frequently asked about Embedded SQL

  • What else does thalysjuvenal publish alongside Embedded SQL?

    Embedded SQL 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 Embedded SQL 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 Embedded SQL compare to other AI Engineering skills?

    Embedded SQL ranks #2994 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 Embedded SQL against them. Open each page to compare what they document and how they install.

More from thalysjuvenal/advpl-specialist

Embedded SQL 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