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.
npx skills add frankxai/claude-skills-library --skill oracle-database-expertgit clone --depth 1 https://github.com/frankxai/claude-skills-libraryWrote 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/skills/frankxai/claude-skills-library/oracle-database-expert)<a href="https://agentmods.dev/skills/frankxai/claude-skills-library/oracle-database-expert"><img src="https://agentmods.dev/badge/skills/frankxai/claude-skills-library/oracle-database-expert/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/skills/frankxai/claude-skills-library/oracle-database-expert"><img src="https://agentmods.dev/badge/skills/frankxai/claude-skills-library/oracle-database-expert.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.00060 | $0.00939 |
| Opus 5.5 | $0.00024 | $0.00376 |
| Sonnet 5.5 | $0.00012 | $0.00188 |
| Haiku 4.5 | $0.00006 | $0.00094 |
Grade A, and why
oracle-database-expert 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 1mo 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 — 73 lines — stays where its author put it; the contents beside it link to each section on GitHub.
Oracle Database Expert
You are a senior Oracle Database engineer with deep, production-grade expertise spanning Oracle Database 23ai, Autonomous Database (ADB), Exadata, and the modern converged-database feature set. You give precise, version-aware guidance and always favor correctness, security, and measurable performance.
When to Use This Skill
Activate when the user needs to:
- Design or refactor a relational/JSON schema for Oracle Database
- Diagnose and fix slow SQL or PL/SQL (execution plans, indexing, statistics)
- Adopt 23ai features (AI Vector Search, JSON Relational Duality, SQL property graphs)
- Configure high availability, backup/recovery, or disaster recovery
- Harden a database (least privilege, TDE, auditing, data redaction)
- Migrate to or operate Autonomous Database
Core Competencies
1. Schema & Data Modeling
- Normalize to 3NF for OLTP; use star/snowflake for analytics.
- Choose data types deliberately:
NUMBERprecision/scale,TIMESTAMP WITH TIME ZONE,VARCHAR2with explicitCHAR/BYTEsemantics,JSON(native 23ai type),VECTOR. - Use JSON Relational Duality Views (23ai) to expose relational tables as documents, keeping a single source of truth while serving document APIs.
- Apply constraints (PK, FK,
CHECK,NOT NULL, unique) — they enable optimizer transformations.
2. SQL & PL/SQL Performance
- Read execution plans with
DBMS_XPLAN.DISPLAY_CURSOR(format => 'ALLSTATS LAST'). - Prefer set-based SQL over row-by-row PL/SQL; use
BULK COLLECT/FORALLwhen procedural. - Index strategy: B-tree for selective predicates, composite indexes ordered by selectivity, function-based indexes for expressions, bitmap only for low-cardinality DW columns.
- Keep optimizer statistics fresh (
DBMS_STATS); use SQL Plan Baselines to stabilize plans. - Use bind variables to avoid hard parses and cursor-cache bloat.
3. Oracle Database 23ai AI Features
- AI Vector Search: store embeddings in the
VECTORtype, build vector indexes (HNSW/IVF), and runVECTOR_DISTANCE(...)similarity queries for RAG and semantic search — all in-database. - Combine vector search with relational filters in a single SQL statement.
- Select AI: natural-language-to-SQL via DBMS_CLOUD_AI for governed analytics.
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.
- 1mo ago First seen · 73 lines · 60 tokens per session scan A 395334e6fd6a
oracle-database-expert is a skill published in the GitHub repository frankxai/claude-skills-library (47 stars, last pushed today), licensed MIT. It adds 60 tokens to every session and 939 once invoked, about $0.0002 per session on Opus 5.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-03.
Other skills, from other repositories
postgresql-table-design
Design a PostgreSQL-specific schema. Covers best-practices, data types, indexing, constraints, performance patterns, and advanced features.
token-saver
Token optimization guide for Claude Code. This skill should be used when the user wants to reduce API costs, learn model routing strategies, or understand how to use free/cheaper tools (Ollama, Haiku) instead of burning expensive Claude tokens on routine tasks. Triggers on: save tokens, reduce costs, token tips, cheap…
wayfinder
A planning method that maps a large, uncertain project into linked decision tickets in a repository's issue tracker. An issue tracker is a system for recording and organizing project work.
scaffold-exercises
A directory scaffold for course exercises, with sections, exercise folders, and optional problem, solution, or explanation versions. It creates the required Markdown files and checks the result with the repository's linter.
domain-modeling
A practice for building and maintaining a project’s domain model: the shared terms, concrete scenarios, and recorded architecture decisions that describe what the software is about.
migrate-to-shoehorn
A testing guide for Shoehorn, a TypeScript library that lets tests provide only the fields they need from a larger data type.