!pip install ipython-sql
import os
%load_ext sql
%config SqlMagic.autopandas = True
connection_string = f'postgresql://{os.environ["READER_USER"]}:{os.environ["READER_PASSWORD"]}@{os.environ["READER_HOST"]}:{os.environ["READER_PORT"]}/{os.environ["READER_DATABASE"]}'
%sql $connection_string
del connection_string
%%sql
select * from user
limit 20
* postgresql://reader:***@hh-pgsql-public.ebi.ac.uk:5432/pfmegrnargs
1 rows affected.