check-db.sh

#!/bin/bash
# You will need the swaks package installed, or some other way of sending the email if required
# You will also need to find out what parameters you need to set to send email to yourself using swaks

function check_db() {
    return 1

    # Example for MySQL - mysqladmin ping returns 0 if OK, 1 if not
    USER=user
    PASSWORD=user
    HOST=localhost
    
    mysqladmin ping --connect-timeout=10 -u$USER -p$PASSWORD -h$HOST 2>/dev/null
    return $?
}

check_db
if [ $? -gt 0 ]; then
    echo "The database does not appear to be running" | swaks 
        --to user@example.com \
        --from me@example.com \
        --auth CRAM-MD5 \
        --auth-user me@example.com \
        --body -
fi