Are there good tools that can dump a database schema to files that are human- an... | Hacker News

Hacker Newsnew | past | comments | ask | show | jobs | submit

		physicles 5 months ago \| parent \| context \| favorite \| on: You Should Add Debug Views to Your DB Are there good tools that can dump a database schema to files that are human- and AI-readable? We use migrations as the source of truth for the prod database schema, but they’re also a pain when you want to just see the latest version of a table or a stored procedure.

sgarland 5 months ago [–]

mysqldump --nodata

pg_dump --schema-only

Read tool docs for other options, like restricting to a specific DB or table, but that’s the basic gist of it.

Guidelines | FAQ | Lists | API | Security | Legal | Apply to YC | Contact