AWS PostgreSQL Demo - Database Audit Trail Solution

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

View the complete project →

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

GitHub Repository →

Note: Remember to run npx cdk destroy after testing to avoid ongoing AWS charges!