AWS Database Blog
Category: Advanced (300)
Accelerate database modernization with agentic AI in AWS DMS Schema Conversion
Starting today, you can use AI agents to orchestrate entire AWS DMS Schema Conversion (DMS SC) workflows through natural language. An AI agent manages the full lifecycle, including creating migration projects, browsing source metadata, converting schemas, generating assessment reports, and exporting results, all from a conversational prompt.
Diagnose and resolve replica lag in Amazon RDS for Oracle replicas – Part 2
This post is the second in a two-part series on reducing replication lag for Amazon RDS for Oracle Read Replicas. In Part 1, we discussed redo compression and configuration options to optimize replica lag. In this post, we show you how to monitor replica lag using Amazon CloudWatch metrics and database views, identify common root causes through wait event analysis, and how to troubleshoot and resolve performance issues.
Optimize replication lag for Amazon RDS for Oracle replicas using redo compression – Part 1
In part 1 (this post), we show you how to optimize lag for RDS for Oracle replicas using the redo compression feature. In part 2, we discuss various techniques to monitor, troubleshoot, and resolve replication lag for RDS for Oracle replicas.
Fail back from Amazon RDS for Db2 to on-premises AIX Db2 using DMS
In this post, you learn how to set up CDC-only reverse replication from Amazon Relational Database Service (Amazon RDS) for Db2 back to your on-premises AIX Db2 instance using AWS Database Migration Service (AWS DMS).
Automate PostgreSQL audit log extraction and analysis with Amazon S3
In this post, we show you how to deploy an automated pipeline that extracts PostgreSQL audit logs from CloudWatch Logs, converts them into structured comma-separated values (CSV) format, and stores them in Amazon S3 for long-term analysis. The solution processes log entries in near real time after generation.
Data masking in Amazon RDS for Oracle
In this post, we walk through how to use the Oracle Data Masking and Subsetting Pack with Amazon RDS for Oracle. We cover setting up Data Masking in Oracle Enterprise Manager (OEM) and automation options.
Cross-account and cross-Region monitoring for Amazon RDS and Aurora with Database Insights
This post shows you how to set up centralized cross-account and cross-Region monitoring for Amazon Relational Database Service (Amazon RDS) and Amazon Aurora databases using Amazon CloudWatch Database Insights. Whether your databases are spread across two AWS accounts or ten, and across one Region or several, this walkthrough gives you a single monitoring account with visibility across your entire database fleet.
Amazon RDS log analysis: natural language queries with Kiro and MCP
In this post, we demonstrate an approach to review RDS logs using Kiro, an AI-powered conversational assistant combined with the Model Context Protocol (MCP) server from awslabs.cloudwatch-mcp-server. This solution transforms log analysis from a technical, query-based process into a natural language conversation, delivering actionable insights instantly.
Manage long-running transactions for AWS DMS performance
In this post, we show you how long-running transactions affect AWS Database Migration Service (AWS DMS) change data capture (CDC) latency, walk through monitoring approaches for Oracle, PostgreSQL, MySQL, and SQL Server, and provide ready-to-use scripts to identify and resolve problematic transactions before they impact your replication performance.
Building Financial Hierarchies with Amazon Neptune for Treasury Operations
In this post, we show how Amazon’s Finance Technology (FinTech) team uses Amazon Neptune to model complex corporate treasury structures as a property graph. These structures include the legal entity relationships, intercompany agreements, and bank account associations that govern payment routing and cash management.









