How to store json key value pair in and store it in one variable in linux – CentOS

I am calling python command which will return data is JSON key-value pair.

I have put python command and other command in one shell script named as – a.sh

Code (a.sh):

cd /home/drg/Code/dth

a=$(python3 main.py -z shell -y droub -i 56)

echo "$a"

When I am calling this script I am getting output as:

{'password': 'XYZ', 'name': 'Stguy', 'port': '5412', 'host': 'igtet', 'db_name': 'test3'}

And after getting this output I want to pass the output value like password, name to psql command to run postgresql query.

So, what I want is that I should be able to store password value in one variable, name in one variable like:

a= xyz
b=Stguy
p= port

So, that I can use this variables to pass in psql query as:

psql -h $a -p $p -U $b -d $db -c "CREATE SCHEMA IF NOT EXISTS  ${sname,,};"

Can someone please help me with this?

Note: Env is linux(Centos 8)

Thanks in advance!