automating-database-backups

Automate database backup processes with scheduling, compression, and encryption. Supports PostgreSQL (pg_dump), MySQL (mysqldump), MongoDB (mongodump), and SQLite. Generates production-ready backup scripts with retention policies and restore procedures. Trigger: "automate database backups", "schedule backups", "create backup script", "disaster recovery". Use when working with automating database backups. Trigger with 'automating', 'database', 'backups'.

Quality

78%

Does it follow best practices?

Run evals on this skill

Adds up to 20 points to the overall score

View guide

Securityby

Medium

Suggest reviewing before use

Fix and improve this skill with Tessl

tessl review fix ./plugins/database/database-backup-automator/skills/automating-database-backups/SKILL.md

Quality

Content

72%Weight 40%Scale 1-3

Reviews the quality of instructions and guidance provided to agents. Good implementation is clear, handles edge cases, and produces reliable results.

The content is highly actionable and well-structured with real reference bundles, giving Claude concrete executable steps. Its weaknesses are redundant filler sections (Overview, placeholder Examples, mis-scoped Prerequisites) and an incomplete validate-fix-retry feedback loop for risky backup operations.

Suggestions

Remove the redundant 'Overview' section (it duplicates the description) and the placeholder 'Examples' section, or replace the latter with a real concrete backup scenario.

Add an explicit feedback loop after Step 4: if validation fails, fix the script/config and re-run validation before proceeding to restore.

Fix the 'Prerequisites' section to be database-agnostic (it currently singles out PostgreSQL) or scope it per database type.

Dimension	Reasoning	Score
Conciseness	The body is mostly lean executable code and tables, but it carries redundant low-value filler: an 'Overview' section that repeats the description, a generic 'Examples' section with placeholder text ('Apply automating database backups to a standard project setup'), and a PostgreSQL-specific 'Prerequisites' line in a multi-DB skill, so it could be tightened.	2 / 3
Actionability	Provides fully executable, copy-paste-ready guidance: complete pg_dump/mysqldump/mongodump bash scripts, concrete python3 script invocations with flags, a cron table, retention 'find ... -delete' commands, and an error-handling table with specific diagnostic commands, matching the 'fully executable' anchor.	3 / 3
Workflow Clarity	There is a clear five-step sequence with a dedicated validation step (Step 4: backup_validator.py), but for a destructive/batch backup operation the validation is invoked without an explicit validate->fix->revalidate feedback loop, so it sits at the 'steps listed with validation gaps' anchor rather than the full-checkpoint anchor.	2 / 3
Progressive Disclosure	The body is a concise overview that points to one-level-deep, real bundle files: six ${CLAUDE_SKILL_DIR}/references/.md guides and the scripts/.py tools, all verified to exist, with content appropriately split between inline overview and reference files.	3 / 3
	Total	10 / 12 Passed

Description

85%Weight 40%Scale 1-3

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 is specific and complete, clearly stating what the skill does and when to use it with explicit triggers. Its main weakness is trigger phrasing that mixes natural phrases with awkward, keyword-stuffed language.

Suggestions

Rewrite 'Trigger with automating, database, backups' and 'Use when working with automating database backups' into a single natural 'Use when...' clause phrased as a user would actually ask.

Keep the natural trigger phrases ('automate database backups', 'schedule backups', 'create backup script', 'disaster recovery') and drop the bare-word list to avoid keyword-stuffing penalties.

Dimension	Reasoning	Score
Specificity	Lists multiple concrete actions ('Automate database backup processes with scheduling, compression, and encryption', 'Supports PostgreSQL (pg_dump), MySQL (mysqldump), MongoDB (mongodump)', 'Generates production-ready backup scripts with retention policies and restore procedures'), matching the 'multiple specific concrete actions' anchor.	3 / 3
Completeness	Explicitly answers both 'what' (scheduling/compression/encryption across four DBMSs, retention and restore scripts) and 'when' ('Use when working with automating database backups' plus explicit Trigger phrases), satisfying the explicit-trigger anchor and avoiding the missing-trigger cap.	3 / 3
Trigger Term Quality	Includes relevant natural phrases ('automate database backups', 'schedule backups', 'create backup script', 'disaster recovery'), but the ungrammatical 'Use when working with automating database backups' and the stuffed bare-word list 'Trigger with automating, database, backups' read as keyword stuffing rather than natural user speech, so it does not reach the clean natural-coverage anchor.	2 / 3
Distinctiveness Conflict Risk	Occupies a clear niche (database backups for named DBMSs with backup-specific triggers like 'disaster recovery' and 'create backup script'), making overlap with unrelated skills unlikely.	3 / 3
	Total	11 / 12 Passed

Validation

87%

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 — 14 / 16 Passed

Validation for skill structure

Criteria	Description	Result
allowed_tools_field	'allowed-tools' contains unusual tool name(s)	Warning
frontmatter_unknown_keys	Unknown frontmatter key(s) found; consider removing or moving to metadata	Warning

	Total	14 / 16 Passed

Repository: jeremylongshore/claude-code-plugins-plus-skills
Path: plugins/database/database-backup-automator/skills/automating-database-backups/SKILL.md
Commit: be8dd2e

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.