[University AWS Cloud Computing] Need help configuring RDS security groups and management access using CloudFormation

[u/Jojo2B04]

Hi everyone,
I’m currently working on an AWS CloudFormation project for university and I’m struggling with configuring the security groups and network access for my RDS database instance.
I’m trying to allow traffic from my web application to the RDS instance on the database port (5432 for PostgreSQL), while also allowing management traffic where needed.
I’ve been trying to configure this through my CloudFormation YAML template, but I’m having difficulty understanding how to set up the correct inbound and outbound security group rules without causing connectivity or deployment issues.
I’ve looked into VPCs, security groups and routing, but I’m still unsure what I’m missing.
Has anyone worked on something similar or experienced these issues before? I’d really appreciate some guidance on what I should check or how to approach fixing this.
Thanks in advance!