databases

MongoDB and PostgreSQL database administration. Databases: MongoDB (document store, aggregation, Atlas), PostgreSQL (relational, SQL, psql). Capabilities: schema design, query optimization, indexing, migrations, replication, sharding, backup/restore, user management, performance analysis. Actions: design, query, optimize, migrate, backup, restore, index, shard databases. Keywords: MongoDB, PostgreSQL, SQL, NoSQL, BSON, aggregation pipeline, Atlas, psql, pgAdmin, schema design, index, query optimization, EXPLAIN, replication, sharding, backup, restore, migration, ORM, Prisma, Mongoose, connection pooling, transactions, ACID. Use when: designing database schemas, writing complex queries, optimizing query performance, creating indexes, performing migrations, setting up replication, implementing backup strategies, managing database permissions, troubleshooting slow queries.

Quality

84%

Does it follow best practices?

Run evals on this skill

Adds up to 20 points to the overall score

View guide

Securityby

Passed

No findings from the security scan

Quality

Content

72%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-organized, highly actionable skill body that uses progressive disclosure effectively to point to real reference and script bundles. Its gaps are redundant basic-CRUD and duplicated when-to-use content, and an absence of validation/verification checkpoints around destructive database operations.

Suggestions

Trim the 'Common Operations' CRUD basics and the duplicated 'When to Use' list; assume Claude knows basic insert/find/update/delete and rely on the frontmatter triggers.

Add explicit validation/verification checkpoints around destructive and batch operations — e.g. verify row counts or run a test query after migrations, and confirm backups before restore.

Add a brief feedback loop for migrations/backups (run -> validate -> fix -> retry) to lift workflow clarity above the destructive-operation cap.

Dimension	Reasoning	Score
Conciseness	Mostly efficient and well-structured, but the 'When to Use' section duplicates the description's triggers and the 'Common Operations' section teaches basic CRUD (insertOne, find, INSERT/SELECT/UPDATE/DELETE) across both DBs that Claude already knows, so it could be tightened.	3 / 5
Actionability	Provides copy-paste-ready MongoDB shell, SQL, psql, and index commands plus concrete script invocations (e.g. 'python scripts/db_migrate.py --db mongodb --generate "add_user_index"') covering the common cases.	5 / 5
Workflow Clarity	A rough setup sequence exists, but destructive/batch database operations (delete, migrate, backup/restore) appear with no validation or verification checkpoints, so per the rubric's database-operations rule workflow_clarity is capped at 3.	3 / 5
Progressive Disclosure	The body is a clear overview with a well-signaled 'Reference Navigation' section pointing one level deep to 8 real reference files (verified present) and 3 real scripts, each with a descriptive label, making navigation easy.	5 / 5
	Total	16 / 20 Passed

Description

96%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, highly specific description with comprehensive concrete actions, broad natural trigger terms, and an explicit 'Use when' clause. Its main weakness is keyword-stuffed verbosity and breadth that slightly raises conflict risk with narrower database skills.

Dimension	Reasoning	Score
Specificity	Lists many concrete actions (schema design, query optimization, indexing, migrations, replication, sharding, backup/restore, user management) plus an explicit Actions list, giving comprehensive coverage rather than just 1-2 actions.	5 / 5
Completeness	Explicitly answers both 'what' (MongoDB and PostgreSQL administration with named capabilities/actions) and 'when' (concrete 'Use when: designing database schemas, writing complex queries...' trigger phrases).	5 / 5
Trigger Term Quality	Comprehensive keyword coverage with synonyms and tool names (MongoDB/PostgreSQL, SQL/NoSQL, BSON, Atlas, psql, pgAdmin, Prisma, Mongoose, EXPLAIN, ACID) plus natural 'Use when' trigger phrases users would actually say.	5 / 5
Distinctiveness Conflict Risk	Names two specific products giving a clear niche, but the very broad capability surface (backup, restore, migration, performance) creates minor overlap risk with dedicated single-purpose skills; not a 5 due to that breadth.	4 / 5
	Total	19 / 20 Passed

Validation

100%

Warnings & errors only

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

Validation — 16 / 16 Passed

Validation for skill structure

No warnings or errors.

Repository: samhvw8/dot-claude
Path: skills/databases/SKILL.md
Commit: 28c7616

Reviewed: 3 days ago

Table of Contents

Discovery Implementation Validation

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.