What is oracle-trivadis-ptbr?

A review guide for Oracle PL/SQL code based on Trivadis Guidelines 4.4, with naming and code-structure rules in Brazilian Portuguese.

Use it to review PL/SQL, choose prefixes for variables and cursors, name database objects, audit older code, and run a pre-deployment checklist.

It helps find naming and style differences before code reaches production or a change request is approved.

oracle-trivadis-ptbr — Skill for Claude Code and Codex by Maxwbh

Install

Getting it into your agent

One page per mod, every tool's command on it. A separate URL per tool would split the same page into five that compete with each other.

Any agent

npx skills add Maxwbh/oracle-skills-ptbr --skill oracle-trivadis-ptbr

Clone the repo

git clone --depth 1 https://github.com/Maxwbh/oracle-skills-ptbr

Made for: Claude Code, Codex.

Wrote this? Show the measurements

A badge with what this costs and how it scanned, read live from this page, so it follows the numbers instead of freezing them. Markdown for a README, HTML for a documentation site or a project page.

README.md

[![agentmods](https://agentmods.dev/badge/skills/maxwbh/oracle-skills-ptbr/oracle-trivadis-ptbr/github.svg)](https://agentmods.dev/skills/maxwbh/oracle-skills-ptbr/oracle-trivadis-ptbr)

Your own site

<a href="https://agentmods.dev/skills/maxwbh/oracle-skills-ptbr/oracle-trivadis-ptbr"><img src="https://agentmods.dev/badge/skills/maxwbh/oracle-skills-ptbr/oracle-trivadis-ptbr/github.svg" alt="Measured on agentmods" height="20"></a>

Or the 80×15 button, for a site that already has a row of RSS and ATOM ones. Only the verdict fits; the numbers stay here.

Your own site · 80×15

<a href="https://agentmods.dev/skills/maxwbh/oracle-skills-ptbr/oracle-trivadis-ptbr"><img src="https://agentmods.dev/badge/skills/maxwbh/oracle-skills-ptbr/oracle-trivadis-ptbr.svg" alt="Reviewed on agentmods" width="80" height="20"></a>

Per session 170 Skills are progressive disclosure: only the name and description are preloaded; the body loads when the skill is used.

When invoked 1,695 The whole file, excluding the scripts and references it only reads on demand.

Security scan A 0 findings. A grade says what 26 rules found in the file — not that it is safe.

Origin original No closer match found in the catalogue.

Token cost

What it costs to keep this loaded

Counted locally with the o200k_base tokenizer, which is exact for GPT models; Claude uses its own tokenizer and its counts differ. Treat this as one consistent yardstick across the catalogue rather than a bill. Prices are per million input tokens.

Model	Per session	Once invoked
Fable 5.1	$0.00170	$0.01695
Opus 5	$0.00085	$0.00847
Sonnet 5	$0.00034	$0.00339
Haiku 4.5	$0.00017	$0.00169

Measured 12d ago against content hash a9f454a373f9, method: parsed. Prices are Anthropic first-party input rates as of 2026-09-12, from the pricing page.

Security

Grade A, and why

oracle-trivadis-ptbr scanned grade A with 0 findings against 26 rules in 11 categories — prompt injection, anti-refusal, data exfiltration, privilege escalation, supply chain, agent snooping, system-prompt leakage, SSRF and excessive agency — measured 12d ago.

A static scan of the body, not an audit. Every finding is printed with the line that produced it so you can judge whether it matters here. A mod is markdown that instructs an agent; that is exactly why what it instructs is worth reading.

Nothing flagged

None of the 26 patterns this scan looks for appear in this file: no shell pipes, no recursive deletes, no credential paths, no hidden text, no instruction-override or anti-refusal phrasing, no agent-config snooping. That is not a guarantee, it is the absence of the things that are checkable.

skills/oracle-trivadis-ptbr/SKILL.md · 100 lines

How it starts

The opening of the file, as written. The whole thing — 100 lines — stays where its author put it; the contents beside it link to each section on GitHub.

oracle-trivadis-ptbr — v2.0.0

Trivadis PL/SQL Guidelines 4.4 — padrão de nomenclatura, estrutura de código e checklist de revisão.

Desenvolvido por: Maxwell da Silva Oliveira — M&S do Brasil LTDA

Áreas cobertas

Área	Reference
Trivadis Guidelines 4.4	`references/plsql-trivadis-guidelines.md`

Referência cruzada: Esta skill documenta o padrão. As skills oracle-plsql-ptbr, oracle-apex-ptbr, oracle-ords-ptbr, oracle-dba-ptbr e oracle-tuning-ptbr aplicam Trivadis automaticamente em todo código gerado.

Quando ativar

"Esse código segue Trivadis?" — revisão explícita de padrão
"Qual prefixo usar para essa variável/cursor/constante?"
"Como nomear essa tabela/coluna/package em PT-BR?"
Checklist pré-deploy / pré-GMUD: validar naming antes de subir para produção
Auditoria de código legado: identificar desvios do padrão
Dúvidas sobre convenções: exceções locais vs globais, packages nativos Oracle em inglês, status values em PT-BR

Não usar para: geração de código PL/SQL (→ oracle-plsql-ptbr), APEX, ORDS, DBA ops, tuning.

Prefixos canônicos Trivadis

Prefixo	Uso	Exemplo
`g_`	Variável global (package)	`g_ultima_execucao`
`gc_`	Constante global (package)	`gc_nome_pacote`
`l_`	Variável local	`l_total_pago`
`lc_`	Constante local	`lc_nome_unidade`
`p_`	Parâmetro	`p_id_fatura`
`r_`	Record	`r_fatura`
`t_`	Type (collection, record)	`t_lista_ids`
`co_`	Cursor	`co_faturas_pendentes`
`e_`	Exception user-defined	`e_estado_invalido`

Checklist de revisão — o que verificar

Naming: variáveis, procedures, functions, tabelas e colunas em PT-BR (exceto keywords Oracle, pacotes nativos, prefixos Trivadis)
Prefixos Trivadis: g_, gc_, l_, lc_, p_, r_, t_, co_, e_ aplicados corretamente
Keywords em inglês: BEGIN, END, EXCEPTION, BULK COLLECT, FORALL, MERGE INTO nunca traduzidos
Pacotes nativos em inglês: DBMS_LOB, APEX_JSON, UTL_HTTP, DBMS_STATS nunca traduzidos
lc_nome_unidade declarado em toda procedure pública
gc_nome_pacote declarado no package body
Comentários em PT-BR — explicam o PORQUÊ, não o QUÊ
Status values em PT-BR: 'PENDENTE', 'PAGO', 'CANCELADO', 'ATIVO', 'PROCESSADO'
WHEN OTHERS THEN NULL ausente — sempre propagar com contexto
DBMS_OUTPUT ausente em produção — substituído por Logger

Read the full file on GitHub · 100 lines

Files

What ships with it

1 file beside SKILL.md in the same directory: the scripts, references and assets a skill reads on demand. Not counted in the per-session cost; read them before you install if any of them is executable.

references/plsql-trivadis-guidelines.md 13 KB

Changes

What this file has done since we first saw it

Hashed on every crawl. A supply-chain change to an agent config is a question of when, not whether, so the history is kept rather than the latest state alone.

12d ago First seen · 100 lines · 170 tokens per session scan A a9f454a373f9

Subscribe to this mod's changes

oracle-trivadis-ptbr is a skill published in the GitHub repository Maxwbh/oracle-skills-ptbr (2 stars, last pushed 3mo ago), licensed MIT. It adds 170 tokens to every session and 1,695 once invoked, about $0.0009 per session on Opus 5. A static security scan graded it A with 0 findings. No closer match exists in the catalogue, so it is treated as the original; first seen 2026-08-31.

Code review Databases apex claude-skill oracle ords plsql pt-br

oracle-expert

Expert in Oracle Database, PL/SQL programming, Oracle RAC, Data Guard, performance tuning, backup/recovery, and enterprise database administration. Use when the user mentions database, enterprise, ERP, PL/SQL, Oracle RAC, or Data Guard, or when the task involves Oracle Architecture, PL/SQL Programming, Performance &…

personamanagmentlayer/pcl · 81 tokens

triage-contributor-pr

Triage open pull requests from external contributors to prisma/prisma and produce a per-PR verdict with evidence. Use when a maintainer asks to triage, evaluate, assess, or review the queue of incoming contributor PRs, to decide whether a fork PR is safe to run CI on, to check whether a PR is in scope for its version…

prisma/orm · 131 tokens

review-implement-phase

Implements triaged review actions, commits focused fixes, and posts Done plus resolves threads. Use when the user wants only the implementation phase of the review-framework workflow.

prisma/orm · 38 tokens

no-bare-casts

Writing as in TypeScript or TSX production code, modifying a file that contains a bare as cast, silencing a type error with a cast, encountering as unknown as, or reviewing a cast site.

prisma/orm · 52 tokens

review-prs

Review a GitHub pull request in the googleapis/mcp-toolbox repo against the team's reviewer checklist: PR title/description conventions, linked issue, logic errors and unhandled edge cases, breaking changes, test coverage, docs updates, security (input handling), and new dependencies. Use whenever a maintainer asks…

googleapis/mcp-toolbox · 162 tokens

migration-review

Review database migration files when a change adds or modifies paths under migrations/. Use it before merge to collect forward, rollback, locking, and data-safety evidence.

rohitg00/ai-engineering-from-scratch · 35 tokens