CtrlK
BlogDocsLog inGet started
Tessl Logo

postgresql-best-practices-cloudbase

CloudBase PostgreSQL access-pattern and slow-query quality guidance. Use when designing how tables are read and written, eliminating per-row database calls, adding indexes for filters or joins, reviewing high-traffic data access, or explaining a slow SQL query. Not for first-time PG SDK setup, login UI, or NoSQL collections.

74

Quality

92%

Does it follow best practices?

Run evals on this skill

Adds up to 20 points to the overall score

View guide

SecuritybySnyk

Passed

No findings from the security scan

SKILL.md
Quality
Evals
Security

Quality

Content

92%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 well-structured, token-efficient skill body with explicit completion checkpoints and clean one-level reference routing. The only gap is a couple of described-but-unshown code patterns (index DDL, keyset pagination).

DimensionReasoningScore

Conciseness

Lean body that assumes Claude's competence — no padding about what PostgreSQL/indexes/RLS are — and every section (workflow, routing, self-check) earns its tokens.

5 / 5

Actionability

Provides copy-paste-ready SQL policy, TS batching code, and a concrete `queryEnv(action="info", envId=...)` command, but leaves index DDL and keyset pagination as described-not-shown minor gaps.

4 / 5

Workflow Clarity

Four numbered steps each ending in an explicit "Complete when:" checkpoint, plus a minimum self-check checklist — clear sequencing with validation gates for a database-access review.

5 / 5

Progressive Disclosure

Overview body routes to four real one-level-deep reference files (access-patterns.md, indexes-and-explain.md, schema-and-rls.md, capacity-and-connections.md, all present in references/) via a clear branch table with a "load only required" instruction.

5 / 5

Total

19

/

20

Passed

Description

92%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.

A highly specific, well-scoped description that answers what and when concretely while carving out clear boundaries against sibling skills. Minor synonym coverage gaps in trigger terms keep it just short of perfect.

DimensionReasoningScore

Specificity

Lists multiple concrete actions — "designing how tables are read and written, eliminating per-row database calls, adding indexes for filters or joins, reviewing high-traffic data access, or explaining a slow SQL query" — giving comprehensive coverage of the skill's capabilities.

5 / 5

Completeness

Explicitly answers both what ("CloudBase PostgreSQL access-pattern and slow-query quality guidance") and when ("Use when designing...") with concrete trigger phrases, plus a "Not for" exclusion clause.

5 / 5

Trigger Term Quality

Strong natural phrases ("slow SQL query", "adding indexes for filters or joins", "per-row database calls") that users would say, but misses common synonyms like "N+1", "query plan", or "EXPLAIN".

4 / 5

Distinctiveness Conflict Risk

Clear CloudBase PG access-design niche with distinct triggers and an explicit "Not for first-time PG SDK setup, login UI, or NoSQL collections" boundary, minimizing overlap with sibling skills.

5 / 5

Total

19

/

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.

Validation15 / 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
TencentCloudBase/CloudBase-AI-Toolkit
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.