跳到正文
TakoAPI
返回技能列表

lite-sqlite

由 omprasad122007-rgb 提供

Coding Agents & IDEs
429下载量由 clawskills.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 或你在用的任意编程智能体里。

链接