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

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.

主要功能

Structured audit logging and validation reporting for compliance tracking
Mandatory backup enforcement and validation for production environments
2 GitHub stars
Automated detection of destructive SQL commands like DROP, TRUNCATE, and DELETE
Multi-level approval workflows including enhanced confirmation for high-risk changes
Dynamic risk classification based on operation type and estimated data impact

使用场景

Preventing accidental data loss by blocking unauthorized DROP TABLE operations in production
Ensuring compliance by mandating a verified backup before any database schema migration
Automating the safety review process for complex SQL scripts during CI/CD pipelines

关于

主要功能

Structured audit logging and validation reporting for compliance tracking
Mandatory backup enforcement and validation for production environments
2 GitHub stars
Automated detection of destructive SQL commands like DROP, TRUNCATE, and DELETE
Multi-level approval workflows including enhanced confirmation for high-risk changes
Dynamic risk classification based on operation type and estimated data impact

使用场景

Preventing accidental data loss by blocking unauthorized DROP TABLE operations in production
Ensuring compliance by mandating a verified backup before any database schema migration
Automating the safety review process for complex SQL scripts during CI/CD pipelines