Saltar al contenido
TakoAPI
Volver a skills

lite-sqlite

por omprasad122007-rgb

Coding Agents & IDEs
429Descargas según clawskills.sh
0Vistas
0 me gustaInicia sesión para dar me gusta a esta skill
—Aún sin valoraciones
Tu valoración

Resumen

Fast lightweight local SQLite database for OpenClaw agents with minimal RAM and storage usage.

Descripción

Qué hace esta skill

Lite SQLite provides a local SQLite database layer for OpenClaw agents with low memory overhead (2-5MB typical). Supports in-memory and file-based modes, WAL mode, connection pooling, TTL-based caching, and automatic schema migration.

SQLite requires no server or configuration, making it faster to deploy for agent-local storage than alternatives like PostgreSQL or Redis.

Cuándo usarla

  • Storing agent session logs between runs
  • Caching API responses with expiry times
  • Persisting agent memos and key-value state
  • Logging structured metadata from multi-step agent tasks
  • Migrating flat JSON or CSV files into queryable storage

Flujo de trabajo de ejemplo

ENTRADA

User asks: store and retrieve memos for an agent across sessions

AGENTE
  1. 1

    Create a file-based SQLiteDB instance with WAL mode enabled

  2. 2

    Create the agent_memos table with agent_id, key, value, and expires_at columns

  3. 3

    Index agent_id and key columns for fast lookups

  4. 4

    Insert a memo with a TTL using batch_insert or insert

  5. 5

    Query memos by agent_id and key, filtering out expired rows

SALIDA

Memo records persisted to agent_data.db, retrievable by agent ID and key with automatic expiry handling

Instalación

clawhub install omprasad122007-rgb/lite-sqlite

Ejecuta el comando de la CLI o pega el prompt en Claude Code, Cursor, Codex o el agente de programación que uses.

Enlaces