Best Claude Code Skills

Discover and explore the Best Claude Code Skills. A curated directory of powerful extensions to supercharge your AI coding assistant by Anthropic.

Navigation

Home
Browse Skills
Categories
Top 10 Skills
Favorites

Resources

Claude AI
Documentation
GitHub

Legal

Terms of Service
Privacy Policy

Other Projects

MapGo
Layerly

© 2026 Best Claude Code Skills. Built with care.

GitHub Twitter Bluesky

Best Claude Code Skills

Skills Categories Favorites

validate-with-database — Claude Code Skill | Best Claude Code Skills

validate-with-database

Connect to live PostgreSQL database to validate schema assumptions, compare pg_dump vs pgschema output, and query system catalogs interactively

TL;DR

Connect to live PostgreSQL to validate schema assumptions and compare pg_dump vs pgschema outputs.

What Is It

Validate schema behavior in live database
Compare pg_dump and pgschema schema outputs
Query system catalogs interactively
Test schema changes against real database

Key Features

Supports interactive psql queries
Enables schema comparison via pg_dump and pgschema
Allows system catalog inspection
Validates migration plans before implementation
Supports version-specific behavior checks (14-18)
Provides direct access to real database objects

How to Use

1.Connect using psql with provided credentials
2.Run pg_dump and pgschema to compare schema outputs
3.Query system catalogs for trigger/definition details
4.Validate migration plans with real database state

Guardrails & Gotchas

FORBIDDEN: Never modify production data without approval
MUST: Always verify schema differences before applying changes
MUST: Clean up test objects after validation
CRITICAL: Use only test databases for schema testing

GitHub Stats

Author

Repository

pgschema/pgschema

Stars

959

Explore More Skills

revenuecat

@rawveg

Comprehensive assistance with RevenueCat in-app subscriptions and purchases

Forks

57

Updated

December 5, 2025

Download

Download the skill repository as a ZIP file

Categories

DatabasesSQL Databases

api-design-principles

@wshobson

Master REST and GraphQL API design principles to build intuitive, scalable, and maintainable APIs that delight developers. Use when designing new APIs, reviewing API specifications, or establishing API design standards.

solana-security

@tenequm

Audit Solana programs (Anchor or native Rust) for security vulnerabilities. Use when reviewing smart contract security, finding exploits, analyzing attack vectors, performing security assessments, or when explicitly asked to audit, review security, check for bugs, or find vulnerabilities in Solana programs.