CtrlK
BlogDocsLog inGet started
Tessl Logo

postgres-patterns

PostgreSQL database patterns for query optimization, schema design, indexing, and security. Based on Supabase best practices.

79

1.12x
Quality

Does it follow best practices?

Impact

96%

1.12x

Average score across 3 eval scenarios

SecuritybySnyk

Passed

No known issues

SKILL.md
Quality
Evals
Security

Quality

Content

80%

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

The body is a lean, highly actionable Postgres reference packed with executable SQL, but it functions as a flat cheat-sheet rather than a multi-step workflow with validation checkpoints. Progressive disclosure is limited by the absence of split-out reference files for the denser sections.

Suggestions

For the config-template section, add explicit validation such as running 'SELECT pg_reload_conf()' after ALTER SYSTEM and verifying settings took effect before proceeding.

Split the anti-pattern detection and detailed index guidance into one-level-deep reference files (e.g. references/anti-patterns.md) referenced from the body.

Add a short validation step to the queue-processing and migration patterns so destructive/batch operations have an explicit checkpoint.

DimensionReasoningScore

Conciseness

Lean reference content with no concept explanation; every table and code block is directly actionable, assuming Claude's knowledge of Postgres.

3 / 3

Actionability

Provides fully executable SQL across index creation, UPSERT, cursor pagination, SKIP LOCKED queues, and anti-pattern detection queries — copy-paste ready with concrete examples.

3 / 3

Workflow Clarity

Content is a pattern reference rather than a multi-step workflow; for the config-template and anti-pattern sections that touch batch/destructive operations there are no validate-then-apply checkpoints, capping clarity at 2.

2 / 3

Progressive Disclosure

Well-organized into cheat-sheet sections but it is a single monolithic file with no split-out references; the '関連' links point to sibling skills rather than one-level-deep detail files.

2 / 3

Total

10

/

12

Passed

Description

60%

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 states concrete capabilities in third person but omits any 'Use when...' trigger clause, leaving the 'when to use' only implied. Trigger terms cover the technical domain well but lack the natural phrasings users would say.

Suggestions

Add an explicit 'Use when...' clause listing natural triggers (e.g. 'Use when optimizing slow queries, designing schemas, writing migrations, or setting up RLS').

Include user-natural phrasings like 'slow query', 'database migration', and 'SQL performance' alongside the technical terms.

Sharpen distinctiveness by leading with the Postgres-specific framing rather than the generic 'database patterns'.

DimensionReasoningScore

Specificity

Lists multiple concrete actions — 'query optimization, schema design, indexing, and security' — naming specific capability domains rather than vague language.

3 / 3

Completeness

Clearly answers 'what' but has no 'Use when...' clause or explicit trigger guidance, so the 'when' is only implied — capping completeness at 2 per the rubric.

2 / 3

Trigger Term Quality

Includes relevant domain terms ('query optimization', 'indexing', 'RLS') but omits natural phrasings a user would say such as 'slow query', 'database migration', or 'SQL performance'.

2 / 3

Distinctiveness Conflict Risk

The Postgres niche is reasonably distinct but the generic 'database patterns' framing could overlap with other database skills (e.g. the referenced clickhouse-io or backend-patterns).

2 / 3

Total

9

/

12

Passed

Validation

93%

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

Validation15 / 16 Passed

Validation for skill structure

CriteriaDescriptionResult

relative_links

Relative link issues: 1 missing

Warning

Total

15

/

16

Passed

Repository
affaan-m/everything-claude-code
Reviewed

Table of Contents

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.