oracle-database

Files (166)

• LICENSE
• SKILL.md
• dataguard.md · admin/
• redo-log-management.md · admin/
• undo-management.md · admin/
• user-management.md · admin/
• 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 · agent/
• connection-pooling.md · appdev/
• dotnet-oracle.md · appdev/
• golang-oracle.md · appdev/
• java-oracle-jdbc.md · appdev/
• connections.md · appdev/java-oracle-jdbc/
• dependencies.md · appdev/java-oracle-jdbc/
• pooling-production.md · appdev/java-oracle-jdbc/
• sql.md · appdev/java-oracle-jdbc/
• json-in-oracle.md · appdev/
• locking-concurrency.md · appdev/
• mle-javascript-in-database.md · appdev/
• nodejs-oracledb.md · appdev/
• oracle-text.md · appdev/
• python-oracledb.md · appdev/
• sequences-identity.md · appdev/
• spatial-data.md · appdev/
• sql-property-graph.md · appdev/
• transaction-management.md · appdev/
• xml-in-oracle.md · appdev/
• dataguard.md · architecture/
• exadata-features.md · architecture/
• inmemory-column-store.md · architecture/
• multitenant.md · architecture/
• oracle-cloud-oci.md · architecture/
• rac-concepts.md · architecture/
• autonomous-recovery-service.md · backup-recovery/
• cloud-protect.md · backup-recovery/
• rman-basics.md · backup-recovery/
• rman-overview.md · backup-recovery/
• SKILLS.md · containers/
• adb-free.md · containers/
• cman.md · containers/
• container-selection-matrix.md · containers/
• enterprise.md · containers/
• enterprise_ru.md · containers/
• free.md · containers/
• graph-quickstart.md · containers/
• gsm.md · containers/
• gsm_ru.md · containers/
• instantclient.md · containers/
• microtx-ee-console.md · containers/
• microtx-ee-coordinator.md · containers/
• observability-exporter.md · containers/
• operator.md · containers/
• ords.md · containers/
• otmm.md · containers/
• …and 106 more

SKILL.md (first lines)

# 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

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

## Directory Structure

```text
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.md`
- `migrations/migration-assessment.md`
- `performance/explain-plan.md`
- `plsql/plsql-package-design.md`
- `appdev/java-oracle-jdbc.md`
- `devops/schema-migrations.md`
- `agent/schema-discovery.md`
- `containers/container-selection-matrix.md`
- `backup-recovery/autonomous-recovery-service.md`
- `backup-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) |

From Kilo-Org/kilo-marketplace, Apache-2.0.

More from Kilo-Org/kilo-marketplace