devpies/pgcli repository overview

⁠pgcli

pgcli⁠ container for postgres with password urlencoding

⁠Getting Started

Run a container with the postgres connection string⁠.

docker run --rm -it devpies/pgcli postgres://user:pass@host:port/database

⁠URL Encoding Passwords If Neccessary

devpies/pgcli can handle passwords in both encoded and unencoded forms, reducing the risk of connection errors due to improper encoding.

⁠Approach

1. The image first tries to connect using the password as provided, assuming it doesn’t need encoding. This avoids unnecessary encoding when it’s not needed.

2. If the initial connection fails, the image then URL-encodes the password and retries the connection, ensuring that special characters in the password are correctly handled.

⁠Using Docker Compose

Add a service to your project's compose file and place it on the same network as the postgres container. Provide the postgres connection string as an environment variable: CONN.

services:
  pgcli:
    image: devpies/pgcli
    environment:
      CONN: $CONN
    networks:
      - dbaccess

Then run:

docker compose run --rm pgcli