What is schema drift and why does it matter?

Schema drift occurs when the database structure deviates from your code's schema. Detecting it prevents runtime errors caused by missing columns or type mismatches.

Can this skill block an automated deployment?

Yes, when integrated with deployment workflows, it can block operations if an 'Unhealthy' status or critical connectivity error is detected.

What database tools does Health Checker support?

It currently features a specialized handler for Prisma, with architectural support for future integrations like TypeORM and Sequelize.

Does Health Checker expose my database credentials?

No, the skill is strictly configured to never expose sensitive data such as passwords, tokens, or connection strings in its output.

How does it handle performance monitoring?

It performs basic performance checks including average query time and connection pool usage to identify potential degradation before it causes an outage.

Health Checker

Name: Health Checker
Author: fractary

byfractary

•

Database Management

Monitors database health and detects issues like schema drift and connectivity failures across multiple environments.

About

The Health Checker skill provides a comprehensive diagnostic suite for database management within Claude Code. It automates critical checks including database connectivity, migration status verification, and schema drift detection between application models and the actual database state. By providing structured health reports—categorized as Healthy, Degraded, or Unhealthy—and actionable remediation steps, it ensures database integrity during deployments, rollbacks, and routine maintenance. The skill integrates seamlessly with migration tool handlers like Prisma to maintain a reliable and synchronized data layer.

Key Features

Real-time connectivity testing with precise latency measurements
Automated schema drift detection between ORM models and live databases
Structured health reports with actionable recovery recommendations
Migration status verification to identify pending or failed updates
2 GitHub stars
Pre- and post-deployment integration for safer database CI/CD

Use Cases

Troubleshooting schema drift where the database structure deviates from the codebase
Pre-deployment validation to prevent migration failures in production
Automated post-rollback verification to ensure successful data restoration

About

Key Features

Real-time connectivity testing with precise latency measurements
Automated schema drift detection between ORM models and live databases
Structured health reports with actionable recovery recommendations
Migration status verification to identify pending or failed updates
2 GitHub stars
Pre- and post-deployment integration for safer database CI/CD

Use Cases

Troubleshooting schema drift where the database structure deviates from the codebase
Pre-deployment validation to prevent migration failures in production
Automated post-rollback verification to ensure successful data restoration