aws-rds-spring-boot-integration
Connect Aurora, MySQL, or PostgreSQL databases to Spring Boot applications with production-ready patterns for datasource configuration, HikariCP pooling, SSL encryption, and credential management via AWS Secrets Manager. Includes read/write split setup for Aurora replicas, environment-specific profiles, and Flyway migration support.
AWS RDS Spring Boot Integration configures Aurora, MySQL, and PostgreSQL databases with Spring Boot using HikariCP pooling and Secrets Manager.
AI-generated summary based on this skill's SKILL.md
Install
giuseppe-trisciuoglio/developer-kit/aws-rds-spring-boot-integration · repository language: Python
git clone https://github.com/giuseppe-trisciuoglio/developer-kit
cp -r developer-kit/plugins/developer-kit-java/skills/aws-rds-spring-boot-integration ~/.claude/skills/aws-rds-spring-boot-integrationnpx skillfed install giuseppe-trisciuoglio/developer-kit/aws-rds-spring-boot-integrationFrequently asked questions
AI-generated answers based on this skill's SKILL.md and metadata
How do I configure spring boot aws rds configuration?
aws-rds-spring-boot-integration provides production-ready patterns for connecting Aurora, MySQL, or PostgreSQL to Spring Boot. Add spring-boot-starter-data-jpa and the appropriate JDBC driver (mysql-connector-java or postgresql) to your pom.xml. Configure datasource properties in application.yml with RDS endpoint, port, database name, and credentials. Use environment-specific profiles (application-dev.yml, application-prod.yml) to manage different RDS instances across environments.
What is hikaricp connection pool rds and how do I tune it?
aws-rds-spring-boot-integration uses HikariCP as the default connection pooling library for RDS workloads. Configure pool size, connection timeout, and idle timeout via spring.datasource.hikari.* properties. Set maximum-pool-size based on your RDS instance class and application concurrency; typical values range from 5–20. Enable auto-commit settings and test-on-borrow queries to ensure connection health during high load.
How does aws-rds-spring-boot-integration support read/write splitting?
aws-rds-spring-boot-integration enables read/write splitting with Aurora replicas through datasource routing. Configure a primary datasource pointing to the Aurora writer endpoint and read-only datasources pointing to reader endpoints. Use Spring's AbstractRoutingDataSource or a custom routing bean to direct write operations to the primary and read queries to replicas, improving throughput and reducing latency.
How do I enable SSL/TLS and IAM authentication for secure RDS access?
aws-rds-spring-boot-integration supports SSL/TLS by setting spring.datasource.url parameters like ?useSSL=true&serverTimezone=UTC. For IAM authentication, retrieve temporary credentials from AWS Secrets Manager or IAM roles, then configure the datasource with short-lived tokens. Enable ssl-mode=REQUIRE for PostgreSQL or add SSL properties to the JDBC URL for MySQL to enforce encrypted connections.
Can aws-rds-spring-boot-integration manage database migrations?
Yes, aws-rds-spring-boot-integration integrates Flyway for automated schema versioning and migrations. Add spring-boot-starter-flyway to your dependencies and place SQL migration files in src/main/resources/db/migration/. Flyway automatically runs pending migrations on application startup, ensuring schema consistency across RDS instances and environments.
How do I manage RDS credentials securely in Spring Boot?
aws-rds-spring-boot-integration recommends storing RDS credentials in AWS Secrets Manager rather than hardcoding them. Use spring-cloud-starter-aws-secrets-manager to inject secrets into application properties at runtime. Alternatively, attach an IAM role to your EC2 or ECS instance and use temporary credentials; Spring automatically picks up credentials from the instance metadata service.
SKILL.md
rendered from the published skill — quoted content, verbatim
AWS RDS Spring Boot Integration
Overview
Configure AWS RDS databases (Aurora, MySQL, PostgreSQL) with Spring Boot applications. Provides patterns for datasource configuration, HikariCP connection pooling, SSL connections, environment-specific configurations, and AWS Secrets Manager integration.
When to Use
Use when configuring HikariCP connection pools for RDS workloads, implementing read/write split with Aurora replicas, setting up IAM database authentication, enabling SSL/TLS connections, managing database migrations with Flyway, or troubleshooting RDS connectivity issues.
Instructions
Follow these steps to configure AWS RDS with Spring Boot:
- **Add
(truncated - see the full file via the links below)
Read as markdown · JSON record · Browse the source repository
File tree — 3 files
plugins/developer-kit-java/skills/aws-rds-spring-boot-integration/SKILL.md
plugins/developer-kit-java/skills/aws-rds-spring-boot-integration/references/advanced-configuration.md
plugins/developer-kit-java/skills/aws-rds-spring-boot-integration/references/troubleshooting.md