skills.rest
Abildtoft
AbildtoftCOMMUNITY
Explore all skills by this author →
GitHub

kramme:setup-learn

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

2|2|Updated Jan 15, 2026
Search Tags:#database#maintenance#setup#learnings#fts#sqlite3
One-click install
npx skills add https://github.com/Abildtoft/kramme-cc-workflow --skill kramme-setup-learn
Or copy as Structured Prompt for Agent▼
Please help me install this Agent Skill.
Skill: kramme:setup-learn
Source: https://github.com/Abildtoft/kramme-cc-workflow/tree/main/skills/kramme%3Asetup-learn
Command: npx skills add https://github.com/Abildtoft/kramme-cc-workflow --skill kramme-setup-learn

SYSTEM DOCUMENTATION & REQUIREMENTS

💡 This Skill requires sqlite3, and includes scripts (resource) components.

What problem does it solve?

Initialize or verify the local learnings database used by kramme-cc-workflow.

Core Features & Use Cases

  • Initialize missing database at ~/.kramme-cc-workflow/learnings.db
  • Health check and report on required tables (learnings, learnings_fts, learnings_ai, learnings_ad, learnings_au)
  • Rebuild the Full-Text Search index (FTS) when requested
  • Force recreate with backup and safe restoration

Quick Start

Use the skill to initialize or verify the database and perform maintenance. Example: /kramme:setup-learn --check to health-check; add --force to backup and recreate, or --rebuild-fts to refresh the FTS index.

Frequently Asked Questions about kramme:setup-learn

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

FAQPage Schema
How do I initialize a local SQLite3 learnings database for workflow tracking?▼

To initialize the SQLite3 learnings database, the skill creates the missing database file at ~/.kramme-cc-workflow/learnings.db and sets up required tables including learnings, learnings_fts, learnings_ai, learnings_ad, and learnings_au.

Why does my full-text search index return empty results on a SQLite3 database?▼

A corrupted or stale FTS index on a SQLite3 database can return empty results. Rebuilding the full-text search index refreshes the learnings_fts table to restore fast and accurate lookup of stored learnings.

Do I need sqlite3 installed to verify database health and table integrity?▼

Yes, sqlite3 is required to verify database health and table integrity. The skill checks for the key tables (learnings, learnings_fts, learnings_ai, learnings_ad, learnings_au) to ensure proper database structure and fast lookup.

What is the best way to safely recreate a SQLite3 database without losing learning records?▼

The best way to safely recreate a SQLite3 database is using a force recreation command that backs up existing data before restoration. This ensures learnings records are preserved while rebuilding the database structure.

Can I rebuild the FTS index on an existing learnings database without dropping tables?▼

Yes, you can rebuild the FTS index on an existing database without dropping core tables. The skill refreshes the learnings_fts table specifically to maintain fast full-text search lookups of stored learnings.

Related Skills

Explore More Software Engineering Skills→
agentmattersagentmatters
3

configure-ecc

Guide ECC installation by selecting level, skills, and rules.

Official
Advanced
adityasingh2400adityasingh2400
2

learn

Index project learnings across sessions for search, prune, and export workflows.

Community
Intermediate
AbildtoftAbildtoft
2

kramme:learn

Add learnings to a SQLite database and propose AGENTS.md updates.

Community
Advanced
rodydavisrodydavis
58

how-to-export-sqlite-tables-to-create-statements

Export SQLite tables and indexes into runnable CREATE statements using Dart.

Community
Intermediate