CtrlK
BlogDocsLog inGet started
Tessl Logo
SkillPublic

postgres-patterns

用于查询优化、模式设计、索引和安全性的PostgreSQL数据库模式。基于Supabase最佳实践。

1.26x
Quality

76%

Does it follow best practices?

Impact

91%

1.26x

Average score across 3 eval scenarios

SecuritybySnyk

Passed

No findings from the security scan

Fix and improve this skill with Tessl

tessl review fix ./docs/zh-CN/skills/postgres-patterns/SKILL.md
SKILL.md
Quality
Evals
Security

Quality

Content

83%Weight 40%Scale 1-5

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

A lean, highly actionable quick reference whose SQL examples are copy-paste ready and cover the common PostgreSQL cases. Its main weaknesses are the absence of validation/rollback guidance around the risky ALTER SYSTEM and REVOKE config changes, and the lack of any progressive-disclosure structure for the longer query/config sections.

DimensionReasoningScore

Conciseness

The body is almost entirely tables and executable SQL with terse one-line comments ("Wrap in SELECT!", "O(1) vs OFFSET which is O(n)") and zero padding or explanation of concepts Claude already knows. A minor blemish is the malformed heading "反模式检测\*\*", but it does not add unnecessary tokens, so this does not drop it from the lean-and-efficient anchor.

5 / 5

Actionability

Fully executable copy-paste SQL covering the common cases: index DDL, RLS policy, UPSERT with ON CONFLICT, cursor pagination, a FOR UPDATE SKIP LOCKED queue query, and diagnostic queries against pg_stat_statements. Not 4 because the examples are concrete and complete rather than having minor gaps; the generic t (col) placeholders in the cheat table are a reasonable reference-table idiom.

5 / 5

Workflow Clarity

As a reference skill it has a clear '何时激活' section and delegates the full workflow to the database-reviewer agent, but there are no multi-step sequences with validation checkpoints. The 配置模板 section applies risky system-wide changes (ALTER SYSTEM SET max_connections = 100, REVOKE ALL ON SCHEMA public FROM public) with no verification or rollback guidance, and the rubric caps this dimension at 3 for database operations missing feedback loops.

3 / 5

Progressive Disclosure

Well-organized single-file quick reference (~150 lines) with clear sections and a '相关' pointer to sibling skills, but no reference files exist at all, and the anti-pattern queries and config templates are content that could live in references/. Anchor 4 (good structure, minor organization gaps) rather than 5 because the under-50-line simple-skill exception does not apply and the file is larger than a pure overview.

4 / 5

Total

17

/

20

Passed

Description

58%Weight 40%Scale 1-5

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 clearly states what the skill covers at a domain level, but it lacks any 'use when' trigger guidance, which caps both completeness and trigger-term quality. Adding natural user phrases (e.g. slow queries, migrations, RLS) and an explicit activation clause would bring it in line with the strong reference examples.

Suggestions

Add an explicit 'Use when...' clause, e.g. 'Use when writing SQL queries or migrations, designing schemas, troubleshooting slow queries, or implementing row-level security.'

Include natural trigger terms users would say — 'SQL', 'Postgres', 'slow query', 'migration', 'RLS', 'index' — and common synonyms rather than only topic labels.

Drop or condense '基于Supabase最佳实践' provenance in the description (it already appears in the body attribution) to free room for trigger phrases.

DimensionReasoningScore

Specificity

Names the domain ("PostgreSQL") plus four concrete capability areas — "查询优化" (query optimization), "模式设计" (schema design), "索引" (indexing), "安全性" (security) — matching the anchor for several specific actions with minor gaps. Not 5 because these are topic areas rather than multiple concrete actions, and "基于Supabase最佳实践" is provenance, not a capability; not 3 because four areas exceed the 1-2 actions of that anchor.

4 / 5

Completeness

The 'what' is clear (PostgreSQL patterns for query optimization, schema design, indexing, security), but the 'when' is entirely absent with no equivalent trigger guidance, which caps completeness at 3 per the judging guidelines. Not 4 because nothing even weakly implies when to activate the skill.

3 / 5

Trigger Term Quality

Contains some relevant keywords ("PostgreSQL", "查询优化", "索引", "模式设计") but no 'use when' phrasing and no natural user phrases or synonyms such as "slow query", "migration", "RLS", "连接池", matching the anchor for some relevant keywords with missing variations. Not 4 because the common natural terms a user would actually say are largely absent.

3 / 5

Distinctiveness Conflict Risk

A clearly PostgreSQL-specific niche ("PostgreSQL数据库模式") with only minor overlap risk against closely related skills like the referenced clickhouse-io or database-reviewer. Not 5 because generic terms like "安全性" (security) could brush adjacent skills, and with no trigger clause there is little to disambiguate.

4 / 5

Total

14

/

20

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.

Validation — 15 / 16 Passed

Validation for skill structure

CriteriaDescriptionResult

frontmatter_unknown_keys

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

Warning

Total

15

/

16

Passed

Repository

affaan-m/ECC

Path

docs/zh-CN/skills/postgres-patterns/SKILL.md

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.