Content
83%Weight 40%Scale 1-5Reviews 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.
| Dimension | Reasoning | Score |
|---|---|---|
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 |