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
Decision gist · record as of 2026-06-22
AWS RDS Spring Boot Integration configures Aurora, MySQL, and PostgreSQL databases with Spring Boot using HikariCP pooling and Secrets Manager. 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.
Use it when
- aws-rds-spring-boot-integration uses HikariCP as the default connection pooling library for RDS workloads.
- aws-rds-spring-boot-integration enables read/write splitting with Aurora replicas through datasource routing.
Verify before relying
Read SKILL.md below before installing (3 files). Open directory: indexed for reading, not audited.
Install
giuseppe-trisciuoglio/developer-kit/aws-rds-spring-boot-integration · repository language: Python
Open directory. Skills are indexed for reading, not audited. Review a skill's body before installing it.
Frequently 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)
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
Let your AI agent find skills like this
Example. Real query, live index.
You found this page by searching. An agent finds it by wishing: SkillFed indexes 56,283 agent skills by what they can do, searchable in plain language.
wish › “Set up AWS RDS database connections in Spring Boot applications”
Give your agent the search over MCP, or paste the wish link into any chat. No install? Search from any chat →
Related skills
Master enterprise Spring Boot development with guides covering project setup, entity models, repositories, service layers, REST controllers, and security. Learn proper patterns for dependency injection, data persistence, and API design while following Spring conventions and best practices.
Python Micrometer Metrics Setup guides you through establishing metrics infrastructure in Python services, covering dependency configuration, Actuator endpoint exposure, and backend selection. Learn to enable auto-configured metrics and prepare your application for observability.
Automates Spring Boot project initialization by downloading from Spring Initializr and generating a complete project structure with your chosen architecture pattern (DDD or Layered), pre-configured JPA, SpringDoc OpenAPI, and Docker Compose services for PostgreSQL, Redis, or MongoDB. Handles dependency management, application properties, and local development setup in one workflow.
Master JPA entity modeling, repository implementation, and performance tuning for Spring Boot applications. Learn to configure relationships, prevent N+1 query issues through fetch strategies and projections, set up transactional boundaries, and optimize database connections with HikariCP.
Implement stateless JWT authentication in Spring Boot 3.5 applications with Spring Security 6.x and JJWT 0.12.6. This skill covers token generation and validation, Bearer and HttpOnly cookie strategies, refresh token rotation, role and permission-based access control, and OAuth2 provider integration. Use it to secure REST APIs with method-level authorization rules and token revocation patterns.
Spring Boot Engineer scaffolds production-grade Spring Boot 3.x applications with REST controllers, service layers, Spring Data JPA repositories, and Spring Security 6 authentication. It guides you through architecture design, layered implementation with constructor injection, security hardening, and test-driven validation before deployment.
More skills spring-boot-actuator (MIT)