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-sqliteCLIコマンドを実行するか、Claude Code、Cursor、Codexなどお使いのコーディングエージェントにプロンプトを貼り付けてください。