kilo-org/oracle-database
skills/oracle-database/SKILL.md
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, Data Guard, RAC, multitenant, containers, monitoring, auditing, encryption, VPD, or safe agent database operations.
$ install --global
skillsauthnpx skillsauth add kilo-org/kilo-marketplace oracle-databaseInstall this skill globally with one command. Works with Claude Code, Cursor, and Windsurf.
Security Scan Results
3 of 9 scanners reported clean
Some scanners were skipped, did not run, or reported a non-clean status. Review each row below.
3
Scanners Passed
9
Scanners in report
Clean
TrivyContainer and dependency vulnerability scanner
95%
Clean
SemgrepStatic code analysis for vulnerabilities
95%
Clean
mcp-scan (Snyk)Model Context Protocol security validation
95%
Skipped
Snyk (dep)Open source security scanning
50%
Skipped
Socket.devSupply chain security analysis
50%
Skipped
VirusTotalMulti-engine malware detection
50%
Skipped
CrowdStrikeAdvanced threat intelligence
50%
Skipped
OSV-ScannerOpen Source Vulnerability database check
50%
Skipped
OWASP Dep-Check
50%
Last scanned: Jul 21, 2026, 8:18 AM110.1s1 file scanned
SKILL.md
- name:
- oracle-database
- description:
- >-
- category:
- data
- repository:
- https://github.com/oracle/skills
- path:
- db
- license_path:
- LICENSE.txt
- commit:
- 69af8ce3d655b4c2d92882cd64d94b39736924a7
Oracle Database Skills
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.
How to Use This Domain
- Start with the routing table below.
- Read only the specific file or category you need.
Directory Structure
admin/
agent/
appdev/
architecture/
backup-recovery/
containers/
design/
devops/
features/
frameworks/
migrations/
monitoring/
ords/
performance/
plsql/
security/
sql-dev/
sqlcl/
Category Routing
| Topic | Directory |
|-------|-----------|
| Data Guard, redo/undo logs, users | admin/ |
| Safe DML, destructive operation guards, idempotency, schema discovery, ORA- error handling | agent/ |
| JDBC, pooling, JSON, XML, spatial, Oracle Text, transactions, MLE, language drivers | appdev/ |
| RAC, Multitenant, Exadata, In-Memory, OCI database services, Data Guard architecture | architecture/ |
| Backup, recovery, RMAN, Autonomous Recovery Service, Cloud Protect | backup-recovery/ |
| OCR database-category container images and pull guidance | containers/ |
| ERD, data modeling, partitioning, tablespaces | design/ |
| Schema migrations, online operations, edition-based redefinition, testing, version control | devops/ |
| AQ, DBMS_SCHEDULER, materialized views, DBLinks, APEX, vector search, SELECT AI | features/ |
| SQLAlchemy, Django, Pandas, Spring JPA, MyBatis, TypeORM, Sequelize, Dapper, GORM | frameworks/ |
| Migrations from PostgreSQL, MySQL, SQL Server, MongoDB, Snowflake, and more | migrations/ |
| Alert log, ADR, health monitor, space management, top SQL | monitoring/ |
| ORDS architecture, installation, REST design, authentication, monitoring, ORDS Concert Sample App | ords/ |
| AWR, ASH, explain plan, indexes, optimizer stats, wait events, memory | performance/ |
| Package design, error handling, performance, collections, cursors, debugging | plsql/ |
| Privileges, VPD, masking, auditing, encryption, network security | security/ |
| SQL tuning, SQL patterns, dynamic SQL, injection avoidance | sql-dev/ |
| SQLcl basics, scripting, Liquibase, formatting, DDL generation, data loading, MCP server, scheduler daemon, AWR, background jobs, schema comparison with DIFF | sqlcl/ |
Key Starting Points
sqlcl/sqlcl-mcp-server.mdmigrations/migration-assessment.mdperformance/explain-plan.mdplsql/plsql-package-design.mdappdev/java-oracle-jdbc.mddevops/schema-migrations.mdagent/schema-discovery.mdcontainers/container-selection-matrix.mdbackup-recovery/autonomous-recovery-service.mdbackup-recovery/cloud-protect.md
Common Multi-Step Flows
| Task | Recommended Sequence |
|------|----------------------|
| Diagnose a slow query | explain-plan → wait-events → optimizer-stats → awr-reports |
| Plan a migration | migration-assessment → oracle-migration-tools → source-specific migrate-*.md → migration-cutover-strategy |
| Build RAG on Oracle Database | ai-profiles → vector-search → dbms-vector |
| Build a Java JDBC service | java-oracle-jdbc → java-oracle-jdbc/dependencies → java-oracle-jdbc/connections → java-oracle-jdbc/sql → java-oracle-jdbc/pooling-production |
| Perform agent-safe schema change | schema-discovery → destructive-op-guards → idempotency-patterns → schema-migrations |
| Set up AI-driven database access via MCP | sqlcl-basics (save connections) → security/privilege-management (least-privilege user) → sqlcl-mcp-server (configure + start) |
Related Skills
kilo-org/oleander-iceberg-catalog
documentation
VerifiedTrustedCommunity
Patterns for reading and writing oleander Iceberg catalog tables in Spark jobs, including naming conventions, write modes, and catalog hierarchy.
161SKILL.mdUpdated Jul 21, 2026
kilo-org/okta-identity-integration-patterns
data-ai
VerifiedTrustedCommunity
Integrate Okta for enterprise identity workflows including OIDC login, group claims, and policy-based access controls. Use when implementing workforce or B2B identity scenarios.
161SKILL.mdUpdated Jul 21, 2026
kilo-org/nifi-flow-layout
documentation
VerifiedTrustedCommunity
Use when arranging Apache NiFi processors, process groups, ports, comments, numbering, crossing connections, dense fan-in/fan-out, or reusable readable canvas layouts.
161SKILL.mdUpdated Jul 21, 2026
kilo-org/newrelic-cli-nrql
tools
VerifiedTrustedCommunity
This subskill should be used when composing or running ad hoc NRQL queries for New Relic telemetry, facets, time windows, rates, and comparisons. Use newrelic-nrql-debug-ladder instead for failing, empty, or schema-mismatched queries.
161SKILL.mdUpdated Jul 21, 2026