docker-compose.yml

# Test DBs for local development (ports 43000+). Add connections in Settings:
# - PostgreSQL: host=localhost, port=43000, db=panopticum_dev, user=panopticum, password=panopticum
# - MongoDB: mongodb://localhost:43001
# - Redis: localhost:43002
# - ClickHouse: http://localhost:43003 (default user, no password)
# - MySQL: host=localhost, port=43005, db=panopticum_dev, user=panopticum, password=panopticum
# - Cassandra: host=localhost, port=43006, keyspace optional (e.g. create panopticum_dev via cqlsh)
# - MS SQL: host=localhost, port=43007, db=panopticum_dev, user=sa, password=Pan0pticum!
# - Oracle: host=localhost, port=43008, service=XEPDB1, user=panopticum, password=panopticum
# - RabbitMQ: amqp://localhost:43009 (default user/guest), management UI http://localhost:43010
# - Kafka: bootstrap localhost:43011 (add in Settings: host=localhost, port=43011)
# - Elasticsearch/OpenSearch: http://localhost:43012 (add in Settings: host=localhost, port=43012)

services:
  postgres:
    image: postgres:16-alpine
    ports:
      - "43000:5432"
    environment:
      POSTGRES_USER: panopticum
      POSTGRES_PASSWORD: panopticum
      POSTGRES_DB: panopticum_dev
    volumes:
      - postgres_data:/var/lib/postgresql/data
    healthcheck:
      test: ["CMD-SHELL", "pg_isready -U panopticum"]
      interval: 5s
      timeout: 5s
      retries: 5

  mongodb:
    image: mongo:7
    ports:
      - "43001:27017"
    volumes:
      - mongodb_data:/data/db
    healthcheck:
      test: ["CMD", "mongosh", "--eval", "db.adminCommand('ping')"]
      interval: 5s
      timeout: 5s
      retries: 5

  redis:
    image: redis:7-alpine
    ports:
      - "43002:6379"
    volumes:
      - redis_data:/data
    healthcheck:
      test: ["CMD", "redis-cli", "ping"]
      interval: 5s
      timeout: 5s
      retries: 5

  clickhouse:
    image: clickhouse/clickhouse-server:24
    ports:
      - "43003:8123"
      - "43004:9000"
    volumes:
      - clickhouse_data:/var/lib/clickhouse
    healthcheck:
      test: ["CMD", "wget", "-q", "--spider", "-O", "/dev/null", "http://localhost:8123/ping"]
      interval: 5s
      timeout: 5s
      retries: 5

  clickhouse-init:
    image: clickhouse/clickhouse-server:24
    depends_on:
      clickhouse:
        condition: service_healthy
    volumes:
      - ./docker/clickhouse-init/init.sql:/init.sql
    entrypoint: ["sh", "-c", "clickhouse-client --host clickhouse --multiquery < /init.sql"]

  mysql:
    image: mysql:8
    ports:
      - "43005:3306"
    environment:
      MYSQL_ROOT_PASSWORD: root
      MYSQL_USER: panopticum
      MYSQL_PASSWORD: panopticum
      MYSQL_DATABASE: panopticum_dev
    volumes:
      - mysql_data:/var/lib/mysql
    healthcheck:
      test: ["CMD", "mysqladmin", "ping", "-h", "localhost", "-u", "panopticum", "-ppanopticum"]
      interval: 5s
      timeout: 5s
      retries: 5

  cassandra:
    image: cassandra:4
    ports:
      - "43006:9042"
    volumes:
      - cassandra_data:/var/lib/cassandra
    healthcheck:
      test: ["CMD-SHELL", "cqlsh -e 'DESCRIBE KEYSPACES' || exit 1"]
      interval: 10s
      timeout: 10s
      retries: 10
      start_period: 30s

  mssql:
    image: mcr.microsoft.com/mssql/server:2022-latest
    ports:
      - "43007:1433"
    environment:
      ACCEPT_EULA: "Y"
      MSSQL_SA_PASSWORD: "Pan0pticum!"
    volumes:
      - mssql_data:/var/opt/mssql
    healthcheck:
      test: ["CMD-SHELL", "/opt/mssql-tools18/bin/sqlcmd -S localhost -U sa -P $$MSSQL_SA_PASSWORD -Q 'SELECT 1' -C -b || exit 1"]
      interval: 10s
      timeout: 10s
      retries: 10
      start_period: 30s

  mssql-init:
    image: mcr.microsoft.com/mssql/server:2022-latest
    depends_on:
      mssql:
        condition: service_healthy
    volumes:
      - ./docker/mssql-init/init.sql:/init.sql
    entrypoint: ["/opt/mssql-tools18/bin/sqlcmd", "-S", "mssql", "-U", "sa", "-P", "Pan0pticum!", "-C", "-i", "/init.sql"]

  oracle:
    image: gvenzl/oracle-xe:latest
    ports:
      - "43008:1521"
    environment:
      ORACLE_PASSWORD: "Pan0pticum!"
      APP_USER: panopticum
      APP_USER_PASSWORD: panopticum
    volumes:
      - oracle_data:/opt/oracle/oradata
    healthcheck:
      test: ["CMD-SHELL", "echo exit | sqlplus -S panopticum/panopticum@//localhost/XEPDB1 || exit 1"]
      interval: 30s
      timeout: 10s
      retries: 10
      start_period: 180s

  rabbitmq:
    image: rabbitmq:3-management
    ports:
      - "43009:5672"
      - "43010:15672"
    environment:
      RABBITMQ_DEFAULT_USER: guest
      RABBITMQ_DEFAULT_PASS: guest
    healthcheck:
      test: ["CMD-SHELL", "rabbitmq-diagnostics -q ping"]
      interval: 10s
      timeout: 5s
      retries: 5

  kafka:
    image: apache/kafka:latest
    ports:
      - "43011:9092"
    environment:
      - KAFKA_NODE_ID=1
      - KAFKA_PROCESS_ROLES=broker,controller
      - KAFKA_LISTENERS=CONTROLLER://localhost:9091,HOST://0.0.0.0:9092,DOCKER://0.0.0.0:9093
      - KAFKA_ADVERTISED_LISTENERS=HOST://localhost:43011,DOCKER://kafka:9093
      - KAFKA_LISTENER_SECURITY_PROTOCOL_MAP=CONTROLLER:PLAINTEXT,DOCKER:PLAINTEXT,HOST:PLAINTEXT
      - KAFKA_CONTROLLER_LISTENER_NAMES=CONTROLLER
      - KAFKA_CONTROLLER_QUORUM_VOTERS=1@localhost:9091
      - KAFKA_INTER_BROKER_LISTENER_NAME=DOCKER
      - KAFKA_OFFSETS_TOPIC_REPLICATION_FACTOR=1
    healthcheck:
      test: ["CMD-SHELL", "/opt/kafka/bin/kafka-topics.sh --bootstrap-server localhost:9093 --list || exit 1"]
      interval: 10s
      timeout: 10s
      retries: 5
      start_period: 30s

  kafka-init:
    image: apache/kafka:latest
    depends_on:
      kafka:
        condition: service_healthy
    volumes:
      - ./docker/kafka-init/init.sh:/init.sh
    entrypoint: ["sh", "/init.sh"]

  opensearch:
    image: opensearchproject/opensearch:2
    ports:
      - "43012:9200"
    environment:
      discovery.type: single-node
      DISABLE_INSTALL_DEMO_CONFIG: "true"
      DISABLE_SECURITY_PLUGIN: "true"
    volumes:
      - opensearch_data:/usr/share/opensearch/data
    healthcheck:
      test: ["CMD-SHELL", "curl -f http://localhost:9200 || exit 1"]
      interval: 10s
      timeout: 5s
      retries: 10
      start_period: 30s

  opensearch-init:
    image: curlimages/curl:latest
    depends_on:
      opensearch:
        condition: service_healthy
    volumes:
      - ./docker/opensearch-init/init.sh:/init.sh
    entrypoint: ["sh", "/init.sh"]

volumes:
  postgres_data:
  mongodb_data:
  redis_data:
  clickhouse_data:
  mysql_data:
  cassandra_data:
  mssql_data:
  oracle_data:
  rabbitmq_data:
  kafka_data:
  opensearch_data: