How do you handle schema changes when a research database is already in use?

Our group has a database that several projects now depend on, and the schema needs to change to support new data types.

I'm worried about breaking existing queries and analyses that collaborators rely on.

How do you manage schema migrations in a research setting where downtime and data loss are not acceptable?