Setup Mailcow Alias with MariaDB SQL or API

sudo -i
cd /opt/mailcow-dockerized
docker exec -it $(docker ps -qf name=mysql-mailcow) mariadb -u mailcow -p$(grep 'DBPASS' mailcow.conf | cut -d'=' -f2)

USE mailcow;
INSERT INTO alias (address, goto, domain, created, modified, private_comment, public_comment, sogo_visible, internal, active, sender_allowed) VALUES ('alias@domain.com', 'mailcow@domain.com', 'domain.com', NOW(), NULL, NULL, NULL, 1, 0, 1, 1);

# Enable API in Mailcow UI: Configuration -> Access -> API
# Obtain your Read-Write API Key, then run:

curl -X POST "https://<MAILCOW_HOSTNAME>/api/v1/add/alias" \
  -H "X-API-Key: YOUR_API_KEY_HERE" \
  -H "Content-Type: application/json" \
  -d '{
    "address": "alias@domain.com",
    "goto": "mailcow@domain.com",
    "active": "1",
    "sogo_visible": "1"
  }'