Agent skill · software engineering · aiskillstore
sqlite-ops
Patterns for SQLite databases in Python projects - state management, caching, and async operations. Triggers on: sqlite, sqlite3, aiosqlite, local database, database schema, migration, wal mode.
Why this skill is useful
Provides specific patterns and best practices for managing SQLite databases in Python, including async operations and state management that the AI may not reliably generate on its own.
What it needs
About 1k tokens when loaded. Last updated 2026-08-07. 405 stars on the source repository.
What this skill does
SQLite Operations Patterns for SQLite databases in Python projects. Quick Connection Context Manager Pattern WAL Mode Enable for concurrent read/write: Mode Reads Writes Best For ------ ------- -------- ---------- DELETE (default) Blocked during write Single Simple scripts WAL Concurrent Single Web apps, MCP servers Common Gotchas Issue Solution ------- ---------- "database is locked" Use WAL mode Slow queries Add indexes, check EXPLAIN QUERY PLAN Thread safety Use checksamethread=False FK not enforced Run PRAGMA foreignkeys=ON CLI Quick Reference When to Use Local state/config storage Caching layer Event logging MCP server persistence Small to medium datasets Additional Resources For detailed patterns, load: ./references/schema-patterns.md - State, cache, event, queue table designs ./references/async-patterns.md - aiosqlite CRUD, batching, connection pools ./references/migration-patterns.md - Version migrations, JSON handling
How to use it
Reference it in AdaL, Claude Code, Cursor or any coding agent — nothing to install:
@skills aiskillstore/sqlite-ops