본문으로 건너뛰기
TakoAPI
스킬로 돌아가기

lite-sqlite

omprasad122007-rgb 제작

Coding Agents & IDEs
429clawskills.sh가 보고한 다운로드 수
0조회수
좋아요 0개로그인하면 이 스킬에 좋아요를 누를 수 있습니다
—아직 평가 없음
내 평가

요약

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. 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

출력

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 등 사용하는 코딩 에이전트에 붙여넣으세요.

링크