currently temporal database password is config in yml, our requirement is getting database password dynamically.
How are you deploying server? Temporal server image entry point allows you to create a custom dockerize template (default here)
where you can set its value to be pulled from from container/pod env vars, or could use i believe names of existing secrets as well.
Is this what you are looking for?