Can I bypass the backup requirement?

While the skill strictly enforces backups for protected production environments, developers can use specific override flags for non-critical environments if allowed by the configuration.

How does it determine the risk level of a migration?

It analyzes SQL patterns; additive changes like CREATE TABLE are Low risk, while schema modifications are Medium, and operations that delete data or tables are classified as High or Critical risk.

What happens if a destructive operation is detected?

The skill classifies the risk level and blocks the operation. For high-risk changes, it requires an enhanced approval phrase or an explicit override before allowing the deployment to proceed.

Does it work with existing migration tools?

Yes, it is designed to coordinate with migration-deployer and backup-manager skills, operating directly on SQL files regardless of the underlying migration framework.

Database Safety Validator

Name: Database Safety Validator
Author: fractary

$fractary$ byfractary

•

数据库管理

Analyzes database migrations for destructive operations and enforces production safety rules to prevent accidental data loss.

The Database Safety Validator is a mission-critical skill for the faber-db plugin suite, designed to protect production environments from dangerous schema changes and data-wiping operations. It automatically scans SQL migration files for high-risk commands such as DROP, TRUNCATE, and DELETE, classifying risks from Low to Critical. By enforcing mandatory backups and multi-stage approval workflows, it ensures that every database operation is validated, authorized, and recoverable, providing a robust safety net for developers and DevOps teams during complex deployments.

主要功能

01Structured audit logging and validation reporting for compliance tracking

02Mandatory backup enforcement and validation for production environments

032 GitHub stars

04Automated detection of destructive SQL commands like DROP, TRUNCATE, and DELETE

05Multi-level approval workflows including enhanced confirmation for high-risk changes

06Dynamic risk classification based on operation type and estimated data impact

使用场景

01Preventing accidental data loss by blocking unauthorized DROP TABLE operations in production

02Ensuring compliance by mandating a verified backup before any database schema migration

03Automating the safety review process for complex SQL scripts during CI/CD pipelines

What are Skills?·How to Install

Install with 🐟 Skill.Fish

npx skillfish add fractary/claude-plugins safety-validator

For use in Claude.ai and ChatGPT

Download Skill