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
Discovery
89%Based on the skill's description, can an agent find and select it at the right time? Clear, specific descriptions lead to better discovery.
This is a well-structured skill description with excellent trigger term coverage and clear distinctiveness. The explicit 'Triggers on:' clause effectively communicates when to use this skill. The main weakness is that the capability descriptions are somewhat abstract (state management, caching, async operations) rather than listing concrete actions the skill enables.
Suggestions
Replace abstract categories with specific concrete actions, e.g., 'Create database schemas, run migrations, configure WAL mode, implement connection pooling, handle async queries with aiosqlite'
| Dimension | Reasoning | Score |
|---|---|---|
Specificity | Names the domain (SQLite databases in Python) and mentions some actions (state management, caching, async operations), but these are high-level categories rather than concrete specific actions like 'create tables', 'run migrations', or 'configure connection pooling'. | 2 / 3 |
Completeness | Clearly answers both what (patterns for SQLite databases - state management, caching, async operations) and when (explicit 'Triggers on:' clause with specific keywords), providing explicit trigger guidance. | 3 / 3 |
Trigger Term Quality | Excellent coverage of natural trigger terms including 'sqlite', 'sqlite3', 'aiosqlite', 'local database', 'database schema', 'migration', 'wal mode' - these are terms users would naturally use when working with SQLite in Python projects. | 3 / 3 |
Distinctiveness Conflict Risk | Highly distinctive with clear niche - specifically targets SQLite in Python with unique triggers like 'aiosqlite', 'wal mode', and 'sqlite3' that wouldn't conflict with general database skills or other language-specific database skills. | 3 / 3 |
Total | 11 / 12 Passed |
Implementation
87%Reviews the quality of instructions and guidance provided to agents. Good implementation is clear, handles edge cases, and produces reliable results.
This is a well-crafted skill that efficiently covers SQLite patterns with executable code and clear organization. The progressive disclosure is excellent, keeping the main file focused while pointing to detailed references. The only weakness is the lack of explicit validation workflows for potentially risky operations like migrations.
Suggestions
Add a brief workflow section showing the validate-fix-retry pattern for schema migrations (e.g., backup -> migrate -> verify -> rollback on failure)
| Dimension | Reasoning | Score |
|---|---|---|
Conciseness | The content is lean and efficient, providing only essential information without explaining basic concepts Claude already knows. Every section delivers actionable value with minimal verbosity. | 3 / 3 |
Actionability | All code examples are complete and executable, including the connection pattern, context manager, and CLI commands. The tables provide specific, actionable solutions to common problems. | 3 / 3 |
Workflow Clarity | While individual patterns are clear, there's no explicit workflow for database operations that involve multiple steps. Missing validation checkpoints for schema changes or migrations, which are referenced but not shown inline. | 2 / 3 |
Progressive Disclosure | Excellent structure with a concise overview and clear one-level-deep references to detailed patterns (schema, async, migration). The main file stays focused while signaling where to find advanced content. | 3 / 3 |
Total | 11 / 12 Passed |
Validation
100%Checks the skill against the spec for correct structure and formatting. All validation checks must pass before discovery and implementation can be scored.
Validation — 11 / 11 Passed
Validation for skill structure
No warnings or errors.
- Reviewed
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.