docker-compose.test.yml

version: '3.8'

services:
  mysql1:
    image: mysql:8.0
    container_name: mcp_mysql1
    environment:
      MYSQL_ROOT_PASSWORD: password1
      MYSQL_DATABASE: db1
      MYSQL_USER: user1
      MYSQL_PASSWORD: password1
    ports:
      - "13306:3306"
    command: --default-authentication-plugin=mysql_native_password
    healthcheck:
      test: ["CMD", "mysqladmin", "ping", "-h", "localhost", "-u", "user1", "-ppassword1"]
      interval: 5s
      timeout: 5s
      retries: 5
    volumes:
      - mysql1_data:/var/lib/mysql

  mysql2:
    image: mysql:8.0
    container_name: mcp_mysql2
    environment:
      MYSQL_ROOT_PASSWORD: password2
      MYSQL_DATABASE: db2
      MYSQL_USER: user2
      MYSQL_PASSWORD: password2
    ports:
      - "13307:3306"
    command: --default-authentication-plugin=mysql_native_password
    healthcheck:
      test: ["CMD", "mysqladmin", "ping", "-h", "localhost", "-u", "user2", "-ppassword2"]
      interval: 5s
      timeout: 5s
      retries: 5

  postgres1:
    image: postgres:15
    container_name: mcp_postgres1
    environment:
      POSTGRES_USER: user1
      POSTGRES_PASSWORD: password1
      POSTGRES_DB: db1
    ports:
      - "15432:5432"
    healthcheck:
      test: ["CMD-SHELL", "pg_isready -U user1 -d db1"]
      interval: 5s
      timeout: 5s
      retries: 5
    volumes:
      - postgres1_data:/var/lib/postgresql/data

  postgres17:
    image: postgres:17beta1
    container_name: mcp_postgres17
    environment:
      POSTGRES_USER: user2
      POSTGRES_PASSWORD: password2
      POSTGRES_DB: db2
    ports:
      - "15433:5432"
    healthcheck:
      test: ["CMD-SHELL", "pg_isready -U user2 -d db2"]
      interval: 5s
      timeout: 5s
      retries: 5
    volumes:
      - postgres17_data:/var/lib/postgresql/data


networks:
  default:
    name: mcp_test_network

volumes:
  mysql1_data:
  postgres1_data:
  postgres17_data: