skills.rest
GDSDN
GDSDNCOMMUNITY
Explore all skills by this author →
GitHub

db-smoke-test

Execute post-migration validation checks on a PostgreSQL database using psql.

3|Updated Feb 7, 2026
Search Tags:#testing#database#rls#validation#migration#sql
One-click install
npx skills add https://github.com/GDSDN/kord-aios --skill db-smoke-test
Or copy as Structured Prompt for Agent▼
Please help me install this Agent Skill.
Skill: db-smoke-test
Source: https://github.com/GDSDN/kord-aios/tree/main/src/features/builtin-skills/kord-aios/database/db-smoke-test
Command: npx skills add https://github.com/GDSDN/kord-aios --skill db-smoke-test

SYSTEM DOCUMENTATION & REQUIREMENTS

💡 This Skill requires psql, and includes scripts (resource) and references (resource) components.

What problem does it solve?

This Skill ensures that critical database operations, particularly after migrations, have completed successfully and that data integrity is maintained.

Core Features & Use Cases

  • Post-Migration Validation: Runs predefined checks to confirm schema objects, RLS policies, and data integrity.
  • Automated Testing: Executes SQL scripts to verify database state against expected outcomes.
  • Use Case: After deploying a new version of your application that includes database schema changes, run this Skill to automatically confirm that all tables, functions, and RLS policies are correctly in place and that basic data constraints are met.

Quick Start

Run the database smoke test skill to validate post-migration checks.

Frequently Asked Questions about db-smoke-test

High-intent search queries and answers about installing and using this skill.

FAQPage Schema
How do I validate database integrity after a PostgreSQL migration?▼

Post-migration database validation verifies schema object existence, Row Level Security (RLS) policy coverage, function presence, and basic data constraints using SQL queries. This Skill executes predefined psql scripts to confirm your PostgreSQL database state matches expected outcomes deterministically.

What is a database smoke test and when do I need to run one?▼

A database smoke test runs predefined SQL checks to confirm critical schema objects, RLS policies, and data integrity are in place. You need to run one after deploying application versions that include database schema changes to ensure migrations completed successfully.

How do I check if Row Level Security policies are correctly applied in PostgreSQL?▼

Checking RLS policy coverage involves executing SQL queries against the PostgreSQL database to verify expected security policies exist on tables. This Skill automates RLS policy validation as part of its post-migration checks to confirm security constraints are met.

Can I use custom SQL validation scripts for database testing?▼

You can use project-specific or template SQL smoke test scripts for deterministic database validation. This Skill supports executing custom psql scripts to verify your specific schema objects, functions, and data constraints against expected outcomes.

Do I need psql installed to run post-migration database validation?▼

You need psql installed because this Skill depends on it to execute SQL queries against your PostgreSQL database. The psql command-line tool is required to run the validation scripts that verify schema objects, RLS policies, and data integrity.

What limitations exist when testing database state with SQL scripts?▼

Testing database state with SQL scripts provides deterministic validation of schema objects, RLS policies, functions, and basic data constraints. These smoke test scripts verify expected outcomes but do not replace comprehensive integration testing or performance benchmarking.

Related Skills

Explore More Software Engineering Skills→
huydepzai121huydepzai121
3

postgresql-psql

Execute PostgreSQL psql commands for connections, queries, and administration.

Community
Intermediate
Elevaria-biaElevaria-bia

aiox-data-engineer

Design Supabase and PostgreSQL schemas with RLS policies and safe migrations.

Community
Advanced
jabrenajabrena
423

513-frameworks-micronaut-db-migrations-flyway

Manage Flyway database migrations in Micronaut applications.

Community
Advanced
CENKSSSCENKSSS

database-testing

Validate database schemas, data integrity, migrations, transactions, and query performance.

Community
Advanced