skills.rest
maragudk
maragudkOFFICIAL
Explore all skills by this author →
WebsiteGitHub

journal

Insert and search journal entries in a SQLite database via CLI.

48|8|Updated Oct 17, 2025
Search Tags:#database#logging#memory#sqlite#journal#full-text search#AI memory
One-click install
npx skills add https://github.com/maragudk/skills --skill journal
Or copy as Structured Prompt for Agent▼
Please help me install this Agent Skill.
Skill: journal
Source: https://github.com/maragudk/skills/tree/main/journal
Command: npx skills add https://github.com/maragudk/skills --skill journal

SYSTEM DOCUMENTATION & REQUIREMENTS

What problem does it solve?

This Skill addresses the challenge of AI agents lacking persistent memory or a structured way to record ongoing thoughts, decisions, and observations, preventing context loss and repetitive explanations.

Core Features & Use Cases

  • Persistent Memory: Access a dedicated SQLite database (~/AI/journal.db) for long-term storage of AI's interactions and insights.
  • Structured Logging: Insert new entries with a simple SQL command, ensuring chronological and organized record-keeping.
  • Full-Text Search: Efficiently retrieve past entries using advanced full-text search capabilities, highlighting relevant content.
  • Use Case: An AI agent working on a long-term project can log daily progress, key decisions, and learned information, then quickly search its journal to recall past context or findings, ensuring continuity and informed decision-making.

Quick Start

Insert a new journal entry

insert into entries (content) values ('your journal entry');

Frequently Asked Questions about journal

High-intent search queries and answers about installing and using this skill.

FAQPage Schema
How do I store and retrieve journal entries in a local database?▼

Journal entries are stored in a local SQLite database at ~/AI/journal.db using simple SQL insert statements. Retrieve entries with SQL queries to access your persistent records with timestamps, enabling you to build a searchable log of thoughts and decisions over time.

Can I search through past journal entries quickly?▼

Yes, full-text search using the FTS index lets you efficiently query journal entries by content with highlighted results. Search past entries instantly to recall context, decisions, or learned information without scanning the entire database manually.

What do I need to know about the journal database schema?▼

The journal schema includes an entries table with content, created, and updated timestamp fields, plus an FTS index for full-text search. Understanding the schema structure is essential for writing correct insert statements and search queries to manage your entries effectively.

How does persistent memory help AI agents avoid context loss?▼

Persistent memory via SQLite logging prevents information loss between sessions and eliminates repetitive explanations. Long-term projects benefit from journaling daily progress and decisions, then searching the journal to recall past context and ensure informed, continuous decision-making.

Do I need SQLite command-line experience to use this journal?▼

Basic familiarity with sqlite3 CLI and SQL insert statements is required to add and search entries. The Skill assumes you can construct simple SQL commands; no advanced database administration knowledge is needed for standard logging and retrieval tasks.

Related Skills

Explore More Software Engineering Skills→
AbildtoftAbildtoft
2

kramme:setup-learn

Initialize or verify the local learnings SQLite database and rebuild its FTS index.

Community
Intermediate
lifangdalifangda
43

Remembering Conversations

Search archived Claude Code conversations semantically and by exact text with filters.

Community
Intermediate
MacPhobosMacPhobos

Kysely - Type-Safe SQL Query Builder

Build type-safe SQL queries in TypeScript with zero runtime overhead.

Community
Intermediate
davpatel605-beepdavpatel605-beep

chroma

Store and retrieve vector embeddings for semantic search and document retrieval.

Community
Intermediate