Agent skill

Oracle Database

by Kilo-Org in Kilo-Org/kilo-marketplace

Oracle Database guidance for SQL, PL/SQL, SQLcl, ORDS, administration, app development, performance, security, migrations, and agent-safe database workflows.

Custom licenceAuto-check passedDatabases

Install Oracle Database

skills CLI

$ npx skills add Kilo-Org/kilo-marketplace --skill oracle-database -a claude-code

Project install by default; add -g for ~/.claude/skills/.

GitHub CLI

$ gh skill install Kilo-Org/kilo-marketplace oracle-database --agent claude-code

Project scope by default; add --scope user for a personal install. Needs GitHub CLI 2.90.0 or later (public preview).

Manual copy

$ git clone --depth 1 https://github.com/Kilo-Org/kilo-marketplace.git skills-src && mkdir -p .claude/skills && cp -r skills-src/skills/oracle-database .claude/skills/oracle-database && rm -rf skills-src

Use ~/.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/

Paste into Claude Code

Install the "oracle-database" agent skill from https://github.com/Kilo-Org/kilo-marketplace/tree/main/skills/oracle-database into .claude/skills/oracle-database/ in this project. Copy the whole folder (SKILL.md and every file beside it), keep the folder name "oracle-database", 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

$skill-installer install https://github.com/Kilo-Org/kilo-marketplace/tree/main/skills/oracle-database

Type 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.

skills CLI

$ npx skills add Kilo-Org/kilo-marketplace --skill oracle-database -a codex

Project install goes to .agents/skills/; add -g for ~/.codex/skills/.

GitHub CLI

$ gh skill install Kilo-Org/kilo-marketplace oracle-database --agent codex

Project scope by default (.agents/skills/); add --scope user for a personal install.

Manual copy

$ git clone --depth 1 https://github.com/Kilo-Org/kilo-marketplace.git skills-src && mkdir -p .agents/skills && cp -r skills-src/skills/oracle-database .agents/skills/oracle-database && rm -rf skills-src

Use ~/.agents/skills/ instead of .agents/skills for a personal install.

Codex skills documentation · loads skills from .agents/skills/

Paste into Codex

Install the "oracle-database" agent skill from https://github.com/Kilo-Org/kilo-marketplace/tree/main/skills/oracle-database into .agents/skills/oracle-database/ in this project. Copy the whole folder (SKILL.md and every file beside it), keep the folder name "oracle-database", 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.

skills CLI

$ npx skills add Kilo-Org/kilo-marketplace --skill oracle-database -a cursor

Project install goes to .agents/skills/; add -g for ~/.cursor/skills/.

GitHub CLI

$ gh skill install Kilo-Org/kilo-marketplace oracle-database --agent cursor

Project scope by default (.agents/skills/); add --scope user for a personal install.

Manual copy

$ git clone --depth 1 https://github.com/Kilo-Org/kilo-marketplace.git skills-src && mkdir -p .cursor/skills && cp -r skills-src/skills/oracle-database .cursor/skills/oracle-database && rm -rf skills-src

Use ~/.cursor/skills/ instead of .cursor/skills for a personal install.

Cursor skills documentation · loads skills from .cursor/skills/, .agents/skills/, .claude/skills/, .codex/skills/

Paste into Cursor

Install the "oracle-database" agent skill from https://github.com/Kilo-Org/kilo-marketplace/tree/main/skills/oracle-database into .cursor/skills/oracle-database/ in this project. Copy the whole folder (SKILL.md and every file beside it), keep the folder name "oracle-database", 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

$ gemini skills install https://github.com/Kilo-Org/kilo-marketplace.git --path skills/oracle-database

--scope user (default) or --scope workspace; --path is the subfolder of the repo that holds the skill; --consent skips the security confirmation prompt.

skills CLI

$ npx skills add Kilo-Org/kilo-marketplace --skill oracle-database -a gemini-cli

Project install goes to .agents/skills/; add -g for ~/.gemini/skills/.

GitHub CLI

$ gh skill install Kilo-Org/kilo-marketplace oracle-database --agent gemini-cli

Project scope by default (.agents/skills/); add --scope user for a personal install.

Manual copy

$ git clone --depth 1 https://github.com/Kilo-Org/kilo-marketplace.git skills-src && mkdir -p .gemini/skills && cp -r skills-src/skills/oracle-database .gemini/skills/oracle-database && rm -rf skills-src

Use ~/.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/

Paste into Gemini CLI

Install the "oracle-database" agent skill from https://github.com/Kilo-Org/kilo-marketplace/tree/main/skills/oracle-database into .gemini/skills/oracle-database/ in this project. Copy the whole folder (SKILL.md and every file beside it), keep the folder name "oracle-database", 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.

GitHub CLI

$ gh skill install Kilo-Org/kilo-marketplace oracle-database

Installs 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).

skills CLI

$ npx skills add Kilo-Org/kilo-marketplace --skill oracle-database -a github-copilot

Project install goes to .agents/skills/; add -g for ~/.copilot/skills/.

Manual copy

$ git clone --depth 1 https://github.com/Kilo-Org/kilo-marketplace.git skills-src && mkdir -p .github/skills && cp -r skills-src/skills/oracle-database .github/skills/oracle-database && rm -rf skills-src

Use ~/.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/

Paste into GitHub Copilot

Install the "oracle-database" agent skill from https://github.com/Kilo-Org/kilo-marketplace/tree/main/skills/oracle-database into .github/skills/oracle-database/ in this project. Copy the whole folder (SKILL.md and every file beside it), keep the folder name "oracle-database", 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.

skills CLI

$ npx skills add Kilo-Org/kilo-marketplace --skill oracle-database -a opencode

OpenCode documents no install command of its own. Project install goes to .agents/skills/; add -g for ~/.config/opencode/skills/.

GitHub CLI

$ gh skill install Kilo-Org/kilo-marketplace oracle-database --agent opencode

Project scope by default (.agents/skills/); add --scope user for a personal install.

Manual copy

$ git clone --depth 1 https://github.com/Kilo-Org/kilo-marketplace.git skills-src && mkdir -p .opencode/skills && cp -r skills-src/skills/oracle-database .opencode/skills/oracle-database && rm -rf skills-src

Use ~/.config/opencode/skills/ instead of .opencode/skills for a personal install.

OpenCode skills documentation · loads skills from .opencode/skills/, .claude/skills/, .agents/skills/

Paste into OpenCode

Install the "oracle-database" agent skill from https://github.com/Kilo-Org/kilo-marketplace/tree/main/skills/oracle-database into .opencode/skills/oracle-database/ in this project. Copy the whole folder (SKILL.md and every file beside it), keep the folder name "oracle-database", 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: oracle-database
GitHub stars: 189
Token cost: ~1.1k tokens
SKILL.md length: 321 words
Files: 182
Skills in repo: 87
Repo updated: Sep 28, 2026
First seen: Oct 7, 2026
Licence: Custom licence

At a glance

Oracle Database guidance for SQL, PL/SQL, SQLcl, ORDS, administration, app development, performance, security, migrations, and agent-safe database workflows.

Works in 2 steps: Start with the routing table below. → Read only the specific file or category…
The user asks to write
SKILL.md covers How to Use This Domain, Directory Structure, Category Routing and Key Starting Points, plus 1 more section
Instructions only: no scripts, shell commands, URLs or credentials in SKILL.md

What it does

Oracle Database is an agent skill from Kilo-Org/kilo-marketplace. Oracle Database guidance for SQL, PL/SQL, SQLcl, ORDS, administration, app development, performance, security, migrations, and agent-safe database workflows. Use when the user asks to write, edit, rewrite, review, format, debug, tune, or explain SQL; create or refactor PL/SQL; use SQLcl, Liquibase, ORDS, JDBC, node-oracledb, Python, Java, .NET, or database frameworks; troubleshoot queries, sessions, locks, waits, indexes, optimizer plans, AWR, ASH, migrations, schemas, users, roles, privileges, backup, recovery…

Its SKILL.md is about 1.1k tokens, which your agent loads only when the skill is triggered. The skill folder holds 184 other files (for example `admin/dataguard.md`, `admin/redo-log-management.md` and `admin/undo-management.md`).

It sits in Databases, covering SQL, Multi-tenancy and Database administration. It works with SQL, Java, Python and .NET. 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)…

When your agent uses it

The user asks to write
Refactor PL/SQL
Database frameworks
Troubleshoot queries

Example prompts

“/oracle-database”

Workflow steps

2 steps, taken from the first numbered list in SKILL.md.

Start with the routing table below.
Read only the specific file or category you need.

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
No scripts in the folder and no shell commands in SKILL.md.
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

Oracle Database loads about 1.1k tokens when it runs. Until then it costs about 162 tokens; SKILL.md has 321 words of instructions outside code blocks.

Always · name and description, kept in context so the agent knows when to use it: ~162
When it runs · the whole SKILL.md, loaded when a task matches: ~1.1k

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 passed

The automated check found no risky patterns in SKILL.md.

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); files beside SKILL.md are not scanned.

SKILL.md

Its licence (Custom licence) doesn't allow us to republish the file, so here is its outline and opening line. It has 321 words (~1,130 tokens).

“This domain contains Oracle Database skills for administration, SQL and PL/SQL development, performance tuning, security, ORDS, SQLcl, migrations, frameworks, OCR container guidance, and agent-safe database workflows.”

— opening of SKILL.md by Kilo-Org, Custom licence

name: oracle-database
metadata.category: data

Read the full SKILL.md on GitHub

Files

SKILL.md and 181 other files in skills/oracle-database of Kilo-Org/kilo-marketplace.

SKILL.md
LICENSE
admin/dataguard.md
admin/redo-log-management.md
admin/undo-management.md
admin/user-management.md
agent/client-identification.md
agent/destructive-op-guards.md
agent/idempotency-patterns.md
agent/intent-disambiguation.md
agent/nl-to-sql-patterns.md
agent/ora-error-catalog.md
agent/safe-dml-patterns.md
agent/schema-discovery.md
appdev/connection-pooling.md
appdev/dotnet-oracle.md
appdev/golang-oracle.md
appdev/java-oracle-jdbc.md
… and 164 more

Open the folder on GitHubat commit ff51758

Compare with similar skills

Oracle Database 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.

Oracle Database compared with similar skills
Skill	Stars	Used in	Tokens	Auto-check	Licence	Repo updated
Oracle Database this skillKilo-Org/kilo-marketplace	189	—	~1.1k	Automated safety check: Pass	Custom licence	8 days ago
DBoracle/skills	872	—	~1.4k	Automated safety check: Pass	UPL-1.0	yesterday
Ravendbravendb/docs	115	—	~2.3k	Automated safety check: Pass	MIT	yesterday
Bigtable Basicsgoogle/skills	21k	—	~1.3k	Automated safety check: Pass	Apache-2.0	today
Jeecg Onlformjeecgboot/skills	237	—	~7.7k	Automated safety check: Pass	Apache-2.0	20 days ago
Chdb SQLvemetric/vemetric	394	1 repos	~1.2k	Automated safety check: Pass	Apache-2.0	today

Similar skills

DB
oracle/skills
Official
Oracle Database guidance for SQL, PL/SQL, SQLcl, ORDS, Oracle Vector SDK, administration, app development, performance, security, migrations, and agent-safe database workflows.
872 GitHub stars~1.4k tokensUpdated yesterday
DatabasesAuto-check passed
Ravendb
ravendb/docs
Read this before writing any RavenDB query, client call or /databases/ request.
115 GitHub stars~2.3k tokensUpdated yesterday
DatabasesAuto-check passed
Bigtable Basics
google/skills
Official
Assists in provisioning instances/tables, designing performant schemas, and querying data in Bigtable.
21k GitHub stars~1.3k tokensUpdated today
DatabasesAuto-check passed
Jeecg Onlform
jeecgboot/skills
JeecgBoot Online表单（cgform）全生命周期管理——通过API自动创建/编辑数据库表和表单配置，支持单表、主子表、树表，26种控件类型，以及JS/Java/SQL增强、权限配置、数据CRUD、积木报表集成。
237 GitHub stars~7.7k tokensUpdated 20 days ago
DatabasesAuto-check passed
Chdb SQL
vemetric/vemetric
A skill your agent uses when the user wants to run SQL — especially analytical SQL — on local files (parquet/csv/json), URLs, S3 paths, or remote databases (Postgres, MySQL, MongoDB, ClickHouse…
394 GitHub starsUsed in 1 repo~1.2k tokens
DatabasesAuto-check passed
Kolo
koloai/kolo
Kolo is a text-based Python debugger that captures every executed function, return value, local variable, HTTP request, and SQL query into greppable trace files.
525 GitHub stars~1.2k tokensUpdated 5 mo ago
DatabasesAuto-check passed

More from Kilo-Org/kilo-marketplace

All 87 skills in this repo

AzureML 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.
189 GitHub stars~3.1k tokensUpdated 8 days ago
Auto-check: notes
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.
189 GitHub stars~1.3k tokensUpdated 8 days ago
Auto-check passed
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.
189 GitHub stars~3.8k tokensUpdated 8 days ago
Auto-check: notes
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.
189 GitHub stars~2.8k tokensUpdated 8 days ago
Auto-check passed
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.
189 GitHub stars~1.5k tokensUpdated 8 days ago
Auto-check passed
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…
189 GitHub stars~1.2k tokensUpdated 8 days ago
Auto-check passed

Works with

Questions about Oracle Database

What does Oracle Database do?

Oracle Database guidance for SQL, PL/SQL, SQLcl, ORDS, administration, app development, performance, security, migrations, and agent-safe database workflows. Oracle Database is an agent skill from Kilo-Org/kilo-marketplace. Oracle Database guidance for SQL, PL/SQL, SQLcl, ORDS, administration, app development, performance, security, migrations, and agent-safe database workflows.

When should I use Oracle Database?

Oracle Database fits situations like: the user asks to write; refactor PL/SQL; database frameworks; troubleshoot queries.

How do I install Oracle Database in Claude Code?

Run `npx skills add Kilo-Org/kilo-marketplace --skill oracle-database -a claude-code`. Or copy the skill folder (skills/oracle-database in Kilo-Org/kilo-marketplace) into .claude/skills/oracle-database in your project. Claude Code loads it when a task matches its description.

How do I install Oracle Database in Codex?

Run `npx skills add Kilo-Org/kilo-marketplace --skill oracle-database -a codex`. Or copy the skill folder (skills/oracle-database in Kilo-Org/kilo-marketplace) into .agents/skills/oracle-database in your project. Codex loads it when a task matches its description.

Can I use Oracle Database 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 oracle-database -a cursor` (or -a gemini-cli, github-copilot or opencode for the others). To copy it by hand, put the folder in .cursor/skills/oracle-database, .gemini/skills/oracle-database, .github/skills/oracle-database and .opencode/skills/oracle-database in your project.

What does Oracle Database need to run?

SKILL.md names no scripts, command-line tools or credentials: Oracle Database is instructions for the agent only.

Does Oracle Database 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 Oracle Database safe to install?

Our automated static check of SKILL.md found no risky patterns, such as piping downloads into a shell, reading credential files or hidden Unicode. It is not a guarantee. Review the folder before installing.

What licence does Oracle Database use?

Oracle Database has a licence file (from the LICENSE file in the skill folder) that doesn't match a standard licence. Read it on GitHub before reusing the skill.

How many tokens does Oracle Database use?

About 1.1k tokens (SKILL.md is roughly 4.5k 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 Oracle Database?

Skills that share tags, products or a category with Oracle Database: DB (oracle/skills, 872 stars), Ravendb (ravendb/docs, 115 stars), Bigtable Basics (google/skills, 21k stars) and Jeecg Onlform (jeecgboot/skills, 237 stars). The comparison table on this page puts their stars, adoption, token cost, safety result and licence side by side.

Who maintains Oracle Database?

Kilo-Org (a GitHub organization) maintains it in Kilo-Org/kilo-marketplace, which has 189 GitHub stars. The repository holds 87 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.

Install Oracle Database

Facts

At a glance

What it does

When your agent uses it

Example prompts

Workflow steps

What it can do on your machine

Tool permissions

Runs code

Network

Credentials

Context cost

Safety

SKILL.md

Files

Compare with similar skills

Similar skills

More from Kilo-Org/kilo-marketplace

Related

Questions about Oracle Database