SkillsAdd

smithery/paleoterra

sqlite-test-validator

Test and validate SQLite database migrations and schema changes

Installation

$ npx skills add smithery/paleoterra --skill sqlite-test-validator
View on skills.sh ↗ Website ↗

Similar popular skills

Related neighbors and high-traction skills in the same topics — useful to compare before installing.

supabase-postgres-best-practices Shared topics
supabase/agent-skills

Postgres best practices maintained by Supabase, for Postgres running anywhere. Load this skill …

391.6K installs
prisma-cli Shared topics
prisma/skills

Prisma ORM CLI commands reference covering init, generate, migrate, db, dev, complete, studio, …

267K installs
supabase Shared topics
supabase/agent-skills

Use when doing ANY task involving Supabase. Triggers: Supabase products (Database, Auth, Edge F…

263K installs
expo-api-routes Shared topics
expo/skills 37.9K installs
convex-schema-validator Similar name
waynesutton/convexskills

Defining and validating database schemas with proper typing, index configuration, optional fiel…

3K installs
impl-validator Similar name
ar9av/obsidian-wiki

Validate whether an implementation matches its stated goal. Use this skill when a skill or agen…

2K installs

Also in this package

Other skills from smithery/paleoterra.

npx skills add smithery/paleoterra
localization-manager 0 crash-log-analyzer 0 ci-cd-helper 0

Browse all from smithery/paleoterra

More details

Agent compatibility

Declared targets from SKILL.md / docs. Unmarked agents are not listed — the skill may still install via the CLI.

Claude Code Not declared
Cursor Not declared
Codex Not declared
GitHub Copilot Not declared
Windsurf Not declared
Gemini CLI Not declared
Cline Not declared
OpenCode Not declared

Package contents

Files included with this skill beyond the listing page.

  • skill md SKILL.md 1,247 B
  • docs SUMMARY.md 92 B

History

  1. First recorded snapshot · 0 installs

SKILL.md

SQLite Test Validator

Test database migrations and validate schema integrity.

Capabilities

  • Test migration scripts
  • Validate schema changes
  • Check data integrity after migrations
  • Compare database schemas
  • Generate test databases
  • Verify foreign key constraints
  • Test triggers and indexes
  • Validate data types
  • Check for breaking changes

Tools

sqlite_validator.py - Test and validate databases

Commands

# Test migration
./sqlite_validator.py test-migration --from old.db --to new.db --script migrate.sql

# Compare schemas
./sqlite_validator.py compare --db1 v1.XRose --db2 v2.XRose

# Validate schema
./sqlite_validator.py validate schema.sql

# Check integrity
./sqlite_validator.py check-integrity database.XRose

Test Types

  • Schema Migration - Verify DDL changes
  • Data Migration - Verify data transforms
  • Integrity - Check constraints/triggers
  • Performance - Query performance
  • Rollback - Test migration reversibility

Complementary To

database-migration-helper (generates migrations) xrose-database-reader (reads XRose files)