Design AWS Aurora database integrations with connection pooling, IAM authentication, and CloudWatch monitoring.
npx skills add https://github.com/lciacci/tessera --skill aws-aurora-lciacci
Please help me install this Agent Skill. Skill: aws-aurora Source: https://github.com/lciacci/tessera/tree/main/skills/aws-aurora Command: npx skills add https://github.com/lciacci/tessera --skill aws-aurora-lciacci
This Skill helps developers design and operate reliable AWS Aurora database integrations without connection exhaustion, inefficient scaling, fragile failover handling, or insecure credential management.
Use the aws-aurora skill to design an Aurora Serverless v2 architecture for my Lambda application, including connection pooling, secure authentication, migrations, and monitoring.
High-intent search queries and answers about installing and using this skill.
To prevent connection exhaustion when Lambda connects to Aurora PostgreSQL, configure RDS Proxy for connection pooling. This allows serverless compute to share a small pool of database connections, handling transient failures and scaling efficiently without overwhelming Aurora.
The best way to secure Aurora Serverless v2 credentials is using IAM database authentication or AWS Secrets Manager integration. This avoids hardcoding passwords, ensuring your application layer authenticates securely.
Yes, you can use Prisma migrations with Aurora Serverless v2. The integration requires proper connection management through RDS Proxy or the Data API, ensuring schema updates execute reliably during capacity scaling and zero-capacity retry states.
Aurora Serverless v2 handles scale-to-zero retry behavior by requiring transient-failure retries in your application logic. When capacity scales from zero, requests may fail until compute initializes, so implementing retry handling ensures resilient database connections.
If your ECS or EKS workload already uses PgBouncer, RDS Proxy may be redundant for pooling, but it still provides managed failover handling and IAM authentication. Evaluate your architecture to determine if native pooling meets your high availability requirements.
Monitor Aurora database performance and operational resilience using CloudWatch monitoring and Performance Insights. This setup tracks connection limits, scaling behavior, and transient failures, providing visibility into your serverless data layer health.
ai-enhanced-engineerImplement AWS security best practices for IAM, OIDC, and Secrets Manager.
codeApe-7Centralize SRE practices for SLOs, monitoring, and incident response automation.
imkdwAutomate Prisma migrations for PostgreSQL schema changes.
microsoftValidate Azure deployment readiness with pre-deployment and policy checks.
