pgdsn2env 1.0.1

Parse PostgreSQL DSNs into PG* environment variables with export helpers.

pgdsn2env

Parse PostgreSQL DSN strings into PG* environment variables and emit shell-friendly outputs.

Install

uv add pgdsn2env
# or
pip install pgdsn2env

Optional DSN parsers:

uv add "pgdsn2env[psycopg3]"
# or
uv add "pgdsn2env[psycopg2]"
# or
pip install "pgdsn2env[psycopg3]"
# or
pip install "pgdsn2env[psycopg2]"

CLI usage

# Basic
❯ pgdsn2env "postgresql://user@location:5432/test"
export PGDATABASE=test
export PGHOST=location
export PGPORT=5432
export PGUSER=user

# With Keyword/Value Connection Strings, in JSON format
❯  pgdsn2env "host=localhost port=5432 dbname=mydb user=postgres password=secret" --format json
{"PGDATABASE": "mydb", "PGHOST": "localhost", "PGPASSWORD": "secret", "PGPORT": "5432", "PGUSER": "postgres"}

# Invoked as Python module, with advanced params
❯ python -m pgdsn2env --format dotenv "postgresql://postgres:secret@localhost:5432/mydb?sslmode=require&application_name=myapp"
PGAPPNAME=myapp
PGDATABASE=mydb
PGHOST=localhost
PGPASSWORD=secret
PGPORT=5432
PGSSLMODE=require
PGUSER=postgres

Python usage

from pgdsn2env import pg_dsn_to_env

pg_env = pg_dsn_to_env("postgresql://user@location:5432/test")
print(pg_env) # {'PGHOST': 'location', 'PGPORT': '5432', 'PGDATABASE': 'test', 'PGUSER': 'user'}

Recipes

Set PG* environment variables in your current shell:

source <(pgdsn2env "$DATABASE_URL")

Then verify the variables are set:

echo $PGHOST $PGPORT $PGDATABASE $PGUSER

Notes

• A DSN parser is required: install either psycopg or psycopg2.
• Only parameters present in the DSN are emitted.
• Values are shell-quoted in CLI output.