Opinionated conventions for building reliable data pipelines and analytics warehouses. 来源:https://prompts.chat/prompts/cmvm3vv9y000jl5089f2rkno9
Reviews PostgreSQL and MySQL schema migrations (raw SQL or ORM-generated) for table locks, rewrites, data loss, and breaking changes, then proposes safe zero-downtime rewrites with a clear verdict. 来源:https://prompts.chat/prompts/cmureuo3w0001lb06x7qn6vyo
Reviews PostgreSQL and MySQL tables (schema.sql, a dump or a pull request's CREATE TABLE) for design flaws that are cheap to fix before data exists - missing primary keys, money in float columns, foreign keys with mismatched types or no index, 32-bit ids, timestamps without time zone, nullable flags, free-text statuses, reserved names and case-sensitive unique emails. Returns corrected DDL. Includes a stdlib Python linter with --self-test. 来源:https://prompts.chat/prompts/cmvt899cc0015lb076u345t0n