Pular para o conteúdo
TakoAPI
Voltar às skills

lite-sqlite

por omprasad122007-rgb

Coding Agents & IDEs
429Downloads informados pelo clawskills.sh
0Visualizações
0 curtidaEntre para curtir esta skill
—Ainda sem avaliações
Sua avaliação

Resumo

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

Descrição

O que esta skill faz

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.

Quando usá-la

  • 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

Exemplo de fluxo de trabalho

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

SAÍDA

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

Instalação

clawhub install omprasad122007-rgb/lite-sqlite

Execute o comando da CLI ou cole o prompt no Claude Code, Cursor, Codex ou no agente de código que você usa.

Links