Database

Manage SQLite schema initialization, migrations, and data persistence.

21|4|Updated Feb 20, 2026

Search Tags:#database #schema #sqlite #vector search #data persistence #local storage

Ready to run

npx skills add https://github.com/arunoda/OkBrain --skill database-arunoda

💬 Prompt for ChatGPT / Claude Chat▼

Please help me install this Agent Skill.
Skill: Database
Source: https://github.com/arunoda/OkBrain/tree/main/.agent/skills/database
Command: npx skills add https://github.com/arunoda/OkBrain --skill database-arunoda

SYSTEM DOCUMENTATION & REQUIREMENTS

💡 This Skill includes references (resource) components.

What problem does it solve?

This Skill provides a robust and organized way to manage your application's local SQLite database, ensuring data integrity and efficient access for various features.

Core Features & Use Cases

Schema Management: Automatically initializes and updates the SQLite database schema.
Data Storage: Handles all data persistence for conversations, documents, events, and user memory.
Vector Search: Integrates sqlite-vec for efficient semantic search capabilities.
Use Case: When you add a new conversation or document, this Skill ensures the data is correctly stored in the conversations or documents tables, respectively, and maintains relationships with other data entities.

Quick Start

Use the database skill to initialize the schema if it doesn't exist.

Frequently Asked Questions about Database

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

FAQPage Schema

How do I manage SQLite database schema migrations and ensure data persistence for conversations and documents?▼

SQLite database schema migrations and data persistence are managed by automatically initializing and updating schema definitions, storing conversations and documents in dedicated tables, and maintaining entity relationships via a modularized DbWrapper interface.

Can I use SQLite for local vector search and semantic data retrieval?▼

SQLite supports local vector search by integrating the sqlite-vec extension, enabling efficient semantic search capabilities directly within your local file-based database without needing a separate external vector store.

How do I initialize a local SQLite database with WAL mode and foreign key enforcement?▼

Local SQLite database initialization with WAL mode and foreign key enforcement is handled automatically by the Skill, configuring the local file-based storage to ensure data integrity and concurrent read access.

What is the best way to store user data, events, and background jobs in a local SQLite database?▼

Storing user data, events, and background jobs in a local SQLite database is achieved through a modularized DbWrapper interface that handles all data persistence operations and maintains relationships across these core application features.

Does this database Skill support vector search for local file-based storage?▼

Vector search is supported for local file-based storage through an optional sqlite-vec integration, allowing you to perform semantic search operations alongside standard relational data queries.

When do I need to use a modularized DbWrapper interface for local storage?▼

A modularized DbWrapper interface is needed for local storage when your application requires organized data persistence for conversations, documents, events, and user memory while maintaining strict foreign key relationships.