Adding a new column to a production database can be simple or dangerous, depending on how you approach it. Schema changes have real impact. They can lock tables, slow queries, and trigger cascading updates. The right method depends on your database engine, your data volume, and your uptime requirements.
In PostgreSQL, a new column with a default value can cause a full table rewrite unless you set it to NULL first, then backfill the default in small batches. In MySQL, adding a column to a large table without an online DDL strategy can block writes and degrade performance. Even schema-less systems like MongoDB handle new fields differently depending on indexing and storage engines.
Before adding a column, review if it needs to be nullable, its data type, and whether it will be indexed. Each decision carries cost. Avoid adding indexes until after the column exists and is populated; creating them too early can cause major write amplification.