SQL Optimization Patterns
ynulihao/AgentSkillOS
Master SQL query optimization, indexing strategies, and EXPLAIN analysis to dramatically improve database performance and eliminate slow queries.
Use these skills to manage and monitor Oracle databases by executing SQL statements, exploring schema metadata, analyzing query performance, monitoring active sessions and resource consumption, and…
Install Oracledb
$ npx skills add Kilo-Org/kilo-marketplace --skill oracledb -a claude-codeProject install by default; add -g for ~/.claude/skills/.
$ gh skill install Kilo-Org/kilo-marketplace oracledb --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/Kilo-Org/kilo-marketplace.git skills-src && mkdir -p .claude/skills && cp -r skills-src/skills/oracledb .claude/skills/oracledb && 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 "oracledb" agent skill from https://github.com/Kilo-Org/kilo-marketplace/tree/main/skills/oracledb into .claude/skills/oracledb/ in this project. Copy the whole folder (SKILL.md and every file beside it), keep the folder name "oracledb", 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/Kilo-Org/kilo-marketplace/tree/main/skills/oracledbType 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 Kilo-Org/kilo-marketplace --skill oracledb -a codexProject install goes to .agents/skills/; add -g for ~/.codex/skills/.
$ gh skill install Kilo-Org/kilo-marketplace oracledb --agent codexProject scope by default (.agents/skills/); add --scope user for a personal install.
$ git clone --depth 1 https://github.com/Kilo-Org/kilo-marketplace.git skills-src && mkdir -p .agents/skills && cp -r skills-src/skills/oracledb .agents/skills/oracledb && rm -rf skills-srcUse ~/.agents/skills/ instead of .agents/skills for a personal install.
Codex skills documentation · loads skills from .agents/skills/
Install the "oracledb" agent skill from https://github.com/Kilo-Org/kilo-marketplace/tree/main/skills/oracledb into .agents/skills/oracledb/ in this project. Copy the whole folder (SKILL.md and every file beside it), keep the folder name "oracledb", 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 Kilo-Org/kilo-marketplace --skill oracledb -a cursorProject install goes to .agents/skills/; add -g for ~/.cursor/skills/.
$ gh skill install Kilo-Org/kilo-marketplace oracledb --agent cursorProject scope by default (.agents/skills/); add --scope user for a personal install.
$ git clone --depth 1 https://github.com/Kilo-Org/kilo-marketplace.git skills-src && mkdir -p .cursor/skills && cp -r skills-src/skills/oracledb .cursor/skills/oracledb && 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 "oracledb" agent skill from https://github.com/Kilo-Org/kilo-marketplace/tree/main/skills/oracledb into .cursor/skills/oracledb/ in this project. Copy the whole folder (SKILL.md and every file beside it), keep the folder name "oracledb", 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/Kilo-Org/kilo-marketplace.git --path skills/oracledb--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 Kilo-Org/kilo-marketplace --skill oracledb -a gemini-cliProject install goes to .agents/skills/; add -g for ~/.gemini/skills/.
$ gh skill install Kilo-Org/kilo-marketplace oracledb --agent gemini-cliProject scope by default (.agents/skills/); add --scope user for a personal install.
$ git clone --depth 1 https://github.com/Kilo-Org/kilo-marketplace.git skills-src && mkdir -p .gemini/skills && cp -r skills-src/skills/oracledb .gemini/skills/oracledb && 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 "oracledb" agent skill from https://github.com/Kilo-Org/kilo-marketplace/tree/main/skills/oracledb into .gemini/skills/oracledb/ in this project. Copy the whole folder (SKILL.md and every file beside it), keep the folder name "oracledb", 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 Kilo-Org/kilo-marketplace oracledbInstalls 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 Kilo-Org/kilo-marketplace --skill oracledb -a github-copilotProject install goes to .agents/skills/; add -g for ~/.copilot/skills/.
$ git clone --depth 1 https://github.com/Kilo-Org/kilo-marketplace.git skills-src && mkdir -p .github/skills && cp -r skills-src/skills/oracledb .github/skills/oracledb && 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 "oracledb" agent skill from https://github.com/Kilo-Org/kilo-marketplace/tree/main/skills/oracledb into .github/skills/oracledb/ in this project. Copy the whole folder (SKILL.md and every file beside it), keep the folder name "oracledb", 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 Kilo-Org/kilo-marketplace --skill oracledb -a opencodeOpenCode documents no install command of its own. Project install goes to .agents/skills/; add -g for ~/.config/opencode/skills/.
$ gh skill install Kilo-Org/kilo-marketplace oracledb --agent opencodeProject scope by default (.agents/skills/); add --scope user for a personal install.
$ git clone --depth 1 https://github.com/Kilo-Org/kilo-marketplace.git skills-src && mkdir -p .opencode/skills && cp -r skills-src/skills/oracledb .opencode/skills/oracledb && 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 "oracledb" agent skill from https://github.com/Kilo-Org/kilo-marketplace/tree/main/skills/oracledb into .opencode/skills/oracledb/ in this project. Copy the whole folder (SKILL.md and every file beside it), keep the folder name "oracledb", 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
oracledb- GitHub stars
- 190
- Token cost
- ~782 tokens
- SKILL.md length
- 311 words
- Files
- 10 (incl. scripts)
- Skills in repo
- 85
- Repo updated
- First seen
- Licence
- Apache-2.0
At a glance
Use these skills to manage and monitor Oracle databases by executing SQL statements, exploring schema metadata, analyzing query performance, monitoring active sessions and resource consumption, and…
- Tasks that involve SQL
- SKILL.md covers Usage and Scripts
- Runs JavaScript scripts from its folder; calls node
- Tasks that involve Query optimization
What it does
Oracledb is an agent skill from Kilo-Org/kilo-marketplace. Use these skills to manage and monitor Oracle databases by executing SQL statements, exploring schema metadata, analyzing query performance, monitoring active sessions and resource consumption, and managing storage and object health.
Its SKILL.md is about 780 tokens, which your agent loads only when the skill is triggered. The skill folder holds 10 other files, including scripts (for example `scripts/execute_sql.js`, `scripts/get_query_plan.js` and `scripts/list_active_sessions.js`).
It sits in Databases, covering SQL and Query optimization. It works with SQL. The repository describes itself as: Kilo Marketplace - A curated collection of Skills, MCP Servers, and Modes for enhancing AI agent capabilities across the Kilo ecosystem—including Kilo Code (VS Code extension)… The licence is Apache-2.0.
When your agent uses it
- Tasks that involve SQL
- Tasks that involve Query optimization
Example prompts
- “/oracledb”
Requirements
- Node.js
What it can do on your machine
Read from SKILL.md and the folder at commit ff51758. 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
Ships 7 files in scripts/ (JavaScript), which the agent can run.
Shell commands in SKILL.md call:
node
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
Oracledb loads about 782 tokens when it runs. Until then it costs about 61 tokens; SKILL.md has 311 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: notes
The automated check noted patterns worth knowing about, such as sudo or a known installer.
- NoteMentions a .env fileSKILL.md:27
d the environment variables from various .env files. Do not ask the user to set vars unless skill executions fails due t
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); the scripts in this folder are not scanned.
SKILL.md
The full file from Kilo-Org/kilo-marketplace at commit ff51758, republished under its Apache-2.0 licence (© Kilo-Org). 311 words, ~782 tokens.
Download SKILL.mdSave it as
.claude/skills/oracledb/SKILL.md (or your agent's skills folder). This skill also uses 9 other files; get the full folder from GitHub.- name
- oracledb
- description
- Use these skills to manage and monitor Oracle databases by executing SQL statements, exploring schema metadata, analyzing query performance, monitoring active sessions and resource consumption, and managing storage and object health.
- metadata.category
- data
Usage
All scripts can be executed using Node.js. Replace <param_name> and <param_value> with actual values.
Bash:
node <skill_dir>/scripts/<script_name>.js '{"<param_name>": "<param_value>"}'
PowerShell:
node <skill_dir>/scripts/<script_name>.js '{\"<param_name>\": \"<param_value>\"}'
Note: The scripts automatically load the environment variables from various .env files. Do not ask the user to set vars unless skill executions fails due to env var absence.
Scripts
execute_sql
Executes one read-only SELECT or WITH query by default. The wrapper rejects multiple statements, DDL, DML, transaction control, PL/SQL, CALL, COPY, DO, SELECT INTO, and row-locking queries before starting the database tool.
Parameters
| Name | Type | Description | Required | Default |
|---|---|---|---|---|
| sql | string | One read-only SQL query to execute. | Yes |
A non-read statement requires both explicit CLI acknowledgements and should be used only after the user confirms the exact SQL:
node <skill_dir>/scripts/execute_sql.js \
--dangerous --confirm-dangerous-sql=EXECUTE \
'{"sql":"<confirmed non-read SQL>"}'get_query_plan
Generate a full execution plan for one SELECT or WITH query using EXPLAIN PLAN. The wrapper applies the same read-only statement validation and the same two-flag dangerous override as execute_sql before invoking the tool.
Parameters
| Name | Type | Description | Required | Default |
|---|---|---|---|---|
| query | string | The SQL statement for which you want to generate plan (omit the EXPLAIN keyword). | Yes |
list_active_sessions
List the top N (default 50) currently running database sessions (STATUS='ACTIVE'), showing SID, OS User, Program, and the current SQL statement text.
list_invalid_objects
Lists all database objects that are in an invalid state, requiring recompilation (e.g., procedures, functions, views).
list_tables
Lists all user tables in the connected schema, including segment size, row count, and last analyzed date. Filters by a comma-separated list of names. If names are omitted, lists all tables in the current user's schema.
list_tablespace_usage
List tablespace names, total size, free space, and used percentage to monitor storage utilization.
list_top_sql_by_resource
List the top N (default 5) SQL statements from the library cache based on a chosen resource metric (CPU, I/O, or Elapsed Time). Shows SQL ID, execution count, buffer gets, disk reads, CPU time, and elapsed time.
© Kilo-Org, Apache-2.0. 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 9 other files (scripts) in skills/oracledb of Kilo-Org/kilo-marketplace.
- SKILL.md
- LICENSE
- local.patch
- scripts/execute_sql.js
- scripts/get_query_plan.js
- scripts/list_active_sessions.js
- scripts/list_invalid_objects.js
- scripts/list_tables.js
- scripts/list_tablespace_usage.js
- scripts/list_top_sql_by_resource.js
Open the folder on GitHubat commit ff51758
Compare with similar skills
Oracledb 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 |
|---|---|---|---|---|---|---|
| Oracledb this skillKilo-Org/kilo-marketplace | 190 | — | ~782 | Automated safety check: Notes | Apache-2.0 | |
| SQL Optimization Patternsynulihao/AgentSkillOS | 617 | 11 repos | ~3.3k | Automated safety check: Pass | None | |
| Query Engine Designrevfactory/claude-code-harness | 120 | — | ~474 | Automated safety check: Pass | None | |
| SQL Optimization Patternssickn33/agentic-awesome-skills | 47k | 1 repos | ~566 | Automated safety check: Pass | MIT | |
| SQL Database Assistantborghei/Claude-Skills | 881 | — | ~1.5k | Automated safety check: Pass | MIT | |
| SQL Optimization InterviewerPrepLabsAI/InterviewMentor | 112 | — | ~2.1k | Automated safety check: Pass | MIT |
Similar skills
Query Engine Design
revfactory/claude-code-harness
SQL query engine design and implementation guide. An agent skill from revfactory/claude-code-harness.
SQL Optimization Patterns
sickn33/agentic-awesome-skills
Diagnose slow SQL with query plans, preserve query results, and verify indexing or query changes against representative data.
SQL Database Assistant
borghei/Claude-Skills
This skill should be used when the user asks to "optimize SQL queries", "explore database schemas", "generate migration SQL", "analyze query performance", or "document database structure".
SQL Optimization Interviewer
PrepLabsAI/InterviewMentor
A Data Engineering interviewer focused on database performance.
Writing SQL
rileyhilliard/claude-essentials
Staff+ DBA SQL patterns targeting what Claude's defaults miss - multi-column statistics, operator classes, keyset pagination, silent performance anti-patterns.
More from Kilo-Org/kilo-marketplace
All 85 skills in this repoAzureML Project Scaffolding
Kilo-Org/kilo-marketplace
Sets up and maintains AzureML-ready Python projects as uv workspaces with devcontainers, a Makefile and job YAML, so local runs match cloud jobs and experiments stay reproducible.
Jupyter Notebook Builder
Kilo-Org/kilo-marketplace
Creates, inspects, edits and runs Jupyter notebooks, scaffolding experiment or tutorial notebooks from templates and preferring a Jupyter MCP server over raw JSON edits.
Tableau Dashboard Creator
Kilo-Org/kilo-marketplace
Takes a plain-language dashboard request through brand setup, data exploration, planning, an interactive HTML mock and a Tableau implementation spec.
Elasticsearch File Ingest
Kilo-Org/kilo-marketplace
Ingest and transform data files (CSV/JSON/Parquet/Arrow IPC) into Elasticsearch with stream processing and custom transforms.
Nifi Flow Layout
Kilo-Org/kilo-marketplace
A skill your agent uses when arranging Apache NiFi processors, process groups, ports, comments, numbering, crossing connections, dense fan-in/fan-out, or reusable readable canvas layouts.
Splunk Ingest Processor Setup
Kilo-Org/kilo-marketplace
Render Cisco Data Fabric ingest-time routing workflows and Splunk Cloud Platform Ingest Processor setup plans with SPL2 pipelines, source types, destinations, lifecycle handoffs, queue and…
Related
Works with
Categories
Questions about Oracledb
What does Oracledb do?
Use these skills to manage and monitor Oracle databases by executing SQL statements, exploring schema metadata, analyzing query performance, monitoring active sessions and resource consumption, and…. Oracledb is an agent skill from Kilo-Org/kilo-marketplace. Use these skills to manage and monitor Oracle databases by executing SQL statements, exploring schema metadata, analyzing query performance, monitoring active sessions and resource consumption, and managing storage and object health.
When should I use Oracledb?
Oracledb fits situations like: tasks that involve SQL; tasks that involve Query optimization.
How do I install Oracledb in Claude Code?
Run `npx skills add Kilo-Org/kilo-marketplace --skill oracledb -a claude-code`. Or copy the skill folder (skills/oracledb in Kilo-Org/kilo-marketplace) into .claude/skills/oracledb in your project. Claude Code loads it when a task matches its description.
How do I install Oracledb in Codex?
Run `npx skills add Kilo-Org/kilo-marketplace --skill oracledb -a codex`. Or copy the skill folder (skills/oracledb in Kilo-Org/kilo-marketplace) into .agents/skills/oracledb in your project. Codex loads it when a task matches its description.
Can I use Oracledb 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 Kilo-Org/kilo-marketplace --skill oracledb -a cursor` (or -a gemini-cli, github-copilot or opencode for the others). To copy it by hand, put the folder in .cursor/skills/oracledb, .gemini/skills/oracledb, .github/skills/oracledb and .opencode/skills/oracledb in your project.
What does Oracledb need to run?
Going by SKILL.md and its folder, Oracledb needs JavaScript for the scripts in its folder and the command-line tools its instructions call (node). Our summary lists: Node.js.
Does Oracledb 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 Oracledb safe to install?
Our automated static check of SKILL.md found notes only (mentions a .env file), nothing it rates as a warning. It is not a guarantee. The check reads SKILL.md only: the scripts in the folder are not scanned, so read them before running anything.
What licence does Oracledb use?
Oracledb is published under the Apache-2.0 licence (from the LICENSE file in the skill folder). It allows redistribution, so the full SKILL.md is shown on this page.
How many tokens does Oracledb use?
About 782 tokens (SKILL.md is roughly 3.1k 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 Oracledb?
Skills that share tags, products or a category with Oracledb: SQL Optimization Patterns (ynulihao/AgentSkillOS, 617 stars), Query Engine Design (revfactory/claude-code-harness, 120 stars), SQL Optimization Patterns (sickn33/agentic-awesome-skills, 47k stars) and SQL Database Assistant (borghei/Claude-Skills, 881 stars). The comparison table on this page puts their stars, adoption, token cost, safety result and licence side by side.
Who maintains Oracledb?
Kilo-Org (a GitHub organization) maintains it in Kilo-Org/kilo-marketplace, which has 190 GitHub stars. The repository holds 85 skills in this directory. The repository was last updated on September 28, 2026.
Source: Kilo-Org/kilo-marketplace on GitHub. Facts on this page come from the repository at the commit we read; the author's words are quoted as theirs.