Can I customize the performance SLAs?

Yes, you can define custom millisecond targets for various operations such as simple queries, multi-table joins, write operations, and replication lag.

Can it detect replication issues?

Absolutely. It monitors replication lag, validates primary/replica synchronization, and compares row counts across replicas to ensure data consistency.

Which databases does this skill support?

The skill provides built-in support for PostgreSQL, MySQL, MongoDB, and Redis, including specific drivers and validation logic for each.

Does this skill help with database backups?

Yes, it includes backup validation features that check for backup recency, file checksum integrity, and point-in-time recovery (PITR) capabilities.

When is the best time to run these smoke tests?

It is designed to run at multiple execution points: pre-release, post-staging, during canary traffic increments (5%, 25%, 100%), and post-production.

Database Smoke Tester

Name: Database Smoke Tester
Author: FortiumPartners

byFortiumPartners

0•

데이터베이스 관리

Validates database connectivity, performance, and integrity across release workflows to ensure production stability.

This skill provides a comprehensive framework for executing database smoke tests during critical deployment phases. It automates the verification of connectivity, query performance against defined SLAs, schema consistency, and data integrity for major databases like PostgreSQL, MySQL, MongoDB, and Redis. By integrating these checks into pre-release, post-deployment, and canary workflows, it helps developers catch migration errors, replication lag, or performance regressions before they impact production users.

주요 기능

01Schema validation to ensure tables, columns, and indexes match expectations

02Real-time monitoring of replication health and backup recency

03Automated connectivity and SSL/TLS validation for multiple database types

04Deployment-aware execution points for staging, canary, and rollback phases

050 GitHub stars

06Query performance testing against customizable SLA millisecond targets

사용 사례

01Verifying database readiness and migration success before staging deployments

02Validating database state and schema integrity after a rollback operation

03Monitoring database performance and connection pooling during canary rollouts

주요 기능

01Schema validation to ensure tables, columns, and indexes match expectations

02Real-time monitoring of replication health and backup recency

03Automated connectivity and SSL/TLS validation for multiple database types

04Deployment-aware execution points for staging, canary, and rollback phases

050 GitHub stars

06Query performance testing against customizable SLA millisecond targets

사용 사례

01Verifying database readiness and migration success before staging deployments

02Validating database state and schema integrity after a rollback operation

03Monitoring database performance and connection pooling during canary rollouts