AWS PostgreSQL Demo - Database Audit Trail Solution
I am an AWS Certified Solutions Architect & AWS Certified Developer, working in Brisbane, Australia. I have over 15 years experience in corporate IT environments, being fluent across both Windows Server, OSX, and Linux platforms within an enterprise environment. Coupled with a degree in Information Technology and Business, I have worked across numerous roles and industries within both on-prem and cloud environments.
AWS PostgreSQL Demo Project
The Problem: "Who Accessed The Database?"
When your database audit trail looks like this...
I built an AWS PostgreSQL demonstration that solves the critical question: "Who accessed what data and when?" This project addresses the common issue of shared database credentials where multiple engineers use the same login, making it impossible to trace individual database actions or maintain proper audit trails.
🚀 Full Project Details
The project page includes:
- 🎬 Live demo videos showing PII masking and audit trails
- 📊 Architecture diagrams with detailed explanations
- 🔧 Step-by-step setup instructions
- 💡 Security best practices and recommendations
- 📝 Complete documentation for replication
Quick Overview
What it demonstrates:
- AWS Aurora PostgreSQL Serverless with PGaudit logging
- Individual accountability through unique database logins
- PII data masking for internal engineers
- Complete audit trails streamed to CloudWatch
- Infrastructure as Code using AWS CDK
Key benefits:
- ✅ Track who accessed what data and when
- ✅ Enhanced security and compliance posture
- ✅ Individual engineer accountability
- ✅ Automated infrastructure deployment
- ✅ Cost-effective serverless architecture
Repository
Note: Remember to run
npx cdk destroyafter testing to avoid ongoing AWS charges! {: .prompt-warning }
