LogoClawIndex
CasesSkillsAbout
LogoClawIndex

ClawIndex

OpenClaw Skills & Use Case Index

ClawIndex is an ecosystem-driven index of OpenClaw skills and real-world use cases.

Index

Skills·
Cases

Meta

About·
Disclaimer·
Email·
GitHub
© 2026 ClawIndex All Rights Reserved.

how-to-store-sqlite-as-nosql-store - Store JSON documents in SQLite with TTL expiration

Use SQLite's JSON support to create a document store with TTL-based expiration

Tags

Updated: 2026-02-18

Capabilities

Typical Inputs

Typical Outputs

What this skill does

  • create table for JSON documents
  • save JSON documents
  • read JSON documents
  • query documents by prefix
  • delete expired documents

Inputs

  • JSON documents
  • document paths
  • TTL values
  • SQLite database

Outputs

  • Stored documents in SQLite
  • Query results
  • Document deletions

Requirements

  • SQLite with JSON support
  • Database connection

Source

  • Spec: SKILL.md
SQLite
NoSQL
JSON
Document Storage
TTL
create table for JSON documents
save JSON documents
read JSON documents
query documents by prefix
JSON documents
document paths
TTL values
Stored documents in SQLite
Query results
Document deletions