Environment tier
Environment color
You can configure any color for an environment either by inputting in HEX tab or choosing one in the palette.
Production indicator
Once you mark an environment as a production environment, Bytebase will attach a shield icon 🛡️ besides the environment name.
Rollout policy
Control who can deploy changes to each environment and whether deployments happen automatically or require manual approval.Configure Rollout Permissions
Manage deployment permissions and automatic rollout settings
SQL Review policy
Configure automated SQL validation rules for each environment to ensure code quality and compliance. Different environments can have different strictness levels - for example, production might enforce stricter rules than development.Configure SQL Review
Set up automated SQL validation rules and best practices enforcement
Access control
Configure environment-specific restrictions for SQL Editor operations:- Restrict data copying in SQL Editor: Only Workspace Admins and DBAs can copy data from query results
- Restrict querying admin data sources: Limit access to administrative data sources in the SQL Editor
Statement execution mode
Even if you havesql.dml and sql.ddl database permissions, you can only run read-only statements such as SELECT in SQL Editor by default. If you attempt to run mutation DML or DDL, it will prompt you to submit an issue.
Delete an environment
To permanently delete an environment:- Navigate to the environment page
- Click Delete this environment at the bottom of the page
- Confirm the deletion
Deleting an environment will also remove it from all related instances and databases. This action cannot be undone.