一键在 Manus 中运行任何 Skill

db

星标748

分支195

更新时间2026年6月5日 11:29

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.

安装

用 Codex 或 Claude 帮你安装复制这段 Prompt，粘贴到 Codex、Claude 或其他助手里，让它检查 Skill 页面并帮你完成安装。

在 Manus 中运行

来源

oracle

oracle/skills

打开 GitHub 仓库查看创作者相关仓库

下载

在 Manus 中运行

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

db/
├── 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	`db/admin/`
Safe DML, destructive operation guards, idempotency, schema discovery, ORA- error handling	`db/agent/`
JDBC, pooling, JSON, XML, spatial, Oracle Text, transactions, MLE, language drivers	`db/appdev/`
RAC, Multitenant, Exadata, In-Memory, OCI database services, Data Guard architecture	`db/architecture/`
Backup, recovery, RMAN, Autonomous Recovery Service, Cloud Protect	`db/backup-recovery/`
OCR database-category container images and pull guidance	`db/containers/`
ERD, data modeling, partitioning, tablespaces	`db/design/`
Schema migrations, online operations, edition-based redefinition, testing, version control	`db/devops/`
AQ, DBMS_SCHEDULER, materialized views, DBLinks, APEX, vector search, SELECT AI	`db/features/`
SQLAlchemy, Django, Pandas, Spring JPA, MyBatis, TypeORM, Sequelize, Dapper, GORM	`db/frameworks/`
Migrations from PostgreSQL, MySQL, SQL Server, MongoDB, Snowflake, and more	`db/migrations/`
Alert log, ADR, health monitor, space management, top SQL	`db/monitoring/`
ORDS architecture, installation, REST design, authentication, monitoring, ORDS Concert Sample App	`db/ords/`
AWR, ASH, explain plan, indexes, optimizer stats, wait events, memory	`db/performance/`
Package design, error handling, performance, collections, cursors, debugging	`db/plsql/`
Privileges, VPD, masking, auditing, encryption, network security	`db/security/`
SQL tuning, SQL patterns, dynamic SQL, injection avoidance	`db/sql-dev/`
SQLcl basics, scripting, Liquibase, formatting, DDL generation, data loading, MCP server, scheduler daemon, AWR, background jobs, schema comparison with DIFF	`db/sqlcl/`

Key Starting Points

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

同仓库更多 Skills

同仓库

oci-functions-deploy

oracle/skills

Build, configure, scaffold, and deploy OCI Functions from a local machine using a dependency-first, Fn-context-guided flow with argv-safe mutation execution, nonce-scoped confirmations, and a canonical lowercase machine-readable contract. Use when asked to validate/install Fn, OCI CLI, and Docker, configure or create Fn contexts, validate OCI session and Docker registry auth from Fn context values, choose or create a Functions application, scaffold Java, Python, or Node functions, and deploy them. Network creation is supported only as an explicit advanced branch.

2026-06-30748

oci-functions-troubleshoot

oracle/skills

Diagnose OCI Functions setup, control-plane, deployment, invocation, and observability issues using a deterministic triage workflow. Use when asked to classify Fn CLI errors, deploy or invoke failures, OCIR auth and registry issues, app-limit symptoms, logs, tracing, metrics, or limits. Diagnose first, prefer read-only checks, and do not execute fixes unless the user explicitly asks.

2026-06-30748

oci

oracle/skills

Oracle Cloud Infrastructure guidance for designing, operating, and troubleshooting OCI services, including OCI Kubernetes Engine (OKE), OCI Internet of Things Platform, OCI Functions deployment and troubleshooting, and Enterprise AI workflows for OCI Generative AI models, Responses API agents, RAG, cost estimation, governance, private endpoints, hosted agentic applications, and Oracle platform integrations. Use when the user asks about OKE cluster design, Terraform or Resource Manager planning, OKE incident troubleshooting, Generic VNIC Attachment, Multus, pod networking, node pools, add-ons, ingress, load balancers, OCIR image pulls, Workload Identity, Kubernetes workloads on OCI, OCI IoT domains or digital twins, device publish flows, OCI Functions setup, deployment, invocation, or troubleshooting, OCI Generative AI, Enterprise AI Models, Enterprise AI Agents, governed GenAI applications, agentic workflows, RAG on Oracle Cloud, or OCI Generative AI pricing.

2026-06-30748

apexlang

oracle/skills

Public APEXlang router with deterministic local-context discovery and compact machine-readable contracts.

2026-06-26748

apex

oracle/skills

Oracle APEX skills for Oracle APEX application development.

2026-06-26748

oci-iot-platform

oracle/skills

Explore, create, and troubleshoot Oracle Cloud Infrastructure Internet of Things Platform resources, including domains, digital twin models, adapters, instances, relationships, and device publish flows. Use when requests involve OCI IoT bootstrap, digital twin inspection, safe lifecycle operations, or translating OCI IoT docs and samples into concrete commands.

2026-06-23748

name

description

Oracle Database Skills

How to Use This Domain

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

Directory Structure

db/
├── 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	`db/admin/`
Safe DML, destructive operation guards, idempotency, schema discovery, ORA- error handling	`db/agent/`
JDBC, pooling, JSON, XML, spatial, Oracle Text, transactions, MLE, language drivers	`db/appdev/`
RAC, Multitenant, Exadata, In-Memory, OCI database services, Data Guard architecture	`db/architecture/`
Backup, recovery, RMAN, Autonomous Recovery Service, Cloud Protect	`db/backup-recovery/`
OCR database-category container images and pull guidance	`db/containers/`
ERD, data modeling, partitioning, tablespaces	`db/design/`
Schema migrations, online operations, edition-based redefinition, testing, version control	`db/devops/`
AQ, DBMS_SCHEDULER, materialized views, DBLinks, APEX, vector search, SELECT AI	`db/features/`
SQLAlchemy, Django, Pandas, Spring JPA, MyBatis, TypeORM, Sequelize, Dapper, GORM	`db/frameworks/`
Migrations from PostgreSQL, MySQL, SQL Server, MongoDB, Snowflake, and more	`db/migrations/`
Alert log, ADR, health monitor, space management, top SQL	`db/monitoring/`
ORDS architecture, installation, REST design, authentication, monitoring, ORDS Concert Sample App	`db/ords/`
AWR, ASH, explain plan, indexes, optimizer stats, wait events, memory	`db/performance/`
Package design, error handling, performance, collections, cursors, debugging	`db/plsql/`
Privileges, VPD, masking, auditing, encryption, network security	`db/security/`
SQL tuning, SQL patterns, dynamic SQL, injection avoidance	`db/sql-dev/`
SQLcl basics, scripting, Liquibase, formatting, DDL generation, data loading, MCP server, scheduler daemon, AWR, background jobs, schema comparison with DIFF	`db/sqlcl/`

Key Starting Points

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