OCI NoSQL Pattern
| Always-on rule |
Required behavior |
| Scope |
Oracle NoSQL Database Cloud Service (NDCS), not Oracle Database/Autonomous SQL, on-prem snapshots or DynamoDB |
| Safety |
No cloud, credentials, installs, data reads/writes, export/import or load on skill load; preserve current IaC owner/data |
| Authorization |
Before live metadata reads confirm principal, tenancy, region, compartment, table and permitted evidence; writes/load/recovery need exact separate approval |
| Evidence |
Separate request, proposed plan, local checks, control-plane readback and application proof; label facts, assumptions and UNVERIFIED |
| Loading |
Read only selected command/features and selected audit/recovery method; do not recursively read links or sibling guides |
| Language |
Use existing SDK/language; no forced ORM or native capability invented to match another provider |
Recognize /oci-nosql-pattern <command> only when the host supports skill discovery;
$oci-nosql-pattern or plain language may also select it. No host registration.
The real local selector emits paths, not execution:
python3 scripts/select_mode.py /oci-nosql-pattern <command> [options].
| Command |
Load only selected route |
| help |
Help; show commands and stop |
| select |
Feature selection |
| design |
Access-pattern design |
| refactor |
Compatibility and migration |
| audit |
Audit, then selected offline/live variant |
| performance-test |
Bounded plan, not a run |
| feature-plan |
Lifecycle plan, not application |
| backup |
Backup, then selected migrator/sdk method |
| restore |
Restore, then selected migrator/sdk method; NEW target only |
| Task/feature |
Read only when selected |
| core |
Model and runtime |
| indexes |
Secondary indexes; no LSI/GSI classification |
| iam |
OCI access |
| encryption |
Managed versus dedicated CMEK |
| ttl |
Expiration |
| replicas |
Global Active Tables, not backup |
| monitoring |
Metrics |
| vectors |
Types/native capability boundary |
| embeddings |
Generation/source/retrieval integration |
| backup |
Customer recovery boundary, not every method |
| Provisioning requested |
Terraform/DDL/CLI, then selected asset |
| Language requested |
Adapters, matching section only |
| Current capability/source question |
Dated sources |
| Due review or skill edits |
Maintenance or eval contract |
Audit defaults offline; recovery defaults migrator. Unknown/unsupported options fail
closed. vectors is informational; native ANN activation and --method pitr fail.
Bundles/manual sequences select scope only, never persistent activation or a chain.
At substantive use run scripts/review_due.py --as-of YYYY-MM-DD with the actual
client-local date. Review every June/December; next 2026-12-01. Due/overdue:
load Maintenance and remind the user; never roll forward or schedule notifications.
1---2name: oci-nosql-pattern3description: "Design, implement, refactor and audit Oracle NoSQL Database Cloud Service access patterns in any language. Use for shard/primary keys, SQL/secondary indexes, continuation, same-shard transactions, consistency/version/TTL, OCI IAM/encryption, replicas, metrics, Terraform/DDL/OCI CLI, embeddings boundaries, bounded performance plans and customer-owned export/import recovery. Lazy command/feature routes; not Oracle SQL Database, native vector/PITR enablement or permission for live access."4allowed-tools: Read Grep Glob Bash(python3 scripts/select_mode.py:*) Bash(python3 scripts/review_due.py:*)5metadata:6 source: https://skillmd.com/skills/vincentchuwaichow/oci-nosql-pattern7 author: "github: VincentChuWaiChow"8 version: "1.0.0"9 updated: "2026-11-09"10 category: data11---1213# OCI NoSQL Pattern1415| Always-on rule | Required behavior |16|---|---|17| Scope | Oracle NoSQL Database Cloud Service (NDCS), not Oracle Database/Autonomous SQL, on-prem snapshots or DynamoDB |18| Safety | No cloud, credentials, installs, data reads/writes, export/import or load on skill load; preserve current IaC owner/data |19| Authorization | Before live metadata reads confirm principal, tenancy, region, compartment, table and permitted evidence; writes/load/recovery need exact separate approval |20| Evidence | Separate request, proposed plan, local checks, control-plane readback and application proof; label facts, assumptions and UNVERIFIED |21| Loading | Read only selected command/features and selected audit/recovery method; do not recursively read links or sibling guides |22| Language | Use existing SDK/language; no forced ORM or native capability invented to match another provider |2324Recognize `/oci-nosql-pattern <command>` only when the host supports skill discovery;25`$oci-nosql-pattern` or plain language may also select it. No host registration.26The real local selector emits paths, not execution:27`python3 scripts/select_mode.py /oci-nosql-pattern <command> [options]`.2829| Command | Load only selected route |30|---|---|31| help | [Help](references/commands/help.md); show commands and stop |32| select | [Feature selection](references/commands/select.md) |33| design | [Access-pattern design](references/commands/design.md) |34| refactor | [Compatibility and migration](references/commands/refactor.md) |35| audit | [Audit](references/commands/audit.md), then selected offline/live variant |36| performance-test | [Bounded plan](references/commands/performance-test.md), not a run |37| feature-plan | [Lifecycle plan](references/commands/feature-plan.md), not application |38| backup | [Backup](references/commands/backup.md), then selected migrator/sdk method |39| restore | [Restore](references/commands/restore.md), then selected migrator/sdk method; NEW target only |4041| Task/feature | Read only when selected |42|---|---|43| core | [Model](references/modeling.md) and [runtime](references/runtime-contract.md) |44| indexes | [Secondary indexes](references/indexes.md); no LSI/GSI classification |45| iam | [OCI access](references/access.md) |46| encryption | [Managed versus dedicated CMEK](references/encryption.md) |47| ttl | [Expiration](references/ttl.md) |48| replicas | [Global Active Tables](references/replicas.md), not backup |49| monitoring | [Metrics](references/monitoring.md) |50| vectors | [Types/native capability boundary](references/types-and-vectors.md) |51| embeddings | [Generation/source/retrieval integration](references/embedding-integrations.md) |52| backup | [Customer recovery boundary](references/recovery-boundary.md), not every method |53| Provisioning requested | [Terraform/DDL/CLI](references/provisioning.md), then selected asset |54| Language requested | [Adapters](references/language-adapters.md), matching section only |55| Current capability/source question | [Dated sources](references/sources.md) |56| Due review or skill edits | [Maintenance](references/maintenance.md) or [eval contract](evals/eval.md) |5758Audit defaults offline; recovery defaults migrator. Unknown/unsupported options fail59closed. `vectors` is informational; native ANN activation and `--method pitr` fail.60Bundles/manual sequences select scope only, never persistent activation or a chain.61At substantive use run `scripts/review_due.py --as-of YYYY-MM-DD` with the actual62client-local date. Review every June/December; next **2026-12-01**. Due/overdue:63load Maintenance and remind the user; never roll forward or schedule notifications.