Database Migrations SQL Migrations
rmyndharis/antigravity-skills
SQL database migrations with zero-downtime strategies for PostgreSQL, MySQL, SQL Server
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…
Install Protheus Locks Deadlocks
$ npx skills add thalysjuvenal/advpl-specialist --skill protheus-locks-deadlocks -a claude-codeProject install by default; add -g for ~/.claude/skills/.
$ gh skill install thalysjuvenal/advpl-specialist protheus-locks-deadlocks --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/protheus-locks-deadlocks .claude/skills/protheus-locks-deadlocks && 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 "protheus-locks-deadlocks" agent skill from https://github.com/thalysjuvenal/advpl-specialist/tree/main/skills/protheus-locks-deadlocks into .claude/skills/protheus-locks-deadlocks/ in this project. Copy the whole folder (SKILL.md and every file beside it), keep the folder name "protheus-locks-deadlocks", 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/protheus-locks-deadlocksType 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 protheus-locks-deadlocks -a codexProject install goes to .agents/skills/; add -g for ~/.codex/skills/.
$ gh skill install thalysjuvenal/advpl-specialist protheus-locks-deadlocks --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/protheus-locks-deadlocks .agents/skills/protheus-locks-deadlocks && rm -rf skills-srcUse ~/.agents/skills/ instead of .agents/skills for a personal install.
Codex skills documentation · loads skills from .agents/skills/
Install the "protheus-locks-deadlocks" agent skill from https://github.com/thalysjuvenal/advpl-specialist/tree/main/skills/protheus-locks-deadlocks into .agents/skills/protheus-locks-deadlocks/ in this project. Copy the whole folder (SKILL.md and every file beside it), keep the folder name "protheus-locks-deadlocks", 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 protheus-locks-deadlocks -a cursorProject install goes to .agents/skills/; add -g for ~/.cursor/skills/.
$ gh skill install thalysjuvenal/advpl-specialist protheus-locks-deadlocks --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/protheus-locks-deadlocks .cursor/skills/protheus-locks-deadlocks && 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 "protheus-locks-deadlocks" agent skill from https://github.com/thalysjuvenal/advpl-specialist/tree/main/skills/protheus-locks-deadlocks into .cursor/skills/protheus-locks-deadlocks/ in this project. Copy the whole folder (SKILL.md and every file beside it), keep the folder name "protheus-locks-deadlocks", 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/protheus-locks-deadlocks--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 protheus-locks-deadlocks -a gemini-cliProject install goes to .agents/skills/; add -g for ~/.gemini/skills/.
$ gh skill install thalysjuvenal/advpl-specialist protheus-locks-deadlocks --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/protheus-locks-deadlocks .gemini/skills/protheus-locks-deadlocks && 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 "protheus-locks-deadlocks" agent skill from https://github.com/thalysjuvenal/advpl-specialist/tree/main/skills/protheus-locks-deadlocks into .gemini/skills/protheus-locks-deadlocks/ in this project. Copy the whole folder (SKILL.md and every file beside it), keep the folder name "protheus-locks-deadlocks", 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 protheus-locks-deadlocksInstalls 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 protheus-locks-deadlocks -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/protheus-locks-deadlocks .github/skills/protheus-locks-deadlocks && 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 "protheus-locks-deadlocks" agent skill from https://github.com/thalysjuvenal/advpl-specialist/tree/main/skills/protheus-locks-deadlocks into .github/skills/protheus-locks-deadlocks/ in this project. Copy the whole folder (SKILL.md and every file beside it), keep the folder name "protheus-locks-deadlocks", 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 protheus-locks-deadlocks -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 protheus-locks-deadlocks --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/protheus-locks-deadlocks .opencode/skills/protheus-locks-deadlocks && 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 "protheus-locks-deadlocks" agent skill from https://github.com/thalysjuvenal/advpl-specialist/tree/main/skills/protheus-locks-deadlocks into .opencode/skills/protheus-locks-deadlocks/ in this project. Copy the whole folder (SKILL.md and every file beside it), keep the folder name "protheus-locks-deadlocks", 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
protheus-locks-deadlocks- GitHub stars
- 186
- Token cost
- ~553 tokens
- SKILL.md length
- 188 words
- Files
- 4
- Skills in repo
- 19
- Repo updated
- First seen
- Licence
- MIT
At a glance
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…
- The user needs to understand
- Instructions only: no scripts, shell commands, URLs or credentials in SKILL.md
- Prevent Protheus record locks and deadlocks -- covering RecLock/MsUnlock/SoftLock/LockByName semantics
- BeginTran/EndTran transaction scoping
What it does
Protheus Locks Deadlocks is an agent skill from thalysjuvenal/advpl-specialist. Use when the user needs to understand, diagnose, or prevent Protheus record locks and deadlocks -- covering RecLock/MsUnlock/SoftLock/LockByName semantics, BeginTran/EndTran transaction scoping, lock leak and deadlock diagnostics (TopMemoStatus, MonitorActiveLocks, DBAccess monitor, SQL Server/PostgreSQL/Oracle lock queries), and prevention patterns (BEGIN SEQUENCE/RECOVER, lock ordering). Also triggers on Portuguese phrasing like "registro travado", "trava de registro", "deadlock", "erro de lock", "travamento no…
Its SKILL.md is about 550 tokens, which your agent loads only when the skill is triggered. The skill folder holds 3 other files (for example `diagnostics.md`, `patterns-prevention.md` and `reference.md`).
It sits in Databases. It works with Microsoft SQL Server, PostgreSQL and 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 understand
- Prevent Protheus record locks and deadlocks -- covering RecLock/MsUnlock/SoftLock/LockByName semantics
- BeginTran/EndTran transaction scoping
- Lock leak and deadlock diagnostics (TopMemoStatus
Example prompts
- “registro travado”
- “trava de registro”
- “deadlock”
- “/protheus-locks-deadlocks”
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
Protheus Locks Deadlocks loads about 553 tokens when it runs. Until then it costs about 153 tokens; SKILL.md has 188 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). 188 words, ~553 tokens.
Download SKILL.mdSave it as
.claude/skills/protheus-locks-deadlocks/SKILL.md (or your agent's skills folder). This skill also uses 3 other files; get the full folder from GitHub.- name
- protheus-locks-deadlocks
- description
- Use when the user needs to understand, diagnose, or prevent Protheus record locks and deadlocks -- covering RecLock/MsUnlock/SoftLock/LockByName semantics, BeginTran/EndTran transaction scoping, lock leak and deadlock diagnostics (TopMemoStatus, MonitorActiveLocks, DBAccess monitor, SQL Server/PostgreSQL/Oracle lock queries), and prevention patterns (BEGIN SEQUENCE/RECOVER, lock ordering). Also triggers on Portuguese phrasing like "registro travado", "trava de registro", "deadlock", "erro de lock", "travamento no Protheus", "quem esta travando o registro", or "RecLock nao libera".
Protheus Locks & Deadlocks
This skill documents the Protheus hybrid locking model -- record-level Workarea locks (RecLock/MsUnlock) coordinated by DBAccess on top of the underlying RDBMS (PostgreSQL, MSSQL, Oracle) -- and how to diagnose and prevent the lock leaks, contention, and deadlocks that are among the most common production issues. It covers lock API semantics (RecLock, MsUnlock/MsUnlockAll, SoftLock, LockByName, TCSqlExec, BeginTran/EndTran/DisarmTransaction), safe transaction scoping with BEGIN SEQUENCE/RECOVER, and live diagnostic procedures per database engine.
Activate this skill when the user reports a "Record locked by user XYZ" error, needs to investigate performance degradation under concurrent load, is writing or reviewing code that locks records, or is designing a batch job over large data sets where lock ordering matters. It does not cover query design or %nolock% usage in Embedded SQL (see query-builder), general runtime/performance debugging unrelated to locking (see advpl-debugging), or BeginSQL/EndSQL macro syntax (see embedded-sql).
| Reference file | Read when |
|---|---|
| reference.md | Always -- lock types table, core lock/transaction APIs, when-to-use guidance |
| patterns-prevention.md | Writing or refactoring code that locks records -- BEGIN SEQUENCE/RECOVER, SoftLock, transaction scoping, lock ordering rules |
| diagnostics.md | Investigating live lock contention or deadlocks -- TopMemoStatus, MonitorActiveLocks, DBAccess monitor, engine-specific SQL lock queries |
© 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 3 other files in skills/protheus-locks-deadlocks of thalysjuvenal/advpl-specialist.
- SKILL.md
- diagnostics.md
- patterns-prevention.md
- reference.md
Open the folder on GitHubat commit d80599b
Compare with similar skills
Protheus Locks Deadlocks 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 |
|---|---|---|---|---|---|---|
| Protheus Locks Deadlocks this skillthalysjuvenal/advpl-specialist | 186 | — | ~553 | Automated safety check: Pass | MIT | |
| Database Migrations SQL Migrationsrmyndharis/antigravity-skills | 1.7k | 3 repos | ~577 | Automated safety check: Notes | MIT | |
| SQL ProJeffallan/claude-skills | 12k | — | ~1.3k | Automated safety check: Pass | MIT | |
| SQL Code Reviewtotvs/engpro-advpl-tlpp-skills | 143 | — | ~3.5k | Automated safety check: Pass | MIT | |
| SQL Optimizationgithub/awesome-copilot | 40k | 2 repos | ~2.3k | Automated safety check: Pass | MIT | |
| SQL Code Reviewgithub/awesome-copilot | 40k | 1 repos | ~2.2k | Automated safety check: Pass | MIT |
Similar skills
SQL Pro
Jeffallan/claude-skills
Optimizes SQL queries and designs schemas using CTEs, window functions, covering indexes and EXPLAIN ANALYZE, with notes on dialect differences between major databases.
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).
- Official
SQL Optimization
github/awesome-copilot
Universal SQL performance optimization assistant for comprehensive query tuning, indexing strategies, and database performance analysis across all SQL databases (MySQL, PostgreSQL, SQL Server…
- 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).
- Official
Cloud SQL Basics
google/skills
This file generates or explains Cloud SQL resources. An agent skill from google/skills.
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 Reference
thalysjuvenal/advpl-specialist
A skill your agent uses when the user needs to look up a TOTVS Protheus native function's syntax/parameters/return value, the SX data dictionary structure (SX1-SX9, SIX), REST API endpoint patterns…
Related
Works with
Categories
Questions about Protheus Locks Deadlocks
What does Protheus Locks Deadlocks do?
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…. Protheus Locks Deadlocks is an agent skill from thalysjuvenal/advpl-specialist. Use when the user needs to understand, diagnose, or prevent Protheus record locks and deadlocks -- covering RecLock/MsUnlock/SoftLock/LockByName semantics, BeginTran/EndTran transaction scoping, lock leak and deadlock diagnostics (TopMemoStatus, MonitorActiveLocks, DBAccess monitor, SQL Server/PostgreSQL/Oracle lock queries), and prevention patterns (BEGIN SEQUENCE/RECOVER, lock ordering).
When should I use Protheus Locks Deadlocks?
Protheus Locks Deadlocks fits situations like: the user needs to understand; prevent Protheus record locks and deadlocks -- covering RecLock/MsUnlock/SoftLock/LockByName semantics; beginTran/EndTran transaction scoping; lock leak and deadlock diagnostics (TopMemoStatus.
How do I install Protheus Locks Deadlocks in Claude Code?
Run `npx skills add thalysjuvenal/advpl-specialist --skill protheus-locks-deadlocks -a claude-code`. Or copy the skill folder (skills/protheus-locks-deadlocks in thalysjuvenal/advpl-specialist) into .claude/skills/protheus-locks-deadlocks in your project. Claude Code loads it when a task matches its description.
How do I install Protheus Locks Deadlocks in Codex?
Run `npx skills add thalysjuvenal/advpl-specialist --skill protheus-locks-deadlocks -a codex`. Or copy the skill folder (skills/protheus-locks-deadlocks in thalysjuvenal/advpl-specialist) into .agents/skills/protheus-locks-deadlocks in your project. Codex loads it when a task matches its description.
Can I use Protheus Locks Deadlocks 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 protheus-locks-deadlocks -a cursor` (or -a gemini-cli, github-copilot or opencode for the others). To copy it by hand, put the folder in .cursor/skills/protheus-locks-deadlocks, .gemini/skills/protheus-locks-deadlocks, .github/skills/protheus-locks-deadlocks and .opencode/skills/protheus-locks-deadlocks in your project.
What does Protheus Locks Deadlocks need to run?
SKILL.md names no scripts, command-line tools or credentials: Protheus Locks Deadlocks is instructions for the agent only.
Does Protheus Locks Deadlocks 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 Protheus Locks Deadlocks 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 Protheus Locks Deadlocks use?
Protheus Locks Deadlocks 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 Protheus Locks Deadlocks use?
About 553 tokens (SKILL.md is roughly 2.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 Protheus Locks Deadlocks?
Skills that share tags, products or a category with Protheus Locks Deadlocks: Database Migrations SQL Migrations (rmyndharis/antigravity-skills, 1.7k stars), SQL Pro (Jeffallan/claude-skills, 12k stars), SQL Code Review (totvs/engpro-advpl-tlpp-skills, 143 stars) and SQL Optimization (github/awesome-copilot, 40k stars). The comparison table on this page puts their stars, adoption, token cost, safety result and licence side by side.
Who maintains Protheus Locks Deadlocks?
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.