菜单
117 Oracle Database reference guides covering SQL, PL/SQL, performance tuning, security, ORDS, SQLcl, migrations, and more. Load individual skill files on demand for expert guidance on any Oracle topic.
用 Codex 或 Claude 帮你安装 复制这段 Prompt，粘贴到 Codex、Claude 或其他助手里，让它检查 Skill 页面并帮你完成安装。
基于 SOC 职业分类
| name | oracle-db-skills |
| description | 117 Oracle Database reference guides covering SQL, PL/SQL, performance tuning, security, ORDS, SQLcl, migrations, and more. Load individual skill files on demand for expert guidance on any Oracle topic. |
| version | 1.0.0 |
| repository | https://github.com/krisrice/oracle-db-skills |
A collection of 103 standalone reference guides for Oracle Database. Each file covers one topic with explanations, practical examples, best practices, and common mistakes.
| User asks about… | Read from |
|---|---|
| Backup, recovery, RMAN, Data Guard, redo/undo logs, users | skills/admin/ |
| JDBC, connection pooling, JSON, XML, spatial, full-text, transactions | skills/appdev/ |
| RAC, CDB/PDB, Exadata, In-Memory, OCI, ATP/ADW | skills/architecture/ |
| ERD, data modeling, partitioning, tablespaces | skills/design/ |
| Liquibase, Flyway, online operations, EBR, utPLSQL, git for SQL | skills/devops/ |
| Advanced Queuing, DBMS_SCHEDULER, materialized views, DBLinks, APEX | skills/features/ |
| Migrating from PostgreSQL, MySQL, SQL Server, MongoDB, etc. | skills/migrations/ |
| Alert log, ADR, adrci, space, top SQL, health checks | skills/monitoring/ |
| ORDS, REST APIs, OAuth2, AutoREST, PL/SQL gateway | skills/ords/ |
| AWR, ASH, explain plan, indexes, optimizer stats, wait events, memory | skills/performance/ |
| Packages, cursors, collections, error handling, unit testing, debugging | skills/plsql/ |
| Privileges, VPD, TDE, encryption, auditing, network security | skills/security/ |
| SQL patterns, window functions, CTEs, dynamic SQL, injection | skills/sql-dev/ |
| SQLcl commands, scripting, Liquibase CLI, MCP server, CI/CD | skills/sqlcl/ |
skills/
├── admin/ Database administration (backup, recovery, users, redo/undo)
├── appdev/ Application development (JSON, XML, spatial, text, pooling)
├── architecture/ Infrastructure (RAC, Multitenant, Exadata, In-Memory, OCI)
├── design/ Schema design (ERD, modeling, partitioning, tablespaces)
├── devops/ CI/CD and DevOps (migrations, EBR, testing, version control)
├── features/ Oracle features (AQ, Scheduler, MVs, DBLinks, APEX)
├── migrations/ Migrating from other databases to Oracle
├── monitoring/ Diagnostics (alert log, ADR, health, space, top SQL)
├── ords/ Oracle REST Data Services
├── performance/ Tuning (AWR, ASH, indexes, optimizer, wait events, memory)
├── plsql/ PL/SQL development (packages, cursors, collections, testing)
├── security/ Security (privileges, VPD, TDE, auditing, network)
├── sql-dev/ SQL development (tuning, patterns, dynamic SQL, injection)
└── sqlcl/ SQLcl CLI tool (basics, scripting, Liquibase, MCP server)
skills/sqlcl/sqlcl-mcp-server.md — connecting AI assistants to Oracle via the SQLcl MCP serverskills/migrations/migration-assessment.md — start here for any database migration projectskills/performance/explain-plan.md — foundation for all SQL performance workskills/plsql/plsql-package-design.md — foundation for PL/SQL architecture questionsskills/devops/schema-migrations.md — Liquibase/Flyway with Oracle in CI/CD pipelinesUse when writing, reviewing, or committing code to enforce Karpathy's 4 coding principles — surface assumptions before coding, keep it simple, make surgical changes, define verifiable goals. Triggers on "review my diff", "check complexity", "am I overcomplicating this", "karpathy check", "before I commit", or any code quality concern where the LLM might be overcoding.
Use proactively whenever LLM API costs come up -- or should. Triggers include: 'my AI costs are too high', 'optimize token usage', 'which model should I use', 'LLM spend is out of control', 'implement prompt caching', 'we're about to launch an AI feature', 'build me an AI endpoint'. Don't wait for an explicit cost complaint -- if someone is building an AI feature, designing an LLM endpoint, or choosing between models, cost architecture belongs in the conversation. Apply immediately when any of these are true: a system prompt appears that exceeds a few hundred tokens, all requests are hitting the same model, max_tokens is not set, or no per-feature cost logging exists. NOT for RAG pipeline design (use rag-architect). NOT for improving prompt quality or effectiveness (use senior-prompt-engineer).
25 advanced engineering agent skills and plugins for Claude Code, Codex, Gemini CLI, Cursor, OpenClaw. Agent design, RAG, MCP servers, CI/CD, database design, observability, security auditing, release management, platform ops.
23 engineering agent skills and plugins for Claude Code, Codex, Gemini CLI, Cursor, OpenClaw, and 6 more tools. Architecture, frontend, backend, QA, DevOps, security, AI/ML, data engineering, Playwright, Stripe, AWS, MS365. 30+ Python tools (stdlib-only).
Full content production pipeline — takes a topic from blank page to published-ready piece. Use when you need to execute content: write a blog post, article, or guide end-to-end. Triggers: 'write a post about', 'draft an article', 'create content for', 'help me write', 'I need a blog post'. NOT for content strategy or calendar planning (use content-strategy). NOT for repurposing existing content (use content-repurposing). NOT for social captions only.
When the user wants to edit, review, or improve existing marketing copy. Also use when the user mentions 'edit this copy,' 'review my copy,' 'copy feedback,' 'proofread,' 'polish this,' 'make this better,' or 'copy sweep.' This skill provides a systematic approach to editing marketing copy through multiple focused passes.