https://octopus.spindlemedia.com/app#/Spaces-1/projects/sql/variables these come from a variable in Octopus
The variable editor has a list of database names
Click on the label DatabaseName and you'll see an option called "Open Editor
You can run this from the master db in prod SQL periodically and then paste it into the variable editor to update it
SELECT name + '|' + name FROM sys.databases
WHERE name <> 'master'
ORDER BY name
Then have to update the snapshot variables for the project to bring the changes in, just did that and now it shows
Execute SQL Script - Snapshots - Octopus Deploy (spindlemedia.com)
Octopus Deploy