A new column can look small in a pull request, but it touches every layer of the system. The database table changes. Migrations must run in production without downtime. Queries, indexes, and constraints all shift. Code that reads or writes that data must adapt, or it will break under load.
Start with the migration. In PostgreSQL, adding a nullable column is fast. Adding one with a default value on a large table is not. It locks writes. That lock can cascade into delayed jobs, failed requests, or even outages. For MySQL, an ALTER TABLE can rebuild the entire table. That means longer locks and higher risk. Choose the safest command for your engine. Test on a copy of production data.
Plan for deployments across services. API responses might now include the new column. Downstream consumers, transforms, or ETL jobs may assume the old schema. Deploy readers before writers. Deploy schema changes before code that depends on them. Remove fallbacks only after you’ve confirmed the change is live everywhere.