oracle-db-skills by krisrice/oracle-db-skills
npx skills add https://github.com/krisrice/oracle-db-skills --skill oracle-db-skills一套包含 103 个独立参考指南的 Oracle 数据库资源集合。每个文件涵盖一个主题,包含解释、实用示例、最佳实践和常见错误。
| 用户询问关于… | 阅读自 |
|---|---|
| 备份、恢复、RMAN、Data Guard、重做/撤销日志、用户 | skills/admin/ |
| JDBC、连接池、JSON、XML、空间数据、全文检索、事务 | skills/appdev/ |
| RAC、CDB/PDB、Exadata、内存数据库、OCI、ATP/ADW | skills/architecture/ |
| ERD、数据建模、分区、表空间 | skills/design/ |
广告位招租
在这里展示您的产品或服务
触达数万 AI 开发者,精准高效
| Liquibase、Flyway、在线操作、EBR、utPLSQL、SQL 的 git 管理 | skills/devops/ |
| 高级队列、DBMS_SCHEDULER、物化视图、数据库链接、APEX | skills/features/ |
| 从 PostgreSQL、MySQL、SQL Server、MongoDB 等迁移 | skills/migrations/ |
| 告警日志、ADR、adrci、空间管理、Top SQL、健康检查 | skills/monitoring/ |
| ORDS、REST API、OAuth2、AutoREST、PL/SQL 网关 | skills/ords/ |
| AWR、ASH、执行计划、索引、优化器统计信息、等待事件、内存 | skills/performance/ |
| 包、游标、集合、错误处理、单元测试、调试 | skills/plsql/ |
| 权限、VPD、TDE、加密、审计、网络安全 | skills/security/ |
| SQL 模式、窗口函数、CTE、动态 SQL、注入 | skills/sql-dev/ |
| SQLcl 命令、脚本编写、Liquibase CLI、MCP 服务器、CI/CD | skills/sqlcl/ |
skills/
├── admin/ 数据库管理(备份、恢复、用户、重做/撤销)
├── appdev/ 应用开发(JSON、XML、空间数据、文本、连接池)
├── architecture/ 基础设施(RAC、多租户、Exadata、内存数据库、OCI)
├── design/ 模式设计(ERD、建模、分区、表空间)
├── devops/ CI/CD 和 DevOps(迁移、EBR、测试、版本控制)
├── features/ Oracle 功能(AQ、调度器、物化视图、数据库链接、APEX)
├── migrations/ 从其他数据库迁移到 Oracle
├── monitoring/ 诊断(告警日志、ADR、健康检查、空间管理、Top SQL)
├── ords/ Oracle REST Data Services
├── performance/ 性能调优(AWR、ASH、索引、优化器、等待事件、内存)
├── plsql/ PL/SQL 开发(包、游标、集合、测试)
├── security/ 安全(权限、VPD、TDE、审计、网络)
├── sql-dev/ SQL 开发(调优、模式、动态 SQL、注入)
└── sqlcl/ SQLcl 命令行工具(基础、脚本编写、Liquibase、MCP 服务器)
skills/sqlcl/sqlcl-mcp-server.md — 通过 SQLcl MCP 服务器将 AI 助手连接到 Oracleskills/migrations/migration-assessment.md — 任何数据库迁移项目都应从此处开始skills/performance/explain-plan.md — 所有 SQL 性能工作的基础skills/plsql/plsql-package-design.md — PL/SQL 架构问题的基础skills/devops/schema-migrations.md — 在 CI/CD 流水线中使用 Liquibase/Flyway 与 Oracle每周安装次数
95
代码仓库
GitHub 星标数
228
首次出现
13 天前
安全审计
安装于
kimi-cli92
gemini-cli92
codex92
cursor92
opencode92
github-copilot92
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 pipelinesWeekly Installs
95
Repository
GitHub Stars
228
First Seen
13 days ago
Security Audits
Gen Agent Trust HubPassSocketPassSnykPass
Installed on
kimi-cli92
gemini-cli92
codex92
cursor92
opencode92
github-copilot92
Azure 升级评估与自动化工具 - 轻松迁移 Functions 计划、托管层级和 SKU
104,900 周安装