aws-aurora

Configure AWS Aurora connections with IAM authentication and connection pooling.

1|Updated Feb 26, 2026
One-click install
npx skills add https://github.com/aberrantCode/llm_skills --skill aws-aurora-aberrantcode
Or copy as Structured Prompt for Agent
Please help me install this Agent Skill.
Skill: aws-aurora
Source: https://github.com/aberrantCode/llm_skills/tree/main/claude/skills/aws-aurora
Command: npx skills add https://github.com/aberrantCode/llm_skills --skill aws-aurora-aberrantcode

SYSTEM DOCUMENTATION & REQUIREMENTS

What problem does it solve?

Prevents database connection exhaustion, simplifies secure access, and reduces operational friction when using Amazon Aurora from serverless functions and long-running services.

Core Features & Use Cases

  • RDS Proxy configuration: guidance to create and tune RDS Proxy for Lambda connection pooling and IAM authentication.
  • Data API integration: examples for HTTP-based access to Aurora Serverless v2 with TypeScript and Python.
  • Connection pooling strategies: patterns for Lambda (max:1), long-running servers (pg.Pool, PgBouncer), and Prisma integration.
  • Resiliency & monitoring: retry/backoff for scale-to-zero wake-ups, CloudWatch metrics, and Performance Insights recommendations.
  • Migrations & CI/CD: best practices for applying database migrations in deployment workflows.

Quick Start

Connect your Lambda to an Aurora Serverless v2 cluster via RDS Proxy using IAM authentication and reuse a single pooled connection across invocations to run queries securely.

Frequently Asked Questions about aws-aurora

High-intent search queries and answers about installing and using this skill.

FAQPage Schema
How do I prevent AWS Aurora connection exhaustion in Lambda functions?

To prevent Aurora connection exhaustion in Lambda, configure RDS Proxy for connection pooling and reuse a single connection across invocations. This secures access with IAM authentication and maintains database stability during serverless scale events.

What is the best connection pooling strategy for Prisma with Aurora Serverless?

The best Prisma connection pooling strategy for Aurora Serverless involves configuring PgBouncer or utilizing RDS Proxy. This ensures robust connection management and prevents database overload when your Prisma-backed server handles concurrent requests.

How do I handle AWS Aurora Serverless v2 scale-to-zero retry and backoff?

Handle Aurora Serverless v2 scale-to-zero wake-ups by implementing retry and backoff patterns. This resiliency technique allows your application to wait for the database to spin up without throwing connection timeout errors during cold starts.

Can I use the Data API to access Aurora Serverless v2 with TypeScript and Python?

Yes, you can use the Data API for HTTP-based access to Aurora Serverless v2. The Skill provides production-ready examples in both TypeScript and Python for executing queries without managing persistent database connections.

How do I apply database migrations to Aurora in CI/CD deployment workflows?

Apply database migrations to Aurora in CI/CD workflows by following deployment best practices. This ensures schema changes are safely executed against your provisioned clusters or serverless instances without disrupting active traffic.

How do I monitor Aurora performance using CloudWatch and Performance Insights?

Monitor Aurora performance by configuring CloudWatch metrics and enabling Performance Insights. This combination provides visibility into query performance and connection pooling behavior, helping you tune RDS Proxy and identify bottlenecks.