展示HN：DDL到数据 – 从SQL模式生成真实的测试数据
我开发了DDL到数据（DDL to Data），是因为我多次拒绝了“只需使用生产数据并进行脱敏”的请求。团队需要填充的数据库来进行测试，但提取生产数据意味着需要进行安全审查、个人身份信息（PII）清理和DevOps工单。手动编写的种子脚本作为替代方案，速度慢、脆弱，并且在架构变更的瞬间就会失去同步。
只需粘贴你的CREATE TABLE语句，就能获得逼真的测试数据。它会解析你的架构，保留外键关系，并生成看起来真实的数据，电子邮件看起来像电子邮件，时间戳合理，唯一性约束得到遵守。
无需设置，无需配置。支持PostgreSQL和MySQL。
我希望能收到任何处理测试数据或暂存环境的人的反馈。还有什么缺失的吗？
查看原文
I built DDL to Data after repeatedly pushing back on "just use production data and mask it" requests. Teams needed populated databases for testing, but pulling prod meant security reviews, PII scrubbing, and DevOps tickets. Hand-written seed scripts were the alternative slow, fragile, and out of sync the moment schemas changed.<p>Paste your CREATE TABLE statements, get realistic test data back. It parses your schema, preserves foreign key relationships, and generates data that looks real, emails look like emails, timestamps are reasonable, uniqueness constraints are honored.<p>No setup, no config. Works with PostgreSQL and MySQL.<p><a href="https://ddltodata.com" rel="nofollow">https://ddltodata.com</a><p>Would love feedback from anyone who deals with test data or staging environments. What's missing?