CtrlK
BlogDocsLog inGet started
Tessl Logo
SkillPublic

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.

Quality

90%

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

85%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-engineered skill body: a gated four-step workflow with explicit completion criteria, a self-check checklist, and clean one-level-deep routing to real reference files. The remaining polish is trimming a couple of rationale clauses and showing the named keyset-pagination/limit patterns concretely.

Suggestions

Add a short keyset-pagination RPC example (or a `.limit()` / `.range()` bounded-query snippet) in step 3, since these patterns are named but never shown.

Trim rationale clauses such as "This keeps Git, development, and production reproducible; the tradeoff is that experiments require a new migration version" to just the behavioral rule (use the versioned applyMigration workflow, no ad hoc schema mutation).

DimensionReasoningScore

Conciseness

The body is lean: no explanations of concepts Claude already knows, tight workflow steps, and compact code examples. A few rationale clauses could be trimmed, e.g., "This keeps Git, development, and production reproducible; the tradeoff is that experiments require a new migration version" and the two-sentence intro, which fits 'efficient; minor instances of over-explanation that could be trimmed' rather than the every-token-earns-its-place anchor at 5.

4 / 5

Actionability

Mostly executable guidance: a complete CREATE POLICY example, an idiomatic batched-read TypeScript snippet with error handling ("if (error) throw error"), and a concrete API call (`queryEnv(action="info", envId=...)`). Minor gaps keep it below 5: keyset pagination is named ("an RPC that implements keyset pagination") without an example, and `.limit()` / `.range()` bounding is described but not shown.

4 / 5

Workflow Clarity

The four-step workflow has explicit validation gates ("**Complete when:**" after every step), error/escalation paths ("marked as an assumption for the user", "raised to the user as an unresolved launch blocker"), and a closing "Minimum self-check" checklist. This matches the anchor for clear sequence with explicit validation steps and checklists; validation is present, so the database-operations cap does not apply. Not score 4 because checkpoints are explicit and comprehensive rather than minor-gapped.

5 / 5

Progressive Disclosure

The Routing table maps each work branch to one of four real, one-level-deep reference files (access-patterns.md, indexes-and-explain.md, schema-and-rls.md, capacity-and-connections.md), all verified present in the bundle and matching their routing descriptions, with the explicit instruction "Load only the references required by the current branch." Clear overview with well-signaled references and easy navigation — the top anchor.

5 / 5

Total

18

/

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 strong description: it states a concrete capability set, gives explicit 'Use when' triggers, and draws sharp boundaries against sibling skills. The only gap is a few natural trigger synonyms (e.g., N+1 queries, query performance, database readiness) that users might phrase differently.

DimensionReasoningScore

Specificity

Names the domain ("CloudBase PostgreSQL access-pattern and slow-query quality guidance") and 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", and "explaining a slow SQL query". This matches the anchor for multiple specific concrete actions with comprehensive coverage; there is no vague filler to push it down.

5 / 5

Completeness

Explicitly answers 'what' ("CloudBase PostgreSQL access-pattern and slow-query quality guidance") and 'when' with concrete trigger phrases ("Use when designing how tables are read and written, eliminating per-row database calls, adding indexes..."). It also adds an explicit exclusion clause ("Not for first-time PG SDK setup, login UI, or NoSQL collections"), matching the top anchor; not score 4 because the 'when' guidance is already fully explicit with concrete triggers.

5 / 5

Trigger Term Quality

Good natural keyword coverage: "slow SQL query", "adding indexes", "per-row database calls", "high-traffic data access" are phrases users would plausibly say. A few natural terms are missing, such as "N+1", "query performance/optimization", or "database readiness", so it fits the 'good coverage, a few natural terms missing' anchor rather than the comprehensive-synonym anchor at 5.

4 / 5

Distinctiveness Conflict Risk

Clear niche (CloudBase PG access patterns and slow queries) with distinct triggers and explicit de-scoping of adjacent concerns ("Not for first-time PG SDK setup, login UI, or NoSQL collections"). Minimal conflict risk with other skills; not score 4 because no meaningful overlap risk remains unaddressed.

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.

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

TencentCloudBase/CloudBase-AI-Toolkit

Path

config/source/skills/postgresql-best-practices-cloudbase/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.