homemade-mcp-oracle-database-10g-claude: Skill for Claude Code

.claude/skills/oracle10g-query/SKILL.md

oracle10g-query is a skill for Claude Code from Leonides2/homemade-mcp-oracle-database-10g-claude. It costs 91 tokens per session (1,145 once invoked), scanned A, original, MIT.

A terminal tool for running read-only SELECT queries and reviewing table structures in an Oracle 10g database, an older version of Oracle's database system.

In plain words
What is it for?
It is for checking, exploring, and verifying Oracle tables and data when investigating a project.
Why use it?
It lets developers inspect database data and structure without changing records.

Skill for Claude Code

Written for Claude Code: installed under .claude/.

This is Leonides2/homemade-mcp-oracle-database-10g-claude's own configuration. It tells Claude Code how to work on homemade-mcp-oracle-database-10g-claude itself, so it is not a mod to install elsewhere. Copy it as a starting point and replace the rules that are about this project. Everything homemade-mcp-oracle-database-10g-claude configures →

Reuse

Borrowing it

Nothing to install: this file belongs to Leonides2/homemade-mcp-oracle-database-10g-claude. Take a copy, put it at the same path in your own repository, and replace the rules that are about this project with yours.

Copy the file
curl -O https://raw.githubusercontent.com/Leonides2/homemade-mcp-oracle-database-10g-claude/main/.claude/skills/oracle10g-query/SKILL.md
Clone the repo
git clone --depth 1 https://github.com/Leonides2/homemade-mcp-oracle-database-10g-claude

Made for: Claude Code.

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.

agentmods badge for oracle10g-query

README.md
[![agentmods](https://agentmods.dev/badge/skills/leonides2/homemade-mcp-oracle-database-10g-claude/oracle10g-query/github.svg)](https://agentmods.dev/skills/leonides2/homemade-mcp-oracle-database-10g-claude/oracle10g-query)
Your own site
<a href="https://agentmods.dev/skills/leonides2/homemade-mcp-oracle-database-10g-claude/oracle10g-query"><img src="https://agentmods.dev/badge/skills/leonides2/homemade-mcp-oracle-database-10g-claude/oracle10g-query/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.

agentmods 80×15 button for oracle10g-query

Your own site · 80×15
<a href="https://agentmods.dev/skills/leonides2/homemade-mcp-oracle-database-10g-claude/oracle10g-query"><img src="https://agentmods.dev/badge/skills/leonides2/homemade-mcp-oracle-database-10g-claude/oracle10g-query.svg" alt="Reviewed on agentmods" width="80" height="20"></a>
Per session 91 Skills are progressive disclosure: only the name and description are preloaded; the body loads when the skill is used.
When invoked 1,145 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.

ModelPer sessionOnce invoked
Fable 5.1 $0.00091 $0.01145
Opus 5.5 $0.00036 $0.00458
Sonnet 5.5 $0.00018 $0.00229
Haiku 4.5 $0.00009 $0.00114

Measured 2mo ago against content hash eb62a25de690, method: parsed. Prices are Anthropic first-party input rates as of 2026-10-07, from the pricing page.

Security

Grade A, and why

oracle10g-query 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 2mo 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.

.claude/skills/oracle10g-query/SKILL.md · 101 lines

How it starts

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

Consultas a Oracle 10g (solo lectura)

Esta skill envuelve el CLI de este repo (scripts/query.py) para consultar la base de datos Oracle 10g del proyecto desde la terminal, sin necesidad de un MCP client. Usa el mismo nucleo de conexion/seguridad que el servidor MCP (src/mcp_server.py).

Regla no negociable: SOLO LECTURA

Esta base es un sistema legacy en produccion. La utilidad solo permite sentencias SELECT (o WITH ... SELECT). Cualquier INSERT, UPDATE, DELETE, MERGE, DDL (CREATE/ALTER/DROP/TRUNCATE), GRANT/REVOKE, bloques PL/SQL o multiples sentencias separadas por ; son rechazados antes de tocar la base (ver src/sql_guard.py). No intentes rodear esta restriccion (por ejemplo con EXECUTE IMMEDIATE dentro de un SELECT, DB links a otra sesion con permisos de escritura, etc.) — si el usuario necesita escribir datos, dile que esta utilidad no lo soporta y que se requiere un cambio explicito de alcance.

Requisito previo

Debe existir un archivo .env en la raiz del repo con las credenciales (ver .env.example). Si no existe o falta una variable, el CLI lo reporta claramente — no adivines valores de conexion.

Como ejecutar una consulta

Desde la raiz del repo, usando el interprete del entorno virtual del proyecto:

.venv\Scripts\python scripts\query.py "SELECT columnas FROM tabla WHERE ..."

Salida en JSON (mas facil de parsear para ti):

.venv\Scripts\python scripts\query.py "SELECT ..." --format json

Consulta desde un archivo .sql (util si la consulta es larga o multilinea):

.venv\Scripts\python scripts\query.py --file ruta\a\consulta.sql --format json

Antes de escribir un SELECT contra una tabla que no conoces

  1. Ver que tablas existen (opcionalmente filtrando por owner/schema):
    .venv\Scripts\python scripts\query.py "SELECT owner, table_name FROM all_tables WHERE owner = 'ALGUN_SCHEMA' ORDER BY table_name" --format json
    
  2. Ver las columnas de una tabla puntual antes de asumir su estructura:
    .venv\Scripts\python scripts\query.py "SELECT column_name, data_type, data_length, nullable FROM all_tab_columns WHERE table_name = 'ALGUNA_TABLA' ORDER BY column_id" --format json
    

Read the full file on GitHub · 101 lines

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.

  1. 2mo ago First seen · 101 lines · 91 tokens per session scan A eb62a25de690

Subscribe to this mod's changes

oracle10g-query is a skill published in the GitHub repository Leonides2/homemade-mcp-oracle-database-10g-claude (0 stars, last pushed 6d ago), licensed MIT. It adds 91 tokens to every session and 1,145 once invoked, about $0.0004 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-08-31.

Related

oracle10g-query compared with skills from other repositories

oracle10g-query next to 6 skills from other repositories
ModTypeStarsLast pushLicenceScanTokensWorks with
oracle10g-queryLeonides2/homemade-mcp-oracle-database-10g-claudeSkill06d agoMITA91Claude Code
create-prprisma/ormSkill48ktodayApache-2.0A47Claude Code, Codex
schema-explorationlangchain-ai/deepagentsSkill31kyesterdayMITA57Claude Code, Codex
atlas-mssqlariga/atlasSkill8.8kyesterdayApache-2.0A163Claude Code
ha-data-storesshiwenwen/hope-agentSkill1.9kyesterdayMITA115Claude Code, Codex
nornicdb-cypher-queriesorneryd/NornicDBSkill932yesterdayMITA79Claude Code, Codex
dsqlawslabs/agent-pluginsSkill9472d agoApache-2.0A247Claude Code