lite-sqlite
由 omprasad122007-rgb 提供
Coding Agents & IDEs简介
Fast lightweight local SQLite database for OpenClaw agents with minimal RAM and storage usage.
描述
该技能的功能
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.
何时使用
- 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
示例工作流
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
安装
clawhub install omprasad122007-rgb/lite-sqlite运行 CLI 命令,或把这段提示词粘贴到 Claude Code、Cursor、Codex 或你在用的任意编程智能体里。