Evolving The Data Model
TriliumNext/Trilium
A skill your agent uses when adding a DB migration or a new column/field to a Becca entity in Trilium ("add a migration", "new column on notes/attributes", "ALTER TABLE", "add a field to…
A skill your agent uses when the user needs to write, review, or migrate SQL queries in ADVPL/TLPP using BeginSQL/EndSQL blocks and macro expressions (%table%, %xfilial%, %notDel%, %exp%, %Order%)…
Install Embedded SQL
$ npx skills add thalysjuvenal/advpl-specialist --skill embedded-sql -a claude-codeProject install by default; add -g for ~/.claude/skills/.
$ gh skill install thalysjuvenal/advpl-specialist embedded-sql --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/embedded-sql .claude/skills/embedded-sql && 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 "embedded-sql" agent skill from https://github.com/thalysjuvenal/advpl-specialist/tree/main/skills/embedded-sql into .claude/skills/embedded-sql/ in this project. Copy the whole folder (SKILL.md and every file beside it), keep the folder name "embedded-sql", 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/embedded-sqlType 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 embedded-sql -a codexProject install goes to .agents/skills/; add -g for ~/.codex/skills/.
$ gh skill install thalysjuvenal/advpl-specialist embedded-sql --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/embedded-sql .agents/skills/embedded-sql && rm -rf skills-srcUse ~/.agents/skills/ instead of .agents/skills for a personal install.
Codex skills documentation · loads skills from .agents/skills/
Install the "embedded-sql" agent skill from https://github.com/thalysjuvenal/advpl-specialist/tree/main/skills/embedded-sql into .agents/skills/embedded-sql/ in this project. Copy the whole folder (SKILL.md and every file beside it), keep the folder name "embedded-sql", 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 embedded-sql -a cursorProject install goes to .agents/skills/; add -g for ~/.cursor/skills/.
$ gh skill install thalysjuvenal/advpl-specialist embedded-sql --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/embedded-sql .cursor/skills/embedded-sql && 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 "embedded-sql" agent skill from https://github.com/thalysjuvenal/advpl-specialist/tree/main/skills/embedded-sql into .cursor/skills/embedded-sql/ in this project. Copy the whole folder (SKILL.md and every file beside it), keep the folder name "embedded-sql", 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/embedded-sql--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 embedded-sql -a gemini-cliProject install goes to .agents/skills/; add -g for ~/.gemini/skills/.
$ gh skill install thalysjuvenal/advpl-specialist embedded-sql --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/embedded-sql .gemini/skills/embedded-sql && 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 "embedded-sql" agent skill from https://github.com/thalysjuvenal/advpl-specialist/tree/main/skills/embedded-sql into .gemini/skills/embedded-sql/ in this project. Copy the whole folder (SKILL.md and every file beside it), keep the folder name "embedded-sql", 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 embedded-sqlInstalls 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 embedded-sql -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/embedded-sql .github/skills/embedded-sql && 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 "embedded-sql" agent skill from https://github.com/thalysjuvenal/advpl-specialist/tree/main/skills/embedded-sql into .github/skills/embedded-sql/ in this project. Copy the whole folder (SKILL.md and every file beside it), keep the folder name "embedded-sql", 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 embedded-sql -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 embedded-sql --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/embedded-sql .opencode/skills/embedded-sql && 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 "embedded-sql" agent skill from https://github.com/thalysjuvenal/advpl-specialist/tree/main/skills/embedded-sql into .opencode/skills/embedded-sql/ in this project. Copy the whole folder (SKILL.md and every file beside it), keep the folder name "embedded-sql", 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
embedded-sql- GitHub stars
- 185
- Token cost
- ~509 tokens
- SKILL.md length
- 176 words
- Files
- 2
- Skills in repo
- 19
- Repo updated
- First seen
- Licence
- MIT
At a glance
A skill your agent uses when the user needs to write, review, or migrate SQL queries in ADVPL/TLPP using BeginSQL/EndSQL blocks and macro expressions (%table%, %xfilial%, %notDel%, %exp%, %Order%)…
- The user needs to write
- Instructions only: no scripts, shell commands, URLs or credentials in SKILL.md
- Migrate SQL queries in ADVPL/TLPP using BeginSQL/EndSQL blocks and macro expressions (%table%
- %Order%) instead of raw TCQuery string concatenation -- covering INNER/LEFT JOIN patterns
What it does
Embedded SQL is an agent skill from thalysjuvenal/advpl-specialist. Use when the user needs to write, review, or migrate SQL queries in ADVPL/TLPP using BeginSQL/EndSQL blocks and macro expressions (%table%, %xfilial%, %notDel%, %exp%, %Order%) instead of raw TCQuery string concatenation -- covering INNER/LEFT JOIN patterns, aggregations (SUM/COUNT/GROUP BY/HAVING), subqueries, column type declarations, DML via TCSqlExec, and SQL-injection prevention. Also triggers on Portuguese phrasing like "consulta SQL", "query embutida", "migrar TCQuery para BeginSQL", "escrever SELECT com…
Its SKILL.md is about 510 tokens, which your agent loads only when the skill is triggered. The skill folder holds 1 other file (for example `reference.md`).
It sits in Databases, covering SQL. It works with SQL. 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 write
- Migrate SQL queries in ADVPL/TLPP using BeginSQL/EndSQL blocks and macro expressions (%table%
- %Order%) instead of raw TCQuery string concatenation -- covering INNER/LEFT JOIN patterns
- Aggregations (SUM/COUNT/GROUP BY/HAVING)
Example prompts
- “consulta SQL”
- “query embutida”
- “migrar TCQuery para BeginSQL”
- “/embedded-sql”
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
Embedded SQL loads about 509 tokens when it runs. Until then it costs about 144 tokens; SKILL.md has 176 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). 176 words, ~509 tokens.
Download SKILL.mdSave it as
.claude/skills/embedded-sql/SKILL.md (or your agent's skills folder). This skill also uses 1 other file; get the full folder from GitHub.- name
- embedded-sql
- description
- Use when the user needs to write, review, or migrate SQL queries in ADVPL/TLPP using BeginSQL/EndSQL blocks and macro expressions (%table%, %xfilial%, %notDel%, %exp%, %Order%) instead of raw TCQuery string concatenation -- covering INNER/LEFT JOIN patterns, aggregations (SUM/COUNT/GROUP BY/HAVING), subqueries, column type declarations, DML via TCSqlExec, and SQL-injection prevention. Also triggers on Portuguese phrasing like "consulta SQL", "query embutida", "migrar TCQuery para BeginSQL", "escrever SELECT com filial e notDel", or "montar JOIN em ADVPL".
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.
Activate this skill whenever the user is writing a new query, reviewing an existing one for correctness/safety, or converting old concatenated-string SQL to the modern BeginSQL syntax. It also covers the restrictions and gotchas of BeginSQL (no * at line start, always include %notDel% and filial filtering, use GetNextAlias(), close aliases) and when to use TCSqlExec instead for INSERT/UPDATE/DELETE.
It does not cover general native function lookups unrelated to SQL (see protheus-reference), business-process context for which tables/fields to query (see protheus-business), or generating documentation for a routine that happens to contain SQL (see documentation-patterns).
| Reference file | Read when |
|---|---|
| reference.md | Always -- BeginSQL syntax, macro expressions, JOIN/aggregation/subquery patterns, DML via TCSqlExec, performance tips, and TCQuery migration |
© 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 1 other file in skills/embedded-sql of thalysjuvenal/advpl-specialist.
- SKILL.md
- reference.md
Open the folder on GitHubat commit d80599b
Compare with similar skills
Embedded SQL 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 |
|---|---|---|---|---|---|---|
| Embedded SQL this skillthalysjuvenal/advpl-specialist | 185 | — | ~509 | Automated safety check: Pass | MIT | |
| Evolving The Data ModelTriliumNext/Trilium | 38k | — | ~2.1k | Automated safety check: Pass | AGPL-3.0 | |
| SQL Optimization Patternsynulihao/AgentSkillOS | 617 | 10 repos | ~3.3k | Automated safety check: Pass | None | |
| SQL PortabilityHL7/sql-on-fhir | 150 | — | ~512 | Automated safety check: Pass | Custom licence | |
| DB Migrationskurealnum/dotfiles | 290 | — | ~820 | Automated safety check: Pass | None | |
| Contact FilterChatbotXIO/ChatbotX | 878 | — | ~2.5k | Automated safety check: Pass | Custom licence |
Similar skills
SQL Optimization Patterns
ynulihao/AgentSkillOS
Master SQL query optimization, indexing strategies, and EXPLAIN analysis to dramatically improve database performance and eliminate slow queries.
SQL Portability
HL7/sql-on-fhir
Analyse whether a SQL query is portable across database implementations using sqlglot transpilation.
DB Migrations
kurealnum/dotfiles
A skill your agent uses when generating or regenerating Drizzle migration files, changing database schema tables or columns, resolving migration sequence conflicts after rebase, reviewing migration…
Contact Filter
ChatbotXIO/ChatbotX
Work with the ChatbotX contact filter system — the shared filter model behind the contacts list, conversations, and broadcast audiences.
Add Utils Function
MichealWayne/fe-tools
Add or modify utility functions in fe-tools. An agent skill from MichealWayne/fe-tools.
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 Embedded SQL
What does Embedded SQL do?
A skill your agent uses when the user needs to write, review, or migrate SQL queries in ADVPL/TLPP using BeginSQL/EndSQL blocks and macro expressions (%table%, %xfilial%, %notDel%, %exp%, %Order%)…. Embedded SQL is an agent skill from thalysjuvenal/advpl-specialist. Use when the user needs to write, review, or migrate SQL queries in ADVPL/TLPP using BeginSQL/EndSQL blocks and macro expressions (%table%, %xfilial%, %notDel%, %exp%, %Order%) instead of raw TCQuery string concatenation -- covering INNER/LEFT JOIN patterns, aggregations (SUM/COUNT/GROUP BY/HAVING), subqueries, column type declarations, DML via TCSqlExec, and SQL-injection prevention.
When should I use Embedded SQL?
Embedded SQL fits situations like: the user needs to write; migrate SQL queries in ADVPL/TLPP using BeginSQL/EndSQL blocks and macro expressions (%table%; %Order%) instead of raw TCQuery string concatenation -- covering INNER/LEFT JOIN patterns; aggregations (SUM/COUNT/GROUP BY/HAVING).
How do I install Embedded SQL in Claude Code?
Run `npx skills add thalysjuvenal/advpl-specialist --skill embedded-sql -a claude-code`. Or copy the skill folder (skills/embedded-sql in thalysjuvenal/advpl-specialist) into .claude/skills/embedded-sql in your project. Claude Code loads it when a task matches its description.
How do I install Embedded SQL in Codex?
Run `npx skills add thalysjuvenal/advpl-specialist --skill embedded-sql -a codex`. Or copy the skill folder (skills/embedded-sql in thalysjuvenal/advpl-specialist) into .agents/skills/embedded-sql in your project. Codex loads it when a task matches its description.
Can I use Embedded SQL 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 embedded-sql -a cursor` (or -a gemini-cli, github-copilot or opencode for the others). To copy it by hand, put the folder in .cursor/skills/embedded-sql, .gemini/skills/embedded-sql, .github/skills/embedded-sql and .opencode/skills/embedded-sql in your project.
What does Embedded SQL need to run?
SKILL.md names no scripts, command-line tools or credentials: Embedded SQL is instructions for the agent only.
Does Embedded SQL 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 Embedded SQL 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 Embedded SQL use?
Embedded SQL 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 Embedded SQL use?
About 509 tokens (SKILL.md is roughly 2k 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 Embedded SQL?
Skills that share tags, products or a category with Embedded SQL: Evolving The Data Model (TriliumNext/Trilium, 38k stars), SQL Optimization Patterns (ynulihao/AgentSkillOS, 617 stars), SQL Portability (HL7/sql-on-fhir, 150 stars) and DB Migrations (kurealnum/dotfiles, 290 stars). The comparison table on this page puts their stars, adoption, token cost, safety result and licence side by side.
Who maintains Embedded SQL?
thalysjuvenal (a GitHub user) maintains it in thalysjuvenal/advpl-specialist, which has 185 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.