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.
90
Does it follow best practices?
If you maintain this skill, you can automatically optimize it using the tessl CLI to improve its score:
npx tessl skill review --optimize ./path/to/skillValidation for skill structure
Evaluation results
100%
Local Settings Store for a CLI Tool
SQLite 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%
Without context: $0.2148 · 50s · 12 turns · 15 in / 2,996 out tokens
With context: $0.4127 · 1m 15s · 25 turns · 29 in / 4,746 out tokens
100%
20%Order Import Pipeline
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%
Without context: $0.3358 · 1m 4s · 22 turns · 28 in / 3,898 out tokens
With context: $0.4116 · 1m 17s · 25 turns · 276 in / 4,533 out tokens
100%
15%Slow Inventory Search Investigation
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%
Without context: $0.3469 · 1m 38s · 19 turns · 26 in / 5,980 out tokens
With context: $0.5176 · 1m 54s · 25 turns · 30 in / 7,100 out tokens
- Evaluated
- Agent
- Claude Code
Table of Contents
Is this your skill?
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.