toolkitbox/databases repository overview

# Interactive mode with shell access
docker run -it --rm \
  ghcr.io/pabpereza/toolkitbox/databases:latest \
  sh

# Connect to PostgreSQL
docker run -it --rm \
  -e PGPASSWORD=my_password \
  ghcr.io/pabpereza/toolkitbox/databases:latest \
  psql -h my-server.com -U postgres -d my_database

# Connect to MySQL
docker run -it --rm \
  ghcr.io/pabpereza/toolkitbox/databases:latest \
  mysql -h my-server.com -u root -p

# Connect to Redis
docker run -it --rm \
  ghcr.io/pabpereza/toolkitbox/databases:latest \
  redis-cli -h my-server.com

# Connect to MongoDB
docker run -it --rm \
  ghcr.io/pabpereza/toolkitbox/databases:latest \
  mongosh "mongodb://my-server.com:27017"

apiVersion: v1
kind: Pod
metadata:
  name: databases-client
spec:
  containers:
  - name: databases-client
    image: ghcr.io/pabpereza/toolkitbox/databases:latest
    command: ["sleep", "infinity"]
    env:
    # PostgreSQL
    - name: PGHOST
      value: "postgres-service"
    - name: PGUSER
      value: "postgres"
    - name: PGPASSWORD
      valueFrom:
        secretKeyRef:
          name: postgres-credentials
          key: password
    # MySQL
    - name: MYSQL_HOST
      value: "mysql-service"
    - name: MYSQL_PWD
      valueFrom:
        secretKeyRef:
          name: mysql-credentials
          key: password
    # Redis
    - name: REDISCLI_AUTH
      valueFrom:
        secretKeyRef:
          name: redis-credentials
          key: password

# Connect to database
psql -h hostname -U user -d database

# Execute query
psql -h hostname -U user -d database -c "SELECT version();"

# Backup database
pg_dump -h hostname -U user database > backup.sql

# Connect to database
mysql -h hostname -u user -p

# Execute query
mysql -h hostname -u user -p -e "SHOW DATABASES;"

# Backup database
mysqldump -h hostname -u user -p database > backup.sql

# Connect to database
mariadb -h hostname -u user -p

# Execute query
mariadb -h hostname -u user -p -e "SHOW DATABASES;"

# Connect to server
mongosh "mongodb://hostname:27017"

# Connect with authentication
mongosh "mongodb://user:password@hostname:27017/database"

# Execute command
mongosh "mongodb://hostname:27017" --eval "db.stats()"

# Connect to server
redis-cli -h hostname -p 6379

# Connect with authentication
redis-cli -h hostname -a password

# Execute command
redis-cli -h hostname PING

# Open or create database
sqlite3 mydatabase.db

# Execute query
sqlite3 mydatabase.db "SELECT * FROM users;"

# Use in-memory database
sqlite3 :memory: