Skill Detail
Diff live database schemas against declarative SQL before schema drift reaches production with sqldef
Compare checked-in SQL against live MySQL, PostgreSQL, SQLite, or SQL Server schemas and generate a reviewable apply plan before agents touch production databases.
Runbooks & DiagnosticsMulti-Framework
Runbooks & Diagnostics
Multi-Framework
Security Reviewed
⭐ 3.1k GitHub stars
COPY SKILL INSTRUCTIONS (OPTIONAL)
npx skills add agentskillexchange/skills --skill diff-live-database-schemas-against-declarative-sql-before-schema-drift-reaches-production-with-sqldef
Uses the third-party skills CLI, not an ASE-owned installer. Check your agent’s compatibility. This copies instructions; complete the upstream tool setup below separately.
At a glance
Tools required
Go-built sqldef binary and access to a supported relational database
Install & setup
Install the sqldef binary for your platform from the project releases or package manager, prepare declarative SQL files for the target database, then run the matching tool such as
psqldef, mysqldef, or sqlite3def against a live database to review and apply the diff.Author
sqldef
Publisher
Organization
Last updated
Apr 17, 2026
Quick brief
Use sqldef when an agent needs to reconcile a live database with declarative SQL files, review the generated diff, and apply schema changes in a controlled way. Invoke it instead of doing manual DDL or ad hoc database admin work when the real job is drift detection and schema alignment from checked-in SQL. The scope boundary is narrow and skill-shaped: schema diff and apply for supported relational databases, not general querying, ORM migration authoring, or a generic database product listing.