Data Vault

# Bootstrap uv if missing - kind: "shell" cmd: "pip install --upgrade uv || true" label: "Install uv if missing"

# Install pylance - kind: "uv" type: "pip" package: "pylance" label: "Install pylance (Lance columnar format) via uv"

# Install pandas - kind: "uv" type: "pip" package: "pandas" label: "Install pandas via uv"

Data Vault

Installation

uv pip install pylance pandas

A persistent data store using the Lance columnar format for fast ML data access.

Quick Start

# List all datasets and their metadata
python3 scripts/command.py list-datasets-info
Create a dataset
python3 scripts/command.py create-dataset    ...
Append data
python3 scripts/command.py append-to-dataset    ...
Read all records from a dataset
python3 scripts/command.py read-dataset 

Note: list-datasets-info shows dataset metadata (schema, field types, record count) — it does not return the actual data rows. Use read-dataset to retrieve records.

Storage Location

DataSets are created and stored on the current path '.'

Critical Behavior: Data Type Strictness

⚠️ Lance is strict about data types — they CANNOT change after the first record

When you append the first record to a dataset, Lance infers the data type for each field. All subsequent records MUST use the same types.

Example — this FAILS:

# First record: age as STRING
append-to-dataset users "John" "25" "john@test.com"
Second record: age as INTEGER (will FAIL!)
append-to-dataset users "Jane" 30 "jane@test.com"
Error: age should have type large_string but type was int64

Correct approach — maintain consistent types:

# First record: age as STRING
append-to-dataset users "John" "25" "john@test.com"
Second record: age as STRING
append-to-dataset users "Jane" "30" "jane@test.com"

Why This Matters

Unlike traditional databases that may coerce types, Lance rejects type mismatches. If you store numbers as strings initially, you must always pass strings. Plan your schema carefully.

Initialization Workflow

When starting a session, always initialize by listing existing datasets first:

# This command returns ALL datasets with their structure
python3 scripts/command.py list-datasets-info

Example output:

{
    "skill": "data-vault",
    "operation": "list_datasets_info",
    "status": "success",
    "data": [
        {
            "dataset_name": "users",
            "path": "/data/users",
            "fields": ["name", "age", "email"],
            "field_types": {
                "_id": "large_string",
                "_updated_at": "timestamp[us]",
                "name": "large_string",
                "age": "large_string",
                "email": "large_string"
            },
            "record_count": 2,
            "columns": ["id", "_updated_at", "name", "age", "email"],
            "last_updated": "2026-03-21T17:57:44.595628"
        }
    ],
    "error": null
}

Understanding field_types

| State | Meaning | | ------------ | ------------------------------------------------------------- | | {} (empty) | Dataset exists but no records yet — types not yet defined | | populated | Types are locked — appends must match |

Important: If field_types is empty, the first append will define types. Be deliberate about the first record's types.

Commands Reference

Create Dataset

python3 scripts/command.py create-dataset    ...

Creates a metadata entry. Fields have no types until first append.

Append Record

python3 scripts/command.py append-to-dataset    ...

Appends one record. Types are inferred from first record.

Batch Append

python3 scripts/command.py batch-append-to-dataset  ''

Example: batch-append-to-dataset users '[["Alice", "22", "alice@test.com"], ["Bob", "35", "bob@test.com"]]'

Update Record

python3 scripts/command.py update-dataset-record     ...

Updates fields for a specific record by ID.

Delete Record

python3 scripts/command.py delete-dataset-record  

List All Datasets

python3 scripts/command.py list-datasets

Get Dataset Info

python3 scripts/command.py get-dataset-info 

Returns schema, field types (if data exists), and record count.

List All Datasets with Full Info

python3 scripts/command.py list-datasets-info

Recommended for initialization. Returns all datasets with complete metadata.

Get Dataset Path

python3 scripts/command.py get-dataset-path-info 

Backup Dataset

python3 scripts/command.py backup-dataset  

Count Records

python3 scripts/command.py count-records 

Read All Records

Returns all records from the dataset as a list of objects.

python3 scripts/command.py read-dataset 

Drop Dataset

Requires confirmation if have not created a backup beforehand.

Delete the entire dataset and its metadata.

python3 scripts/command.py drop-dataset 

Internal fields available in every dataset:

| Field | Type | Description | | ------------- | --------- | -------------------------------------------- | | _id | string | UUID — unique record identifier | | _updated_at | timestamp | When the record was last inserted or updated |

List Records (Paginated)

python3 scripts/command.py list-records  --limit 10 --offset 0

Returns records with optional pagination.

Get Single Record

python3 scripts/command.py get-record  

Retrieves a specific record by its UUID.

Get Dataset Info

python3 scripts/command.py get-dataset-info 

Returns schema, field types (if data exists), and record count.

Response Format

All commands return JSON:

{
  "skill": "data-vault",
  "operation": "",
  "status": "success|error",
  "data": ,
  "error": 
}

Internal Fields

Every dataset automatically includes:

These are managed automatically — when appending, only provide your defined fields.

Data Type Inference

Lance infers types from the first record:

| Python Type | Lance Type | | -------------- | -------------- | | "string" | large_string | | 25 (int) | int64 | | 25.5 (float) | float64 | | True/False | bool |

CLI caveat: When passing via command line, all values are strings. To ensure integer types, initialize with actual integers in a script rather than CLI.

Tips

1. Initialize at session start: Run list-datasets-info to understand what data already exists 2. Plan your schema: First record determines types for the entire dataset 3. Use batch append when adding multiple records: More efficient than individual appends

Requirements

Dependencies are declared in frontmatter (metadata.openclaw.install) and handled by the OpenClaw install system via uv. The Python packages required are:

⚠️ Naming note: Despite the PyPI package being named pylance, the library is imported as import lance in Python code. This is the official Lance project naming convention — it is NOT the VS Code "pylance" language server. See lance.org for details.

# List all datasets and their metadata
python3 scripts/command.py list-datasets-info
Create a dataset
python3 scripts/command.py create-dataset    ...
Append data
python3 scripts/command.py append-to-dataset    ...
Read all records from a dataset
python3 scripts/command.py read-dataset 

Note: list-datasets-info shows dataset metadata (schema, field types, record count) — it does not return the actual data rows. Use read-dataset to retrieve records.

1. Initialize at session start: Run list-datasets-info to understand what data already exists 2. Plan your schema: First record determines types for the entire dataset 3. Use batch append when adding multiple records: More efficient than individual appends