CtrlK
BlogDocsLog inGet started
Tessl Logo

tessl-labs/sqlite-go-best-practices

SQLite best practices for Go — WAL mode, foreign_keys, busy_timeout, SetMaxOpenConns, context-aware queries, transactions, migrations

98

2.36x
Quality

99%

Does it follow best practices?

Impact

97%

2.36x

Average score across 5 eval scenarios

SecuritybySnyk

Passed

No known issues

Overview
Quality
Evals
Security
Files

Quality

Discovery

100%

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 strong, well-crafted skill description that excels across all dimensions. It provides comprehensive technical specificity with concrete patterns and configurations, uses natural developer terminology, clearly states both what it does and when to apply it, and occupies a distinct niche (Go + SQLite best practices) that minimizes conflict risk with other skills.

DimensionReasoningScore

Specificity

Lists multiple specific concrete actions and configurations: WAL mode, foreign_keys, busy_timeout, pool settings (SetMaxOpenConns), modernc.org/sqlite, context-aware queries, transactions, migration patterns, prepared statements, and Scanner interface.

3 / 3

Completeness

Clearly answers both what (covers connection setup, WAL mode, pool settings, etc.) AND when ('must be applied by default in every Go application using database/sql with SQLite', 'Always apply these patterns when creating or modifying any Go application that uses SQLite').

3 / 3

Trigger Term Quality

Excellent coverage of natural terms users would say: 'Go', 'SQLite', 'database/sql', 'WAL mode', 'foreign_keys', 'transactions', 'migrations', 'prepared statements' - all terms developers naturally use when working with Go and SQLite.

3 / 3

Distinctiveness Conflict Risk

Very specific niche combining Go + SQLite + database/sql with explicit library reference (modernc.org/sqlite). Unlikely to conflict with general database skills, other language skills, or even other Go database skills due to SQLite-specific focus.

3 / 3

Total

12

/

12

Passed

Implementation

100%

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

This is an exemplary skill document that provides comprehensive, production-ready SQLite patterns for Go. It excels at being both thorough and concise, with every code example being executable and every explanation earning its place. The document successfully balances being a complete reference while remaining scannable through good use of tables, code blocks, and a final checklist.

DimensionReasoningScore

Conciseness

The content is dense with actionable information and avoids explaining concepts Claude already knows. Every section provides specific, necessary details without padding or unnecessary context about what SQLite or Go are.

3 / 3

Actionability

Provides fully executable, copy-paste ready code examples throughout. The connection setup, migrations, queries, and transactions are all complete, working code with proper imports and error handling.

3 / 3

Workflow Clarity

Multi-step processes like migrations are clearly sequenced with transactions for rollback safety. The checklist at the end provides explicit validation steps, and the migration pattern includes proper error recovery with defer tx.Rollback().

3 / 3

Progressive Disclosure

Well-organized with clear sections progressing from driver choice to connection setup to advanced patterns. References section points to external documentation for deeper dives. The checklist serves as a quick reference without requiring navigation to other files.

3 / 3

Total

12

/

12

Passed

Validation

90%

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

Validation10 / 11 Passed

Validation for skill structure

CriteriaDescriptionResult

frontmatter_unknown_keys

Unknown frontmatter key(s) found; consider removing or moving to metadata

Warning

Total

10

/

11

Passed

Reviewed

Table of Contents