{"id":"707ec138-4d4e-40d5-9160-a54f7deeed5b","shortId":"vr84CL","kind":"skill","title":"Diff live database schemas against declarative SQL before schema drift reaches production with sqldef","tagline":"Compare checked-in SQL against live MySQL, PostgreSQL, SQLite, or SQL Server schemas and generate a reviewable apply plan before agents touch production databases.","description":"# Diff live database schemas against declarative SQL before schema drift reaches production with sqldef\n\nCompare checked-in SQL against live MySQL, PostgreSQL, SQLite, or SQL Server schemas and generate a reviewable apply plan before agents touch production databases.\n\n## Prerequisites\n\nGo-built sqldef binary and access to a supported relational database\n\n## Installation\n\nUse the upstream install or setup path that matches your environment:\n- Docker images are available on Docker Hub:\n- brew install sqldef/sqldef/mysqldef\n- brew install sqldef/sqldef/psqldef\n- brew install sqldef/sqldef/sqlite3def\n\nRequirements and caveats from upstream:\n- ### Docker images\n- https://hub.docker.com/u/sqldef\n- Debian packages are not currently available. Use the pre-built binaries or Docker images instead.\n\nBasic usage or getting-started notes:\n- Each database gets its own command (mysqldef, psqldef, sqlite3def, mssqldef) that mimics the connection options of the native database client, making it familiar and easy to integrate into existing workflows. The tool...\n- ### Basic Workflow\n- This is the basic workflow, which is identical across all databases - only the connection options differ between commands.\n\n- Source: https://github.com/sqldef/sqldef\n- Extracted from upstream docs: https://raw.githubusercontent.com/sqldef/sqldef/HEAD/README.md\n\n## Documentation\n\n- https://github.com/sqldef/sqldef\n\n## Source\n\n- [Agent Skill Exchange](https://agentskillexchange.com/skills/diff-live-database-schemas-against-declarative-sql-before-schema-drift-reaches-production-with-sqldef/)","tags":["diff","live","database","schemas","against","declarative","sql","before","schema","drift","reaches","production"],"capabilities":["skill","source-agentskillexchange","skill-diff-live-database-schemas-against-declarative-sql-before-schema-drift-reaches-production-with-sqldef","topic-agent-skills","topic-ai-agents","topic-ai-tools","topic-awesome-list","topic-claude-code","topic-codex","topic-cursor","topic-llm","topic-mcp","topic-npx-skills","topic-openclaw","topic-skills-catalog"],"categories":["skills"],"synonyms":[],"warnings":[],"endpointUrl":"https://skills.sh/agentskillexchange/skills/diff-live-database-schemas-against-declarative-sql-before-schema-drift-reaches-production-with-sqldef","protocol":"skill","transport":"skills-sh","auth":{"type":"none","details":{"cli":"npx skills add agentskillexchange/skills","source_repo":"https://github.com/agentskillexchange/skills","install_from":"skills.sh"}},"qualityScore":"0.454","qualityRationale":"deterministic score 0.45 from registry signals: · indexed on github topic:agent-skills · 8 github stars · SKILL.md body (1,579 chars)","verified":false,"liveness":"unknown","lastLivenessCheck":null,"agentReviews":{"count":0,"score_avg":null,"cost_usd_avg":null,"success_rate":null,"latency_p50_ms":null,"narrative_summary":null,"summary_updated_at":null},"enrichmentModel":"deterministic:skill-github:v1","enrichmentVersion":1,"enrichedAt":"2026-05-18T19:10:10.781Z","embedding":null,"createdAt":"2026-05-18T13:16:10.468Z","updatedAt":"2026-05-18T19:10:10.781Z","lastSeenAt":"2026-05-18T19:10:10.781Z","tsv":"'/skills/diff-live-database-schemas-against-declarative-sql-before-schema-drift-reaches-production-with-sqldef/)':226 '/sqldef/sqldef':208,219 '/sqldef/sqldef/head/readme.md':215 '/u/sqldef':129 'access':86 'across':195 'agent':36,75,221 'agentskillexchange.com':225 'agentskillexchange.com/skills/diff-live-database-schemas-against-declarative-sql-before-schema-drift-reaches-production-with-sqldef/)':224 'appli':33,72 'avail':107,135 'basic':146,185,190 'binari':84,141 'brew':111,114,117 'built':82,140 'caveat':122 'check':17,56 'checked-in':16,55 'client':172 'command':158,204 'compar':15,54 'connect':166,200 'current':134 'databas':3,39,42,78,91,154,171,197 'debian':130 'declar':6,45 'diff':1,40 'differ':202 'doc':212 'docker':104,109,125,143 'document':216 'drift':10,49 'easi':177 'environ':103 'exchang':223 'exist':181 'extract':209 'familiar':175 'generat':30,69 'get':150,155 'getting-start':149 'github.com':207,218 'github.com/sqldef/sqldef':206,217 'go':81 'go-built':80 'hub':110 'hub.docker.com':128 'hub.docker.com/u/sqldef':127 'ident':194 'imag':105,126,144 'instal':92,96,112,115,118 'instead':145 'integr':179 'live':2,21,41,60 'make':173 'match':101 'mimic':164 'mssqldef':162 'mysql':22,61 'mysqldef':159 'nativ':170 'note':152 'option':167,201 'packag':131 'path':99 'plan':34,73 'postgresql':23,62 'pre':139 'pre-built':138 'prerequisit':79 'product':12,38,51,77 'psqldef':160 'raw.githubusercontent.com':214 'raw.githubusercontent.com/sqldef/sqldef/head/readme.md':213 'reach':11,50 'relat':90 'requir':120 'review':32,71 'schema':4,9,28,43,48,67 'server':27,66 'setup':98 'skill':222 'skill-diff-live-database-schemas-against-declarative-sql-before-schema-drift-reaches-production-with-sqldef' 'sourc':205,220 'source-agentskillexchange' 'sql':7,19,26,46,58,65 'sqldef':14,53,83 'sqldef/sqldef/mysqldef':113 'sqldef/sqldef/psqldef':116 'sqldef/sqldef/sqlite3def':119 'sqlite':24,63 'sqlite3def':161 'start':151 'support':89 'tool':184 'topic-agent-skills' 'topic-ai-agents' 'topic-ai-tools' 'topic-awesome-list' 'topic-claude-code' 'topic-codex' 'topic-cursor' 'topic-llm' 'topic-mcp' 'topic-npx-skills' 'topic-openclaw' 'topic-skills-catalog' 'touch':37,76 'upstream':95,124,211 'usag':147 'use':93,136 'workflow':182,186,191","prices":[{"id":"f902bd73-b741-4070-ad94-e1f1f564b61b","listingId":"707ec138-4d4e-40d5-9160-a54f7deeed5b","amountUsd":"0","unit":"free","nativeCurrency":null,"nativeAmount":null,"chain":null,"payTo":null,"paymentMethod":"skill-free","isPrimary":true,"details":{"org":"agentskillexchange","category":"skills","install_from":"skills.sh"},"createdAt":"2026-05-18T13:16:10.468Z"}],"sources":[{"listingId":"707ec138-4d4e-40d5-9160-a54f7deeed5b","source":"github","sourceId":"agentskillexchange/skills/diff-live-database-schemas-against-declarative-sql-before-schema-drift-reaches-production-with-sqldef","sourceUrl":"https://github.com/agentskillexchange/skills/tree/main/skills/diff-live-database-schemas-against-declarative-sql-before-schema-drift-reaches-production-with-sqldef","isPrimary":false,"firstSeenAt":"2026-05-18T13:16:10.468Z","lastSeenAt":"2026-05-18T19:10:10.781Z"}],"details":{"listingId":"707ec138-4d4e-40d5-9160-a54f7deeed5b","quickStartSnippet":null,"exampleRequest":null,"exampleResponse":null,"schema":null,"openapiUrl":null,"agentsTxtUrl":null,"citations":[],"useCases":[],"bestFor":[],"notFor":[],"kindDetails":{"org":"agentskillexchange","slug":"diff-live-database-schemas-against-declarative-sql-before-schema-drift-reaches-production-with-sqldef","github":{"repo":"agentskillexchange/skills","stars":8,"topics":["agent-skills","ai-agents","ai-tools","awesome-list","claude-code","codex","cursor","llm","mcp","npx-skills","openclaw","skills-catalog"],"license":"mit","html_url":"https://github.com/agentskillexchange/skills","pushed_at":"2026-05-18T19:02:17Z","description":"The open catalog of AI agent skills — 2,000+ security-scanned skills for Claude Code, Cursor, Codex, and more.","skill_md_sha":"1acfb445983a812567ac26a14d69e3b5f0f17192","skill_md_path":"skills/diff-live-database-schemas-against-declarative-sql-before-schema-drift-reaches-production-with-sqldef/SKILL.md","default_branch":"main","skill_tree_url":"https://github.com/agentskillexchange/skills/tree/main/skills/diff-live-database-schemas-against-declarative-sql-before-schema-drift-reaches-production-with-sqldef"},"layout":"multi","source":"github","category":"skills","frontmatter":{"name":"Diff live database schemas against declarative SQL before schema drift reaches production with sqldef","description":"Compare checked-in SQL against live MySQL, PostgreSQL, SQLite, or SQL Server schemas and generate a reviewable apply plan before agents touch production databases."},"skills_sh_url":"https://skills.sh/agentskillexchange/skills/diff-live-database-schemas-against-declarative-sql-before-schema-drift-reaches-production-with-sqldef"},"updatedAt":"2026-05-18T19:10:10.781Z"}}