CtrlK
BlogDocsLog inGet started
Tessl Logo
SkillPublic

database-management-patterns

Comprehensive guide for database management patterns covering PostgreSQL and MongoDB including schema design, indexing, transactions, replication, and performance tuning

Quality

66%

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

Fix and improve this skill with Tessl

tessl review fix ./plugins/luxor-database-pro/skills/database-management-patterns/SKILL.md
SKILL.md
Quality
Evals
Security

Quality

Content

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

The skill is exceptionally strong on actionability with abundant executable SQL/JS covering realistic cases, but it is a monolithic encyclopedia that spends thousands of tokens teaching fundamentals Claude already knows and that should be split across reference files. Adding a lean overview with progressive disclosure and trimming known-concept explanations would dramatically improve token efficiency without losing usefulness.

Suggestions

Split the body into reference files (e.g. postgresql-patterns.md, mongodb-patterns.md, indexing.md, replication-sharding.md, troubleshooting.md) and keep SKILL.md as a concise overview with clearly signaled one-level-deep links.

Delete sections explaining concepts Claude already knows — ACID properties, CAP theorem, normal forms, 'avoid SELECT *', and the N+1 basics — or reduce them to one-line pointers.

For database operations, add explicit validation checkpoints (e.g. run EXPLAIN / verify index usage before and after applying an index, test transactions with rollback before committing to production changes) to create validate-fix-retry feedback loops.

DimensionReasoningScore

Conciseness

The ~1900-line body extensively explains concepts Claude already knows — 'Atomicity: All operations in a transaction succeed or fail together', CAP theorem, 1NF/2NF/3NF normal forms, and 'Avoid SELECT *' basics — and is noticeably verbose overall, though substantial portions are concrete code rather than pure padding.

2 / 5

Actionability

Guidance is fully executable and copy-paste ready throughout: complete CREATE TABLE/INDEX statements, full trigger functions, sharding setup steps, aggregation pipelines, and troubleshooting queries with specific commands covering the common cases.

5 / 5

Workflow Clarity

The body is organized as a topical reference with no sequenced workflow or validate-then-proceed checkpoints; for a database-operations skill the scoring notes require capping workflow clarity at 3 when feedback loops (validate, fix, retry) are absent, and the troubleshooting section lists diagnostics but no validation loop.

3 / 5

Progressive Disclosure

No bundle files exist and the entire ~1900-line reference is inlined monolithically in SKILL.md — PostgreSQL patterns, MongoDB patterns, indexing, troubleshooting, and resource lists each clearly belong in separate reference files — leaving only section headers as structure.

2 / 5

Total

12

/

20

Passed

Description

66%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 has a clear, specific 'what' with good domain keywords for PostgreSQL and MongoDB, but lacks any 'use when' trigger guidance, which both caps completeness and weakens its ability to fire reliably. It is reasonably distinctive but would benefit from natural trigger phrases and synonyms like 'SQL/NoSQL', 'sharding', and 'query optimization'.

Suggestions

Add an explicit trigger clause, e.g. 'Use when designing database schemas, writing or optimizing SQL/NoSQL queries, configuring replication or sharding, or troubleshooting database performance.'

Include natural user synonyms and variations such as 'Postgres', 'SQL', 'NoSQL', 'sharding', and 'query optimization' to improve trigger term coverage.

Reframe topic nouns as concrete actions (e.g. 'designs schemas, creates and analyzes indexes, configures replication and sharding') to sharpen the 'what'.

DimensionReasoningScore

Specificity

The description names the domain (PostgreSQL and MongoDB) and lists several concrete coverage areas — "schema design, indexing, transactions, replication, and performance tuning" — but frames them as topics a guide 'covering' rather than as concrete action verbs, leaving minor gaps versus anchor 5.

4 / 5

Completeness

It clearly answers 'what' (comprehensive guide covering schema design, indexing, transactions, replication, performance tuning) but contains no 'Use when...' clause or equivalent explicit trigger guidance, which per the judging guidelines caps completeness at 3.

3 / 5

Trigger Term Quality

Natural keywords like "database", "PostgreSQL", "MongoDB", "indexing", "schema design", "transactions", and "replication" are present and would be said by users, but common variations such as 'SQL', 'NoSQL', 'sharding', 'query optimization', and the informal 'Postgres' are missing.

4 / 5

Distinctiveness Conflict Risk

The niche is fairly distinct — two named databases with specific topics — but it could overlap with generic SQL/Postgres-only or database-design skills, giving minor conflict risk rather than a clear unique niche.

4 / 5

Total

15

/

20

Passed

Validation

87%

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

Validation — 14 / 16 Passed

Validation for skill structure

CriteriaDescriptionResult

skill_md_line_count

SKILL.md is long (1924 lines); consider splitting into references/ and linking

Warning

frontmatter_unknown_keys

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

Warning

Total

14

/

16

Passed

Repository

manutej/luxor-claude-marketplace

Path

plugins/luxor-database-pro/skills/database-management-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.