CtrlK
BlogDocsLog inGet started
Tessl Logo

tessl-labs/postgresql-python-best-practices

PostgreSQL patterns for Python with psycopg and asyncpg — connection pooling,

99

1.15x
Quality

99%

Does it follow best practices?

Impact

99%

1.15x

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 hits all the marks. It provides specific concrete capabilities, uses natural developer terminology, explicitly states both what it does and when to use it, and carves out a distinct niche by specifying the exact libraries and excluding ORMs. The description is comprehensive yet concise.

DimensionReasoningScore

Specificity

Lists multiple specific concrete actions: connection pooling, parameterized queries, transactions, bulk inserts, async context managers, server-side cursors, SSL config, and connection cleanup. These are precise, actionable capabilities.

3 / 3

Completeness

Clearly answers both what (PostgreSQL patterns with specific techniques) AND when ('Always apply when building or reviewing Python apps with PostgreSQL using raw database drivers, or when debugging connection pool or query issues'). Explicit trigger guidance is present.

3 / 3

Trigger Term Quality

Excellent coverage of natural terms users would say: 'PostgreSQL', 'Python', 'psycopg 3', 'asyncpg', 'connection pool', 'query', 'transactions', 'bulk inserts', 'SSL', 'raw database drivers'. These match how developers naturally describe their needs.

3 / 3

Distinctiveness Conflict Risk

Highly distinctive with clear niche: specifically targets PostgreSQL with Python using raw drivers (psycopg 3, asyncpg), explicitly excludes ORMs. The combination of specific libraries and 'not an ORM' clause creates a clear, non-conflicting scope.

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 file that demonstrates best practices across all dimensions. The WRONG vs RIGHT pattern is highly effective for teaching correct patterns while explicitly showing anti-patterns. The content is comprehensive yet concise, covering connection pooling, parameterized queries, transactions, bulk operations, and production configuration with executable code throughout.

DimensionReasoningScore

Conciseness

The skill is highly efficient with no unnecessary explanations of basic concepts. Every section provides direct WRONG vs RIGHT comparisons with executable code, and the content assumes Claude understands Python and PostgreSQL fundamentals.

3 / 3

Actionability

All code examples are fully executable and copy-paste ready. The skill provides complete, working code for both psycopg 3 and asyncpg with proper imports, configuration values, and realistic usage patterns.

3 / 3

Workflow Clarity

Multi-step processes like transactions and bulk inserts are clearly sequenced. The final checklist provides explicit validation steps, and the WRONG vs RIGHT pattern throughout creates clear feedback loops for error prevention.

3 / 3

Progressive Disclosure

Content is well-organized into numbered sections covering distinct topics. The skill references external verifiers for validation and keeps each section focused. The checklist at the end provides a clear summary 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