Docker Compose DB Quicksheet

This article is more of a quick reference for me personally, but I thought it might be useful for others as well. I often find myself needing to quickly spin up a database for testing or development purposes.

MSSQL and Azurite

When developing for Azure services, I generally need SQL Azure for data storage and Azurite for queuing.

Create a docker-compose.yml file with the following contents:

version: '3.8'

services:
  mssql:
    image: mcr.microsoft.com/mssql/server:2022-latest
    hostname: mssql
    restart: always
    environment:
      ACCEPT_EULA: 'Y'
      MSSQL_SA_PASSWORD: 'mySecretPassword*'
    ports:
      - 1433:1433
    healthcheck:
      test:
        [
          'CMD',
          '/opt/mssql-tools18/bin/sqlcmd',
          '-S',
          'localhost,1433',
          '-U',
          'sa',
          '-P',
          'mySecretPassword*',
          '-No',
          '-Q',
          'select 1',
        ]
      interval: 5s
      timeout: 10s
      retries: 10
    volumes:
      - mssql_data:/var/opt/mssql

azurite:
  image: mcr.microsoft.com/azure-storage/azurite:latest
  restart: always
  command: 'azurite --loose --blobHost 0.0.0.0 --blobPort 10000 --queueHost 0.0.0.0 --queuePort 10001'
  ports:
    - 10000:10000
    - 10001:10001
    - 10002:10002
  volumes:
    - azurite_data:/data

volumes:
  mssql_data:
  azurite_data:

docker-compose up -d will start both services.

PostgreSQL, PGAdmin, and Redis

For other projects, I often need PostgreSQL, PGAdmin, and Redis.

Create a docker-compose.yml file with the following contents:

version: '3.8'

services:
  postgres:
    image: postgres
    environment:
      POSTGRES_USER: postgres
      POSTGRES_PASSWORD: postgressupersecret
      POSTGRES_DB: postgres
    ports:
      - 5432:5432
    volumes:
      - postgres_data:/var/lib/postgresql/data
    healthcheck:
      test: ['CMD-SHELL', 'pg_isready -U postgres -d postgressupersecret']
      interval: 10s
      timeout: 5s
      retries: 3

  pgadmin:
    image: dpage/pgadmin4
    environment:
      PGADMIN_DEFAULT_EMAIL: [email protected]
      PGADMIN_DEFAULT_PASSWORD: pgadminsupersecret
    ports:
      - 5000:80
    depends_on:
      postgres:
        condition: service_healthy
    user: root
    volumes:
      - pgadmin_data:/var/lib/pgadmin

  redis:
    image: redis
    ports:
      - 6379:6379
    healthcheck:
      test: ['CMD', 'redis-cli', 'ping']
      interval: 10s
      timeout: 5s
      retries: 3
    volumes:
      - redis_data:/data

volumes:
  postgres_data:
  pgadmin_data:
  redis_data:

Again, docker-compose up -d will start both services.

MongoDB

While I don't use MongoDB as often, I still find it useful for certain projects. Here's a quick setup for MongoDB in docker-compose.yml:

version: '3.8'

services:
  mongo:
    image: mongo
    hostname: mongo
    environment:
      MONGO_INITDB_ROOT_USERNAME: root
      MONGO_INITDB_ROOT_PASSWORD: examplePass
    restart: always
    ports:
      - 27017:27017
    healthcheck:
      test: ['CMD', 'mongo', '--eval', "db.adminCommand('ping')"]
      interval: 5s
      timeout: 10s
      retries: 10
    volumes:
      - mongo_data:/data/db

  mongo-express:
    image: mongo-express
    environment:
      ME_CONFIG_MONGODB_SERVER: mongo
      ME_CONFIG_MONGODB_ADMINUSERNAME: root
      ME_CONFIG_MONGODB_ADMINPASSWORD: examplePass
      ME_CONFIG_MONGODB_URL: mongodb://root:examplePass@mongo:27017/
      ME_CONFIG_BASICAUTH: false
    ports:
      - '8081:8081'
    depends_on:
      - mongo

volumes:
  mongo_data:

They're pretty quick and dirty, but they get the job done. Hopefully, this helps you as well.