From software-of-you
Guides SQLite read/write operations in Software of You with schema references, query patterns, activity logging, datetime conventions, and sqlite3 command usage.
How this skill is triggered — by the user, by Claude, or both
Slash command
/software-of-you:sqlite-operationsThe summary Claude sees in its skill listing — used to decide when to auto-load this skill
This skill provides reference material for all database operations in Software of You.
This skill provides reference material for all database operations in Software of You.
references/schema.sql — current complete schema for all installed modulesreferences/query-patterns.md — common query patterns with examplessqlite3 "${CLAUDE_PLUGIN_ROOT:-$(pwd)}/data/soy.db" for operationsdatetime('now')activity_log after any data modificationupdated_at = datetime('now') on updatesLIKE '%term%' for text search (case-insensitive by default in SQLite)json_object() for structured details in activity_lognpx claudepluginhub kmorebetter/better-software-of-youGuides sqlite3 CLI usage to build composable SQLite knowledge databases, design schemas, query data, manage relationships, and output for agent parsing.
Guides safe database workflows: schema inspection before queries, read-before-write previews for mutations, user confirmations, and post-change verification.
Generates optimized SQL queries for PostgreSQL, MySQL, SQLite and NoSQL for MongoDB, DynamoDB, Redis; supports ORMs like Prisma. Explains plans, indexes, and performance optimizations.