sqldef
Ranked 2 of 3 database migration tools by recommenders
Idempotent schema diff tool supporting MySQL, PostgreSQL and SQLite; critics report PostgreSQL parse failures and mishandled SQLite column changes.
Idempotent schema diff tool supporting MySQL, PostgreSQL and SQLite; critics report PostgreSQL parse failures and mishandled SQLite column changes.
14 people gave an opinion
- recommend it
- 9
- criticize it
- 5
- approval share
- 64%
Recommended in 1 of 13 months
- November 2025: not recommended
- December 2025: not recommended
- January 2026: not recommended
- February 2026: recommended
- March 2026: not recommended
- April 2026: not recommended
- May 2026: not recommended
- June 2026: not recommended
- July 2026: not recommended
- August 2026: not recommended
- September 2026: not recommended
- October 2026: not recommended
- November 2026: not recommended (month in progress)
Why it doesn’t carry the badge
- 9 people recommend itNeeds 10 or more, not met.
- 1.8 recommenders for every criticNeeds 2 to 1 or better, not met.
- Recommended in 1 of 13 monthsNeeds 4 or more, not met.
The same three rules apply to every product, and the badge can’t be bought. How the badge works
What people say about it
The reasons people give, with the number of comments that give each one. Open a reason to read what they said.
Why people recommend it
Each mark is one comment
Diff-style schema migrations
“It is like a diff tool but to advance the schema.”
Comment from 4 Feb 2026 in “Sqldef: Idempotent schema management tool for MySQL, PostgreSQL, SQLite” “This looks really cool for schema migrations”
Comment from 5 Feb 2026 in “Sqldef: Idempotent schema management tool for MySQL, PostgreSQL, SQLite”
What people warn about
Each mark is one comment
Mishandles column changes in SQLite
“it doesn't handle dropping columns well in sqlite”
Comment from 5 Feb 2026 in “Sqldef: Idempotent schema management tool for MySQL, PostgreSQL, SQLite” “I renamed a column and it added a new one.”
Comment from 5 Feb 2026 in “Sqldef: Idempotent schema management tool for MySQL, PostgreSQL, SQLite”
Other database migration tools people recommend
The two most recommended other database migration tools, with the same counts for each, so you can compare like for like. The tick on each bar marks the 2 to 1 line the badge needs.
| Product | Recommend | Criticize | Approval | Months | Owned | Badge |
|---|---|---|---|---|---|---|
| Atlas by Ariga | 29 | 8 | 78% | 12 | — | Approved |
| sqldefThis page | 9 | 5 | 64% | 1 | — | — |
| Alembic | 5 | 4 | 56% | 4 | — | — |
What people said
11 of the 15 comments that mention it, newest first. Each links to the original comment.
“it doesn't handle dropping columns well in sqlite”
“Looks like it just generates invalid migrations”
“I tried only with a few of the PostgreSQL things we use in our schema and and failed parsing them”
“Pleasantly surprised this post was about a neat little tool and not another migration manager.”
“This looks really cool for schema migrations”
“Incredible tool, definitely going to get a working poc for this with my team”
“I renamed a column and it added a new one.”
“Looks like this is only useful for empty databases.”
“Be sure to look at the actual sqldef command-line tool, not the trivial copy-and-paste demo on their website.”
“sqldef is really cool for supporting many database dialects”
“It is like a diff tool but to advance the schema.”
Counts come from 1,795,640 Hacker News comments, November 2025 to November 2026. How we count. Report a mistake.