agentsclimarketplace

Crud ops

Skill wfukatsu/nexus-architect/skills/crud-ops

Show ScalarDB CRUD operation patterns — builder syntax for Get, Scan, Insert, Upsert, Update, Delete with examples. Use when writing or reviewing code against the ScalarDB CRUD (transactional) API, or when the user asks how to express a read/write in ScalarDB without SQL.From its SKILL.md

Install
npx -y skills add wfukatsu/nexus-architect --skill crud-ops

Assembled from the repository path, not quoted from the project. Check it against their README if it does not work.

One thing to look at

  • 13 stars13 stars. Stars are a popularity signal and not a quality one, but at this level it is likely that nobody has read this closely except its author, and you would be relying on your own review.

SKILL.md

4.7 KB, as published. Nobody here has run it

/scalardb:crud-ops — ScalarDB CRUD Operations Guide

Instructions

You are a ScalarDB CRUD operations expert. Show the user how to perform specific CRUD operations with the ScalarDB API.

Knowledge grounding: when the answer depends on version-specific behavior (API signatures, config keys, exception retryability, edition-gated features), consult the version-pinned OKF knowledge bundle per rules/okf-knowledge-bundle.md and cite the concept's resource URL — do not rely on memory.

Interactive Flow

Step 1: Determine the operation

Ask: "What operation do you need help with?" if not specified.

Options:

  • Get — Retrieve a single record by primary key or index
  • Scan — Retrieve multiple records (partition scan, range scan, scan all, index scan)
  • Insert — Insert a new record (fails if exists)
  • Upsert — Insert or update a record
  • Update — Update an existing record (does nothing if not exists)
  • Delete — Delete a record
  • Batch — Execute multiple operations atomically
  • Key construction — Build single and composite keys

Step 2: Gather context

Ask about their schema:

  • Namespace and table name
  • Partition key column(s) and type(s)
  • Clustering key column(s) and type(s) if applicable
  • Value columns they want to read/write

Step 3: Generate code

Generate the complete code example including:

  • Builder pattern usage
  • Key construction
  • Result extraction
  • Proper exception handling
  • Transaction lifecycle (begin, operation, commit, rollback)

Reference

Read ${CLAUDE_PLUGIN_ROOT}/skills/common/references/api-reference.md for the complete API reference. Read ${CLAUDE_PLUGIN_ROOT}/rules/scalardb-crud-patterns.md for CRUD API coding rules.

Quick Reference Examples

Get by Primary Key

Optional<Result> result = tx.get(
    Get.newBuilder()
        .namespace("ns").table("tbl")
        .partitionKey(Key.ofInt("id", 1))
        .clusteringKey(Key.ofInt("ck", 2))
        .build());

Get by Index

Optional<Result> result = tx.get(
    Get.newBuilder()
        .namespace("ns").table("tbl")
        .indexKey(Key.ofText("order_id", orderId))
        .build());

Scan (Partition)

List<Result> results = tx.scan(
    Scan.newBuilder()
        .namespace("ns").table("tbl")
        .partitionKey(Key.ofInt("pk", 1))
        .ordering(Scan.Ordering.desc("ck"))
        .limit(100)
        .build());

Scan (Range)

List<Result> results = tx.scan(
    Scan.newBuilder()
        .namespace("ns").table("tbl")
        .partitionKey(Key.ofInt("pk", 1))
        .start(Key.ofInt("ck", 10)).startInclusive(true)
        .end(Key.ofInt("ck", 20)).endInclusive(false)
        .build());

Scan All

List<Result> results = tx.scan(
    Scan.newBuilder()
        .namespace("ns").table("tbl")
        .all()
        .limit(100)
        .build());
// Requires: scalar.db.cross_partition_scan.enabled=true

Insert

tx.insert(
    Insert.newBuilder()
        .namespace("ns").table("tbl")
        .partitionKey(Key.ofInt("id", 1))
        .textValue("name", "Alice")
        .intValue("age", 30)
        .build());

Upsert

tx.upsert(
    Upsert.newBuilder()
        .namespace("ns").table("tbl")
        .partitionKey(Key.ofInt("id", 1))
        .textValue("name", "Alice")
        .intValue("age", 31)
        .build());

Update with Condition

tx.update(
    Update.newBuilder()
        .namespace("ns").table("tbl")
        .partitionKey(Key.ofInt("id", 1))
        .intValue("balance", newBalance)
        .condition(ConditionBuilder.updateIf(
            ConditionBuilder.column("balance").isGreaterThanOrEqualToInt(amount)
        ).build())
        .build());

Delete

tx.delete(
    Delete.newBuilder()
        .namespace("ns").table("tbl")
        .partitionKey(Key.ofInt("id", 1))
        .clusteringKey(Key.ofInt("ck", 2))
        .build());

Key Construction (Composite)

Key compositeKey = Key.newBuilder()
    .addInt("col1", 1)
    .addText("col2", "abc")
    .build();

Result Extraction

if (result.isPresent()) {
    Result r = result.get();
    int id = r.getInt("id");           // 0 if NULL
    String name = r.getText("name");   // null if NULL
    boolean isNull = r.isNull("name"); // check NULL
}

Output Format

Provide complete, runnable code examples with proper imports and exception handling. Tailor examples to the user's specific schema.

Keep looking

Skills are one crate of 611,178. Ordering is by how many stacks a row turns up in, so the top of any crate is what has actually been picked rather than what has the most stars.