MIMIC-III (Medical Information Mart for Intensive Care III) is a large, freely-available database comprising deidentified health-related data associated with over forty thousand patients who stayed in critical care units of the Beth Israel Deaconess Medical Center between 2001 and 2012.

This project composes the following containers:

• Postgres database setup with the MIMIC-III schema
• PgAdmin for database management
• Postgraphile for serving data using GraphQL

MIMIC data is not included in the containers

• URL: localhost:5432
• Username: mimic
• Password: password

Retrieve a list of patients using Postgres:

psql --host 127.0.0.1 --username=mimic --dbname=mimic -c 'SELECT FROM mimic.patients LIMIT 10;

• URL: http://localhost:5050
• Username: pgadmin4@pgadmin.org
• Password: admin

• URL: http://0.0.0.0:5000/graphiql

Retrieve a list of caregivers using GraphQL:

curl \
   -X POST \
   -H "Content-Type: application/json" \
   --data '{ "query": "{ caregivers { cgid } }" }' \
   http://localhost:4466/

{
  "data" : {
    "caregivers" : [ ]
  }
}

Link the database volume to a local folder i.e. export DB_DIR="/Users/<path to dir>/postgresDB". Then setup the containers using docker-compose up -d.

• PostgresSQL scripts for mimic-code
• Postgres container
• Postgraphile container