How does the skill handle schema validation?

It verifies the existence of required tables, columns, and indexes, while also checking that foreign key constraints and migration statuses match the expected structure.

Which databases are supported by this skill?

The skill provides specialized support for popular relational and NoSQL databases including PostgreSQL, MySQL, MongoDB, and Redis.

When should I run these database smoke tests?

These tests are designed to be executed at various points in the release workflow, including pre-release, post-staging, during canary rollouts, and after production deployments.

Can I customize the performance SLAs?

Yes, you can define specific SLA targets in milliseconds for simple queries, joins, write operations, and connection timeouts to match your specific application requirements.

Does it support replication lag monitoring?

Yes, the skill includes specialized categories for measuring primary-replica lag, verifying replica status, and ensuring data consistency across the cluster.

Smoke Test Database

Name: Smoke Test Database
Author: FortiumPartners

byFortiumPartners

•

데이터베이스 관리

Validates database connectivity, performance SLAs, schema integrity, and backup readiness during software release workflows.

소개

The Smoke Test Database skill empowers Claude to perform automated, comprehensive health checks on database environments to ensure they are production-ready. By validating everything from basic connectivity and query performance targets to complex schema constraints and replication lag, this skill minimizes the risk of database-related outages during deployments. It is an essential tool for DevOps engineers and backend developers who need to verify database state after migrations, during canary rollouts, or as part of scheduled health monitoring across PostgreSQL, MySQL, MongoDB, and Redis instances.

주요 기능

Comprehensive connectivity and authentication testing
Query performance benchmarking against custom SLA targets
Automated schema validation and constraint checking
Backup verification and point-in-time recovery validation
Real-time replication health and data integrity monitoring
5 GitHub stars

사용 사례

Monitoring canary deployments by testing connection pooling under incremental loads
Post-migration health checks to verify schema updates and referential integrity
Pre-release validation to ensure database readiness before staging deployments

소개

주요 기능

Comprehensive connectivity and authentication testing
Query performance benchmarking against custom SLA targets
Automated schema validation and constraint checking
Backup verification and point-in-time recovery validation
Real-time replication health and data integrity monitoring
5 GitHub stars

사용 사례

Monitoring canary deployments by testing connection pooling under incremental loads
Post-migration health checks to verify schema updates and referential integrity
Pre-release validation to ensure database readiness before staging deployments