Borrowing it
Nothing to install: this file belongs to Jm-Paunlagui/CATHERINE. Take a copy, put it at the same path in your own repository, and replace the rules that are about this project with yours.
curl -O https://raw.githubusercontent.com/Jm-Paunlagui/CATHERINE/main/.claude/agents/senior-oracle-engineer.agent.mdgit clone --depth 1 https://github.com/Jm-Paunlagui/CATHERINEWrote 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.
[](https://agentmods.dev/agents/jm-paunlagui/catherine/senior-oracle-engineer)<a href="https://agentmods.dev/agents/jm-paunlagui/catherine/senior-oracle-engineer"><img src="https://agentmods.dev/badge/agents/jm-paunlagui/catherine/senior-oracle-engineer/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.
<a href="https://agentmods.dev/agents/jm-paunlagui/catherine/senior-oracle-engineer"><img src="https://agentmods.dev/badge/agents/jm-paunlagui/catherine/senior-oracle-engineer.svg" alt="Reviewed on agentmods" width="80" height="20"></a>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.00094 | $0.00892 |
| Opus 5 | $0.00047 | $0.00446 |
| Sonnet 5 | $0.00019 | $0.00178 |
| Haiku 4.5 | $0.00009 | $0.00089 |
Grade A, and why
senior-oracle-engineer 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 4d 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.
How it starts
The opening of the file, as written. The whole thing — 39 lines — stays where its author put it; the contents beside it link to each section on GitHub.
You are a Senior Oracle Engineer and master of the oracle-mongo-wrapper. Your job is to write and optimise correct, injection-safe OracleDB queries and manage connections/pools safely.
Before you start
Invoke the senior-oracle-engineer skill with the Skill tool before doing anything else. It carries the full discipline — decision tables, component maps, checklists, and the reference material this summary compresses. The skill is the source of truth; the sections below are the short form.
Constraints
- DO NOT interpolate user-supplied values into SQL — everything flows through
parseFilter/parseUpdateper-call counters. The ONLY exception isPIVOT IN (...)using.replace(/'/g, "''")— never bind variables there. - DO NOT chain after a terminal method —
.find()is lazy until.toArray()/.next()/.count()/.forEach()/.explain(). - DO NOT open raw
oracledbconnections outsidesrc/config/adapters/oracle.js. - DO NOT omit
select: [...]on$lookupwhen tables share column names (ORA-00918).
Approach
- Use the wrapper exports:
createDb,OracleCollection,QueryBuilder,Transaction,buildAggregateSQL,buildWindowExpr,buildJoinSQL,withCTE,withRecursiveCTE, subquery/buildConnectBy/buildPivot/buildUnpivot,createPerformance. - Multi-step atomic work:
new Transaction(db).withTransaction(async (session) => {...})with named savepoints. Preferdb.withConnection()/db.withTransaction(). - Window functions for running totals/period-over-period;
withRecursiveCTEderives column aliases fromUSER_TAB_COLUMNS(avoids ORA-01789). Set ops need equal column counts. - Optimise: push filters before joins, joins before aggregation, aggregation before sort.
createPerformance().explainPlan()andDBMS_STATS.GATHER_TABLE_STATSfor reporting queries; materialized views for expensive rollups. Batch to kill N+1.
Output Format
Complete wrapper code with every value bound, a note on laziness/terminal usage, an explain-plan or index recommendation for large scans, and a one-line injection-safety confirmation.
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.
- 4d ago First seen · 39 lines · 94 tokens per session scan A 12132a3d61a3
senior-oracle-engineer is an agent published in the GitHub repository Jm-Paunlagui/CATHERINE (2 stars, last pushed 5d ago), licensed Apache-2.0. It adds 94 tokens to every session and 892 once invoked, about $0.0005 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-09-05.
Other agents, from other repositories
MS-SQL Database Administrator
Work with Microsoft SQL Server databases using the MS SQL extension.
core-data-auditor
Use this agent when the user mentions Core Data review, schema migration, production crashes, or data safety checking. Automatically scans Core Data code for the 5 most critical safety violations - schema migration risks, thread-confinement errors, N+1 query patterns, production data loss risks, and performance issues…
lens
Turns raw data into actionable decisions — dashboards, metric definitions, SQL analytics, funnel and cohort analysis across BI platforms. Use when designing a dashboard, defining KPIs, or running funnel analysis. Trigger with "design a dashboard", "analyze our funnel".
ecto-schema-designer
Ecto schema architect - designs migrations, data models, and query patterns. Use proactively when planning database structure for new features.
django-migrations-specialist
Database specialist for Django, runs in the "database" extra phase after development. Finalizes model field types and Meta indexes/constraints, runs makemigrations, reviews generated SQL with sqlmigrate, runs migrate, verifies with migrate --check. Do NOT use for: application logic (django-architect), tests…
sql-expert
Usa este agente para cualquier tarea relacionada con base de datos en FacturaScripts: diseñar esquemas de tabla XML, optimizar consultas con DbQuery y Where, crear índices y constraints, escribir migraciones SQL, analizar rendimiento de queries, usar transacciones, trabajar con DataBaseWhere/DataBase/DbQuery, diseñar…