A professional-grade SQLite-based note management system designed for AI agents to capture, optimize, and archive information seamlessly.
Install & Download
1. ClawHub CLI
The fastest way to install a skill directly from the registry.
npx clawhub@latest install notes-skill
2. Manual Installation
Copy the skill folder to one of these locations
~/.openclaw/skills/ <project>/skills/ Priority: Workspace > Local > Bundled
3. Prompt Installation
Copy this prompt to OpenClaw to install it automatically.
Help me install notes-skill using Clawhub. If Clawhub is not installed, install it first (npm i -g clawhub).
Prefer to download?
Get the raw skill files in a ZIP archive.
What is SQLite Notes Skill?
The SQLite Notes Skill is a robust data management tool that enables AI agents to maintain a structured personal knowledge base. By utilizing a local SQLite database, it provides a persistent and searchable repository for everything from technical snippets to quick thoughts. This skill is a core component of the Openclaw Skills ecosystem, focusing on data integrity and high-quality information retrieval through advanced AI-driven content refinement.
SQLite Notes Skill Use Cases
- Capturing technical logs or error messages during development sessions.
- Quick voice-to-text note-taking where the AI optimizes the transcript for readability.
- Building a searchable archive of historical project decisions and reminders.
- Automated daily backups of critical information to prevent data loss.
How SQLite Notes Skill Works
- The AI agent identifies a note-taking intent based on user triggers like "save a note" or "search for."
- Before writing to the database, the agent performs content optimization, correcting grammar and improving structure.
- The optimized text is inserted into a local SQLite database with automated timestamps.
- Users can retrieve information through fuzzy matching and natural language queries.
- A dedicated backup utility ensures data persists across different environments within the Openclaw Skills framework.
SQLite Notes Skill Setup
To get started with this skill, you need to initialize the database and directory structure. Run the following command in your terminal:
python3 ~/.agents/skills/notes-skill/scripts/init.py
For manual backups, you can specify the number of copies to retain:
python3 ~/.agents/skills/notes-skill/scripts/backup.py 10
SQLite Notes Skill Data Schema & Taxonomy
The notes are stored in a structured format within the notes.db file located at ~/.openclaw/workspace/notes/.
| Column | Type | Description |
|---|---|---|
| id | INTEGER | Unique identifier for each note entry |
| content | TEXT | The optimized and formatted note content |
| archived | INTEGER | Status flag (0 for active, 1 for archived) |
| created_at | DATETIME | Automatic local timestamp of creation |
SQLite Notes Skill Advanced Features
- Intelligent Pre-processing: AI automatically fixes typos and improves document structure before saving.
- Automated Cron Integration: Supports scheduled daily backups at 2 AM via the Openclaw Skills cron system.
- Performance Indexing: Includes optimized SQL indexes for fast descending-order time queries and status filtering.
- Robust Archiving: Move completed items out of the primary view without deleting them, maintaining a clean workspace.
SKILL.md
Loading
Related Openclaw Skills
Copilot Pet
A model-agnostic virtual pet system designed to bring emotional engagement and wellbeing to AI-assisted development workflows.
Anthropic Buddy
A sophisticated AI companion system featuring real-time metabolism, 73+ species, and permanent death mechanics.
April Fools Pet
A high-stakes virtual pet skill where the April Fools joke is the reality of permanent death and real-time care.
Terminal Tamagotchi
A sophisticated API-driven virtual pet system that allows AI agents to adopt, care for, and evolve digital creatures with real-time stakes.
Mihomo Subscription Route Publisher
An intelligent automation skill to update, deploy, and verify Mihomo routing rules and subscriptions through natural language commands.
Red Team AI Security Scanner
A proactive security scanning skill designed to identify vulnerabilities like prompt injection and secret extraction in AI agents.
Featured*
