Enable Streamlit app to be used by different users using their own DB credentials

I am going to deploy an app that communicates with Traditional-SQL database, I want to enable a feature where DB credentials are captured from a bash script from the user end or any other way. Asking users to enter the password will not be the proper approach considering sensitivity of PII. Can some please advice on the same?

Thanks and really appreciate the help