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.

主な機能

01Comprehensive connectivity and authentication testing

02Query performance benchmarking against custom SLA targets

03Automated schema validation and constraint checking

04Backup verification and point-in-time recovery validation

05Real-time replication health and data integrity monitoring

065 GitHub stars

ユースケース

01Monitoring canary deployments by testing connection pooling under incremental loads

02Post-migration health checks to verify schema updates and referential integrity

03Pre-release validation to ensure database readiness before staging deployments

What are Skills?·How to Install

Install with 🐟 Skill.Fish

npx skillfish add fortiumpartners/ai-mesh smoke-test-database

For use in Claude.ai and ChatGPT

Download Skill