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.

1.13x

Quality

73%

Does it follow best practices?

Impact

100%

1.13x

Average score across 3 eval scenarios

Securityby

Passed

No findings from the security scan

Fix and improve this skill with Tessl

tessl review fix ./data/skills-md/0xdarkmatter/claude-mods/sqlite-ops/SKILL.md

Quality

Content

77%Weight 40%Scale 1-5

Reviews the quality of instructions and guidance provided to agents. Good implementation is clear, handles edge cases, and produces reliable results.

The content is exceptionally lean and actionable, with executable code and useful reference tables. Its weaknesses are the absence of validation/feedback loops for destructive or batch database operations (capping workflow clarity) and references to files that are not present in the bundle.

Suggestions

Add a validate/verify checkpoint for destructive or batch operations (e.g., run PRAGMA integrity_check or EXPLAIN QUERY PLAN before/after schema changes and migrations) to establish a feedback loop.

Include a short sequenced workflow for the multi-step processes (e.g., migration: check current user_version -> apply -> update version -> verify) rather than only disconnected topic sections.

Create the referenced ./references/*.md files (schema-patterns.md, async-patterns.md, migration-patterns.md) or remove the references, since the listed paths do not exist in the bundle.

Dimension	Reasoning	Score
Conciseness	Lean body of code blocks and reference tables with no padding or explanation of concepts Claude already knows; comments are minimal and purposeful ('# Dict-like access', '# Better concurrency'), and every section earns its place.	5 / 5
Actionability	Provides copy-paste-ready executable code for connection setup, transaction context manager, and WAL mode, plus a concrete CLI quick-reference block and a gotchas table with specific fixes (PRAGMA statements, EXPLAIN QUERY PLAN).	5 / 5
Workflow Clarity	Although well-organized by topic, there is no sequenced multi-step workflow and, critically for a database skill (a context the scoring notes flag for feedback loops), operations like migrations/schema changes and batch writes have no validate/verify checkpoints; the destructive/batch cap of 3 applies.	3 / 5
Progressive Disclosure	Body is a concise overview with clearly signaled one-level-deep references ('./references/schema-patterns.md', 'async-patterns.md', 'migration-patterns.md') each with a one-line description, but the referenced files do not exist in the bundle, so navigation is not fully verifiable; good structure with a minor gap, matching anchor 4.	4 / 5
	Total	17 / 20 Passed

Description

70%Weight 40%Scale 1-5

Based on the skill's description, can an agent find and select it at the right time? Clear, specific descriptions lead to better discovery.

The description clearly communicates a distinct SQLite-in-Python niche with strong trigger terms and explicit trigger guidance. Its main weakness is specificity: capabilities are stated as broad categories rather than enumerated concrete actions.

Dimension	Reasoning	Score
Specificity	Names the domain (SQLite databases) and concrete capability areas ('state management, caching, and async operations') but these are categories rather than multiple concrete actions like 'extract', 'fill', 'merge'; falls between naming domain+1-2 actions (3) and listing several specific actions (4).	3 / 5
Completeness	Has a clear 'what' ('Patterns for SQLite databases in Python projects - state management, caching, and async operations') and an explicit 'when' clause ('Triggers on: ...'); the 'when' is a trigger list rather than a 'Use when...' phrase, so slightly below the explicit-both-with-concrete-triggers anchor of 5.	4 / 5
Trigger Term Quality	Includes natural library names users would say ('sqlite', 'sqlite3', 'aiosqlite') plus natural phrases ('local database', 'database schema', 'migration', 'wal mode'); good coverage but missing some synonyms/extensions, so between anchor 3 and 5, closer to 4.	4 / 5
Distinctiveness Conflict Risk	Targets a clear niche (SQLite in Python) with library-specific triggers ('sqlite3', 'aiosqlite', 'wal mode') that are unlikely to fire for unrelated skills, matching the clear-niche-minimal-conflict anchor.	5 / 5
	Total	16 / 20 Passed

Validation

100%

Warnings & errors only

Checks the skill against the spec for correct structure and formatting. All validation checks must pass before discovery and implementation can be scored.

Validation — 16 / 16 Passed

Validation for skill structure

No warnings or errors.

Repository: NeverSight/skills_feed
Path: data/skills-md/0xdarkmatter/claude-mods/sqlite-ops/SKILL.md
Commit: 2f57aec

Reviewed: about 22 hours ago

Table of Contents

Discovery Implementation Validation

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.