원클릭으로 Manus에서 모든 스킬 실행

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 저장소 열기 Creator 저장소 보기

다운로드

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)