A collection of 103 standalone reference guides for Oracle Database. Each file covers one topic with explanations, practical examples, best practices, and common mistakes.
Works with
AI-first code editor with Composer
Before installing skills in Cursor, ensure your development environment meets these requirements:
node --versionoracle-db-skillsExecute the skills CLI command in your project's root directory to begin installation:
Fetches oracle-db-skills from krisrice/oracle-db-skills and configures it for Cursor.
The CLI shows a list of agents. Use arrow keys and space to select Cursor:
Confirm successful installation by checking the skill directory location:
Restart Cursor to activate oracle-db-skills. Access via /oracle-db-skills in your agent's command palette.
We perform automated surface-level scans (Gen AI Scanner, Socket, Snyk) during installation. These checks detect common vulnerabilities but do not guarantee complete security. Always review skill source code and verify the publisher's reputation before production use.
Skills execute code in your environment. Always review source, verify the publisher, and test in isolation before production.
Submit your Claude Code skill and start earning
Create detailed user stories, acceptance criteria, and feature specs
Example
Generate user stories for 'password reset feature' with acceptance criteria, edge cases, and test scenarios
Reduce spec writing time by 50%, ensure comprehensive coverage
Research competitors, compare features, identify gaps
Example
Analyze 5 competitor products, create feature comparison matrix, suggest differentiation opportunities
Complete competitive research in 2 hours instead of 2 days
Evaluate features using frameworks (RICE, ICE, Kano) and create prioritized backlogs
Example
Score 20 feature ideas using RICE framework, generate prioritized roadmap with rationale
4
total installs
4
this week
266
GitHub stars
0
upvotes
Run in your terminal
4
installs
4
this week
266
stars
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 pipelinesMake data-driven prioritization decisions faster
Draft PRDs, status updates, and stakeholder presentations
Example
Create executive summary of Q3 roadmap, monthly progress report, feature launch announcement
Save 3-5 hours/week on communication overhead
Prerequisites
Time Estimate
30-60 minutes to see productivity improvements
Steps
Common Pitfalls
✓ Do
✗ Don't
💡 Pro Tips
✓ Use when
Use for user story writing, competitive research, roadmap prioritization, stakeholder communication, and PRD drafting. Best for reducing repetitive documentation and research work.
✗ Avoid when
Avoid for strategic product vision (requires deep customer empathy), pricing decisions (needs market and financial expertise), or when face-to-face customer discovery is more valuable than speed.
JuliusBrussee/caveman
JuliusBrussee/caveman
whyashthakker/agent-skills-marketing
mattpocock/skills
parcadei/continuous-claude-v3
cursor/plugins
oracle-db-skills reduced setup friction for our internal harness; good balance of opinion and flexibility.
oracle-db-skills reduced setup friction for our internal harness; good balance of opinion and flexibility.
I recommend oracle-db-skills for anyone iterating fast on agent tooling; clear intent and a small, reviewable surface area.
I recommend oracle-db-skills for anyone iterating fast on agent tooling; clear intent and a small, reviewable surface area.
Keeps context tight: oracle-db-skills is the kind of skill you can hand to a new teammate without a long onboarding doc.
oracle-db-skills is among the better-maintained entries we tried; worth keeping pinned for repeat workflows.
Useful defaults in oracle-db-skills — fewer surprises than typical one-off scripts, and it plays nicely with `npx skills` flows.
Useful defaults in oracle-db-skills — fewer surprises than typical one-off scripts, and it plays nicely with `npx skills` flows.
oracle-db-skills has been reliable in day-to-day use. Documentation quality is above average for community skills.
Solid pick for teams standardizing on skills: oracle-db-skills is focused, and the summary matches what you get after install.
showing 1-10 of 33