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.
87
80%
Does it follow best practices?
Impact
100%
1.13xAverage score across 3 eval scenarios
Passed
No known issues
Optimize this skill with Tessl
npx tessl skill review --optimize ./data/skills-md/0xdarkmatter/claude-mods/sqlite-ops/SKILL.mdSQLite connection setup
WAL mode enabled
100%
100%
row_factory set
100%
100%
check_same_thread disabled
100%
100%
Foreign keys enabled
100%
100%
Foreign key in schema
100%
100%
Row factory used in demo
100%
100%
get_connection function
100%
100%
Transaction context manager
Context manager used
100%
100%
Rollback on exception
100%
100%
Commit on success
100%
100%
WAL mode enabled
100%
100%
Exception re-raised
0%
100%
row_factory set
0%
100%
summary.txt produced
100%
100%
Query optimization with indexes
Index on category
100%
100%
Index on location_code
100%
100%
WAL mode switched
100%
100%
Query plan utility function
100%
100%
EXPLAIN QUERY PLAN in report
100%
100%
Before/after comparison
100%
100%
row_factory set
0%
100%
check_same_thread disabled
0%
100%
Foreign keys enabled
100%
100%
f772de4
Table of Contents
If you maintain this skill, you can claim it as your own. Once claimed, you can manage eval scenarios, bundle related skills, attach documentation or rules, and ensure cross-agent compatibility.