Dynamic Replacements

SQL Migration Tool supports dynamic replacements in migration files. You can use text placeholders in your SQL scripts that will be replaced with actual values at runtime.

When replacements are opened, the editor for this migration goes into read-only mode, and you can add one or more replacements per environment.

Any value specified in the From field will be replaced in the query with the value in the To field when this migration is deployed to the specific environment.

These replacements make it possible to:

• Customize SQL per environment
• Avoid hard-coded values inside migrations/scripts
• Inject paths, database names, or feature flags dynamically
• Keep production-safe values out of development environments

Dynamic replacements are available in both migrations and scripts.