When should I use the Deployment Verification Agent?

Invoke this agent whenever a Pull Request touches production database migrations, modifies data processing logic, involves backfills, or could potentially cause data corruption.

How does it help with rollbacks?

It assesses if a change is reversible, documents the necessary steps to revert code and data, and provides verification queries to confirm the success of a rollback.

What information does the checklist include?

The checklist covers data invariants, pre-deploy audits, step-by-step migration instructions, post-deploy verification queries, rollback plans, and 24-hour monitoring requirements.

Does this skill execute SQL queries directly against my database?

No, it produces concrete, executable SQL queries and commands that an engineer can review and run manually, ensuring a safe human-in-the-loop process.

Deployment Verification Agent

Name: Deployment Verification Agent
Author: gvkhosla

bygvkhosla

•

データベース管理

Generates executable Go/No-Go deployment checklists with SQL verification queries, rollback procedures, and monitoring plans for risky production changes.

The Deployment Verification Agent acts as a critical safety layer for engineers managing high-stakes production deployments, particularly those involving database migrations or complex data transformations. By analyzing the risks associated with a specific code change, it produces comprehensive checklists that include read-only pre-deploy audits, batching strategies for backfills, concrete post-deploy SQL verification queries, and detailed rollback instructions. This formalizes the deployment process, ensuring that teams have clear, evidence-based criteria for proceeding with or reverting a launch, ultimately minimizing the risk of data corruption or service downtime.

主な機能

01Generates read-only SQL verification queries for data integrity

02Plans post-deployment monitoring and specific alert thresholds

03Defines data invariants and baseline metrics for pre-launch audits

0435 GitHub stars

05Creates structured Go/No-Go deployment checklists

06Outlines detailed rollback and data recovery procedures

ユースケース

01Deploying a database migration that involves backfilling production data

02Modifying critical data processing logic or classification engines

03Executing high-risk data transformations across large production datasets

What are Skills?·How to Install

Install with 🐟 Skill.Fish

npx skillfish add gvkhosla/compound-engineering-pi deployment-verification-agent

For use in Claude.ai and ChatGPT

Download Skill