lite-sqlite
di omprasad122007-rgb
Coding Agents & IDEsSintesi
Fast lightweight local SQLite database for OpenClaw agents with minimal RAM and storage usage.
Descrizione
Cosa fa questa 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.
Quando 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
Esempio di workflow
User asks: store and retrieve memos for an agent across sessions
- 1
Create a file-based SQLiteDB instance with WAL mode enabled
- 2
Create the agent_memos table with agent_id, key, value, and expires_at columns
- 3
Index agent_id and key columns for fast lookups
- 4
Insert a memo with a TTL using batch_insert or insert
- 5
Query memos by agent_id and key, filtering out expired rows
Memo records persisted to agent_data.db, retrievable by agent ID and key with automatic expiry handling
Installazione
clawhub install omprasad122007-rgb/lite-sqliteEsegui il comando CLI oppure incolla il prompt in Claude Code, Cursor, Codex o nell'agente di coding che usi.