Manage SQLite schema initialization, migrations, and data persistence.
npx skills add https://github.com/arunoda/OkBrain --skill database-arunoda
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
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.
sqlite-vec for efficient semantic search capabilities.conversations or documents tables, respectively, and maintains relationships with other data entities.Use the database skill to initialize the schema if it doesn't exist.
High-intent search queries and answers about installing and using this skill.
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.
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.
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.
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.
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.
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.
TorbenMerraldDefine and enforce database models and entity schemas across ORM and migration scripts.
gtrigGenerate 1024-dim embeddings and perform HNSW similarity searches with gobed.
NNPopovDesign Flutter data layers with SQLite repositories and synchronization workflows.
thecloudtipsSyncs a local SQLite memory store with a Notion database bidirectionally.