PostgreSQL patterns for Python with psycopg and asyncpg — connection pooling,
99
99%
Does it follow best practices?
Impact
99%
1.15xAverage score across 5 eval scenarios
Passed
No known issues
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.
| Dimension | Reasoning | Score |
|---|---|---|
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.
| Dimension | Reasoning | Score |
|---|---|---|
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.
Validation — 10 / 11 Passed
Validation for skill structure
| Criteria | Description | Result |
|---|---|---|
frontmatter_unknown_keys | Unknown frontmatter key(s) found; consider removing or moving to metadata | Warning |
Total | 10 / 11 Passed | |
Reviewed
Table of Contents