AWS Database Blog

Announcing strands-dynamodb-storage, an open source Amazon DynamoDB storage backend for the Strands Agents SDK. Back a Strands agent’s session state, long-term memories, and transcripts with one DynamoDB table in your own account, and give the agent semantic recall with a vector index on that same table.

Learn how to use AI agents with AWS DMS Schema Conversion to orchestrate SQL Server to Amazon Aurora PostgreSQL schema conversion through natural language. See how the conversion engine processes T-SQL, how the agent drives the workflow, and how to interpret and resolve CRITICAL action items using decision frameworks for common incompatibilities.

Circular role dependencies can stall or roll back a major version upgrade of Amazon RDS for PostgreSQL or Amazon Aurora PostgreSQL when you move from PostgreSQL 14 or earlier to 15 or later. Learn why this happens, how to detect it with a single pre-upgrade query, and how to clear it before you upgrade.

Learn how to provision a secure Amazon DocumentDB cluster using Terraform. This post applies infrastructure-as-code best practices with encryption, AWS Secrets Manager authentication, network isolation, and encrypted monitoring.

How CORTO scaled Amazon Aurora PostgreSQL with pgvector to 7.6 billion vectors and 2.5 billion documents in production, delivering sub-second legal search for 10,000+ law firms at 75% lower storage cost.

Channel Corporation shares how they split their all-purpose Amazon DynamoDB User table into role-specific tables, moving Badge data into a dedicated UserBadge table to stop transaction-conflict throttling and GSI back pressure, and how they ran a zero-downtime online migration using DynamoDB Export and Import with Amazon S3 and AWS Glue.

If you need cross-database access on Amazon RDS for SQL Server but cannot enable TRUSTWORTHY, module signing with certificates is the secure, RDS-compatible alternative. This post shows how to grant cross-database permissions to specific stored procedures without TRUSTWORTHY and with a stronger, least-privilege security posture.

Migrating full-text search from SQL Server to PostgreSQL can silently change results because the engines handle text, linguistics, and accents differently. This post shows how to reproduce SQL Server full-text search on Amazon Aurora PostgreSQL and Amazon RDS for PostgreSQL, covering collation, tokenization, accent-insensitive search, and synonyms.

PostgreSQL out-of-memory (OOM) events and excessive disk spilling are among the most common production incidents on Amazon RDS for PostgreSQL and Amazon Aurora PostgreSQL. Learn how PostgreSQL allocates and consumes memory, how to identify memory-intensive queries, and how to diagnose, prevent, and recover from OOM events on both engines.

Oracle Database@AWS places Oracle Exadata infrastructure inside AWS data centers, so SQL*Net latency between your application and the database can change after migration. This post presents the CRET methodology, a three-phase approach using AWR, Active Session History, and SQL Trace, to identify latency-sensitive SQL and quantify the impact before you migrate.