REGION_CODE="ap-northeast-2"
RDS_NAME="skills-storage-rds-instance"
SECRET_NAME=$(aws secretsmanager list-secrets --query "SecretList[?contains(Name, 'rds')].Name" --output text --region $REGION_CODE)
DB_USER=$(aws secretsmanager get-secret-value --secret-id $SECRET_NAME --query "SecretString" --output text --region $REGION_CODE | jq -r ".username")
DB_PASSWORD=$(aws secretsmanager get-secret-value --secret-id $SECRET_NAME --query "SecretString" --output text --region $REGION_CODE | jq -r ".password")
DB_HOST=$(aws rds describe-db-instances --query "DBInstances[?DBInstanceIdentifier=='$RDS_NAME'].Endpoint.Address" --output text --region $REGION_CODE)
DB_PORT=$(aws rds describe-db-instances --query "DBInstances[?DBInstanceIdentifier=='$RDS_NAME'].Endpoint.Port" --output text --region $REGION_CODE)
DB_NAME=$(aws rds describe-db-instances --query "DBInstances[?DBInstanceIdentifier=='$RDS_NAME'].DBName" --output text --region $REGION_CODE)
CREATE TABLE skills.users (
    id INT UNSIGNED AUTO_INCREMENT PRIMARY KEY NOT NULL,
    name VARCHAR(255) NOT NULL,
    age TINYINT NOT NULL,
    country VARCHAR(255) NOT NULL
);
desc skills.users;

image.png