CtrlK
BlogDocsLog inGet started
Tessl Logo

tessl-labs/sqlalchemy-best-practices

SQLAlchemy patterns — engine setup, session management, declarative models,

98

1.96x
Quality

99%

Does it follow best practices?

Impact

98%

1.96x

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 an excellent skill description that follows best practices. It uses third person voice, lists comprehensive specific capabilities, includes a clear 'Use when...' clause with multiple trigger scenarios, and is distinctly focused on SQLAlchemy patterns. The description provides enough detail for Claude to confidently select this skill when users need SQLAlchemy-related help.

DimensionReasoningScore

Specificity

Lists multiple specific concrete actions: 'engine setup, session management, declarative models, relationships, eager loading, raw SQL safety, async patterns, bulk operations, and Alembic migrations' - these are all concrete, specific SQLAlchemy capabilities.

3 / 3

Completeness

Clearly answers both what (SQLAlchemy patterns with specific capabilities listed) AND when ('Use when building or reviewing Python apps with SQLAlchemy, when setting up a new database layer, or when debugging session, connection, or performance issues').

3 / 3

Trigger Term Quality

Includes natural keywords users would say: 'SQLAlchemy', 'database layer', 'session', 'connection', 'performance issues', 'Alembic migrations', 'Python apps'. These cover common terms developers use when working with SQLAlchemy.

3 / 3

Distinctiveness Conflict Risk

Clear niche focused specifically on SQLAlchemy ORM patterns in Python. The specific mention of SQLAlchemy, Alembic, and Python database layer makes it unlikely to conflict with generic database skills or other ORM skills.

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 demonstrates best practices for technical documentation. It efficiently covers SQLAlchemy 2.0 patterns using the effective WRONG/RIGHT comparison format, provides fully executable code examples with proper imports, and includes a comprehensive checklist for verification. The content respects Claude's intelligence while providing specific, actionable guidance for production use cases.

DimensionReasoningScore

Conciseness

The content is highly efficient, using WRONG vs RIGHT code comparisons that immediately show the pattern without explaining what SQLAlchemy is or how ORMs work. Every section delivers actionable information without padding.

3 / 3

Actionability

All code examples are fully executable and copy-paste ready with proper imports. The WRONG/RIGHT format provides concrete, specific guidance with real-world patterns like connection pooling parameters, eager loading strategies, and bulk operations.

3 / 3

Workflow Clarity

Multi-step processes like Alembic migrations and transaction patterns include clear sequences with validation steps. The error handling section explicitly shows the rollback requirement, and the checklist provides a comprehensive verification workflow.

3 / 3

Progressive Disclosure

Content is well-organized with numbered sections ordered by impact. External references are clearly listed at the end with direct links to official documentation. The checklist at the end 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