CtrlK
BlogDocsLog inGet started
Tessl Logo
SkillPublic

database-management

Design, optimize, migrate, and maintain relational and hybrid database systems across PostgreSQL, MySQL, MariaDB, and SQLite. Covers schema design, normalization and denormalization, indexing strategies, transactions (ACID), migration management, ORM integration (Prisma, Drizzle, Eloquent, SQLAlchemy), security, backups, connection pooling, and engine-specific optimizations.

57

Quality

72%

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 ./skills/development-skills/database-management/SKILL.md
SKILL.md
Quality
Evals
Security

Quality

Content

57%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 dense, highly actionable database reference with excellent executable examples, but it functions as a textbook-style monograph rather than a lean skill: it re-teaches concepts Claude already knows, inlines deep-dive content that belongs in reference files alongside the existing query-optimization.md, and lacks validation feedback loops for risky operations. The strongest dimension is actionability; the weakest is conciseness.

Suggestions

Move the deep-dive sections that mirror the existing reference's depth — engine-specific tuning configs (postgresql.conf, my.cnf, PRAGMAs), ORM integration examples, and security/backup operations — into additional files under references/, keeping SKILL.md as a lean overview with clearly signaled one-level links like the existing 'Deep Dive Reference' section.

Cut re-explanations of textbook concepts Claude already knows (1NF/2NF/3NF definitions, the ACID property list, the isolation-level semantics table, window-function semantics, N+1 and SQL-injection basics) and keep only the prescriptive rules and engine-specific non-obvious details (e.g., PRAGMA foreign_keys is off by default, PG11+ instant column defaults).

Add explicit validate->fix->retry feedback loops for risky operations: e.g., after applying a migration, run the Verification diagnostic queries and define what to check before proceeding, and pair each migration pattern with its tested rollback procedure (the skill itself flags 'Missing Rollback Handling in Migrations' as a pitfall but provides no rollback steps).

DimensionReasoningScore

Conciseness

The 771-line body re-explains foundational concepts Claude already knows — 1NF/2NF/3NF definitions ('Each column contains atomic (indivisible) values'), the ACID property list, the isolation-level semantics table, window function semantics ('Window functions compute values across sets of rows related to the current row without collapsing the result set'), and N+1/SQL-injection basics. Several sections teach textbook material rather than adding skill-specific, non-obvious guidance, matching the 'several unnecessary explanations or padded sections' anchor; it is not a 3 because the redundant conceptual scaffolding is substantial relative to the total bulk.

2 / 5

Actionability

Nearly everything is copy-paste ready: complete SQL for `CREATE INDEX CONCURRENTLY`, `SELECT ... FOR UPDATE SKIP LOCKED`, recursive CTEs, and RBAC grants; concrete config values (`shared_buffers = 4GB`, `random_page_cost = 1.1`, `innodb_buffer_pool_size = 12G`); executable shell commands (`pg_dump -F c -b -v`, `mysqldump --single-transaction`, `sqlite3 app.db ".backup ..."`); and runnable ORM code in TypeScript, PHP, and Python. Specific examples cover the common cases for each engine.

5 / 5

Workflow Clarity

The 'Steps' 1-10 headings are a topical taxonomy rather than an execution sequence with checkpoints, and although a Verification section provides diagnostic queries, there are no validate->fix->retry feedback loops for risky database operations (migrations, bulk changes) — which caps this dimension at 3 per the rubric's scoring note. The Expand/Contract migration pattern is a genuine sequenced workflow, so this is clearly above anchor 2 but fits anchor 3 ('sequence present but checkpoints missing or implicit').

3 / 5

Progressive Disclosure

The single bundle reference (references/query-optimization.md, verified to exist and one level deep) is clearly signaled in the closing 'Deep Dive Reference' section, but ~700 lines of same-depth material — engine tuning configs (section 7), four-language ORM examples (section 9), security and backup operations (section 10) — are inlined in SKILL.md instead of being split into reference files. This matches anchor 3 ('content that should be separate is inline'): better organized than a monolithic wall (not 2), but not 'most content appropriately placed' (not 4) since only one deep-dive topic was offloaded.

3 / 5

Total

13

/

20

Passed

Description

75%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, specific description with comprehensive concrete capabilities and distinctive engine/tool triggers, written in appropriate third-person style. Its main weakness is the absence of an explicit 'Use when...' trigger clause, which caps completeness, and a few missing natural trigger phrases like 'SQL' and 'slow query' tuning.

Suggestions

Add an explicit trigger clause, e.g.: 'Use when designing or refactoring database schemas, writing or tuning SQL queries, authoring migrations, or choosing between PostgreSQL, MySQL/MariaDB, SQLite, and NoSQL stores.' — this directly lifts the completeness cap from 3.

Work natural user phrasings into the description — 'SQL', 'slow query', 'query tuning/performance', 'database performance' — so it matches how users actually ask for this skill.

DimensionReasoningScore

Specificity

The description opens with four concrete action verbs ('Design, optimize, migrate, and maintain relational and hybrid database systems') and enumerates a comprehensive list of specific capability areas — 'schema design, normalization and denormalization, indexing strategies, transactions (ACID), migration management, ORM integration (Prisma, Drizzle, Eloquent, SQLAlchemy), security, backups, connection pooling' — including named engines and tools. This matches anchor 5 (multiple specific concrete actions, comprehensive coverage); not 4, since coverage spans the full lifecycle with no meaningful gap.

5 / 5

Completeness

The 'what' is clear and detailed, but there is no 'Use when...' clause or any equivalent explicit trigger guidance anywhere in the description — the second sentence only extends the capability list ('Covers schema design... engine-specific optimizations'). Per the judging guidelines, a missing 'Use when...' clause caps completeness at 3 ('clear what but when is missing or only weakly implied').

3 / 5

Trigger Term Quality

Good natural keyword coverage users would actually say: 'PostgreSQL, MySQL, MariaDB, and SQLite', 'schema design', 'indexing strategies', 'migrations', 'ORM', 'Prisma', 'backups', 'connection pooling'. Common variations are still missing — users frequently say 'SQL', 'slow query', 'query tuning', 'database performance', 'N+1' — so it fits anchor 4 ('good keyword coverage; a few natural terms missing') rather than the comprehensive synonym coverage of anchor 5.

4 / 5

Distinctiveness Conflict Risk

It carves out a clear niche — relational database lifecycle management — with highly distinct triggers (the four named engines plus named ORMs), so it is unlikely to fire for unrelated skills. Only a hypothetical SQL-query-writing skill could partially overlap, which is minimal conflict risk; this matches anchor 5 rather than anchor 4's 'minor overlap risk with closely related skills'.

5 / 5

Total

17

/

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

skill_md_line_count

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

Warning

Total

15

/

16

Passed

Repository

administrakt0r/pro-skills-repo-administraktor

Path

skills/development-skills/database-management/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.