Document history for the Amazon Aurora DSQL User Guide
The following table describes the documentation releases for Aurora DSQL.
| Change | Description | Date |
|---|---|---|
New content: extended statistics commands | Added documentation for the | August 27, 2026 |
Updated content: Compression for character data types | Aurora DSQL now compresses large values in | August 26, 2026 |
New content: foreign key constraints | Added documentation for foreign key constraints in Aurora DSQL. You can define foreign key constraints when
you create a table, or add them to an existing table with | August 26, 2026 |
New content: Drizzle ORM adapter | Added support for Drizzle ORM, a TypeScript object-relational mapping (ORM) framework for Node.js. With the Aurora DSQL Adapter for Drizzle ORM, you can use Drizzle ORM with Aurora DSQL clusters. For more information, see Aurora DSQL adapters and dialects. | August 26, 2026 |
Updated numeric data type precision and scale limits | Updated precision and scale limits for | August 25, 2026 |
New content: SELECT FOR KEY SHARE and concurrency control | Added documentation for the | August 25, 2026 |
Updated SELECT FOR UPDATE documentation | The | August 24, 2026 |
Updated SQL reference | Updated the supported SQL overview to include | August 20, 2026 |
New content: Monitoring Aurora DSQL clusters with Aurora DSQL Database Insights | Added documentation for Aurora DSQL database insights, which samples active sessions on Aurora DSQL cluster to help customers understand database load by wait event and SQL statement, and describes how to access this data through Amazon CloudWatch Database Insights and Prometheus Query Language (PromQL). Added troubleshooting guidance for clusters that don't appear in the CloudWatch Database Insights console. For more information, see Monitoring Aurora DSQL clusters with Aurora DSQL Database Insights and Troubleshooting missing metrics from the Amazon CloudWatch Database Insights console. | August 17, 2026 |
Updated content: Reorganized CREATE INDEX documentation | Moved the | August 13, 2026 |
New content: Indexes on expressions | Added documentation for indexes on expressions. An index key can be an expression computed from one or more columns of the table row, such as | August 13, 2026 |
New content: ALTER TABLE DROP COLUMN | Added documentation for | August 3, 2026 |
New content: ALTER TABLE ADD CONSTRAINT and VALIDATE CONSTRAINT | Added support for | August 3, 2026 |
Updated content: CDC streams generally available | CDC streams are now generally available. This release adds distinct | July 1, 2026 |
New content: JSONB data type | Added documentation for the | June 5, 2026 |
New content: Change data capture (CDC) streams | Added documentation for Aurora DSQL change data capture (CDC) streams, which capture committed row-level changes and deliver them to Amazon Kinesis Data Streams. For more information, see Change data capture (CDC) streams. | May 13, 2026 |
New content: STORAGE keyword support in CREATE TABLE and ALTER TABLE | Added documentation for the | May 1, 2026 |
New content: JSON data type | Added documentation for the | May 1, 2026 |
New content: ALTER TABLE ADD CONSTRAINT USING INDEX | Added documentation for | April 20, 2026 |
New content: Aurora DSQL Connector for PHP PDO_PGSQL | Added documentation for the Aurora DSQL Connector for PHP | April 10, 2026 |
New content: Aurora DSQL Connector for Rust SQLx | Added documentation for the Aurora DSQL Connector for Rust | March 27, 2026 |
New content: Aurora DSQL Connector for .NET Npgsql | Added documentation for the Aurora DSQL Connector for .NET Npgsql, which wraps Npgsql with automatic IAM authentication. The connector handles token generation, SSL configuration, and connection management for .NET applications. For more information, see Connecting to Aurora DSQL clusters with a .NET Npgsql connector. | March 20, 2026 |
Updated content: SQL command reference and system queries | Added START TRANSACTION and ROLLBACK to the transaction control commands reference, with END and ABORT as aliases. Added useful system queries for retrieving Aurora DSQL and PostgreSQL version information. For more information, see PostgreSQL compatibility reference. | March 13, 2026 |
Updated content: Loading data into Aurora DSQL | Updated the data loading guide with client-side | March 13, 2026 |
New content: Aurora DSQL Connector for Ruby pg | Added documentation for the Aurora DSQL Connector for Ruby pg, which wraps the pg gem with automatic IAM authentication. The connector handles token generation, SSL configuration, and connection management for Ruby applications. For more information, see Connecting to Aurora DSQL clusters with a Ruby pg connector. | March 12, 2026 |
Updated content: Asynchronous DDL jobs | Updated the | March 6, 2026 |
Updated content: PHP authentication token generation | Added a PHP SDK tab to the authentication token generation page. For more information, see Generating authentication tokens. | March 5, 2026 |
New content: Loading data into Aurora DSQL | Added a guide for loading data into Aurora DSQL clusters, including usage of the Aurora DSQL loader utility. For more information, see Loading data into Aurora DSQL. | March 5, 2026 |
New content: Sequences and identity columns | Added support for sequences and identity columns. New SQL command reference pages for CREATE SEQUENCE, ALTER SEQUENCE, DROP SEQUENCE, and sequence manipulation functions. Updated CREATE TABLE and ALTER TABLE to include identity column syntax. Added a new guide for choosing identifier types and cache sizes. For more information, see Sequences and identity columns. | February 11, 2026 |
New content: Aurora DSQL Connector for Go | Added documentation for the Aurora DSQL Connector for Go, which wraps pgx with automatic IAM authentication. The connector handles token generation, SSL configuration, and connection management for Go applications. For more information, see Connecting to Aurora DSQL clusters with a Go connector. | February 5, 2026 |
Updated content: Amazon Aurora DSQL cluster connectivity tools | Reorganized the cluster connectivity tools documentation to clarify the distinction between AWS-provided connectors, adapters, and third-party tools. Added missing links to code samples. For more information, see Amazon Aurora DSQL cluster connectivity tools. | January 26, 2026 |
New content: Aurora DSQL Plugin for DBeaver Community Edition | Added documentation for the Aurora DSQL Plugin for DBeaver Community Edition, which enables IAM authentication and simplified connection setup for Aurora DSQL clusters. Includes installation instructions, connection configuration, and troubleshooting guidance. For more information, see Use DBeaver to access Aurora DSQL. | January 26, 2026 |
New content: Aurora DSQL Driver for SQLTools | Added documentation for the Aurora DSQL Driver for SQLTools, a Visual Studio Code extension that enables developers to connect to and query Aurora DSQL databases directly from VS Code with automatic IAM authentication. For more information, see Use Aurora DSQL driver for SQLTools. | January 26, 2026 |
Updated content: Aurora DSQL Steering: Skills and Powers | Added documentation to support installation using the Skills CLI for agent-agnostic support. The Skills CLI provides a simplified setup method that works across multiple AI coding assistants including Claude Code, Cursor, Copilot, Gemini, and others. For more information, see Aurora DSQL Steering: Skills and Powers. | January 23, 2026 |
New content: Aurora DSQL Adapter for Tortoise ORM | Added support for Tortoise ORM, a Python async ORM framework. The Aurora DSQL Adapter for Tortoise ORM enables developers to use Tortoise ORM with Aurora DSQL clusters. For more information, see Aurora DSQL adapters and dialects. | January 23, 2026 |
New content: Aurora DSQL Steering: Skills and Powers | Added new documentation for configuring AI steering with Aurora DSQL using skills and powers. Includes setup instructions for Kiro Powers, Claude Skills, Gemini Skills, and Codex Skills. For more information, see Aurora DSQL Steering: Skills and Powers. | January 16, 2026 |
Numeric data type index support | Added index support for the | January 13, 2026 |
Updated content: Supported subsets of SQL commands | Reorganized SQL command documentation into separate pages for improved navigation and clarity. Each command (CREATE TABLE, ALTER TABLE, CREATE VIEW, ALTER VIEW, DROP VIEW) now has its own dedicated page. For more information, see Supported subsets of SQL commands. | January 6, 2026 |
Updated content: AWS Labs Aurora DSQL MCP Server | Updated the MCP Server documentation with detailed installation approaches for Claude Code and Codex, including CLI-based setup and configuration file examples. Added comprehensive guidance for finding MCP client configuration files across different development tools. For more information, see AWS Labs Aurora DSQL MCP Server. | December 19, 2025 |
Updated content: Migrating from PostgreSQL to Aurora DSQL | Redrafted the PostgreSQL compatibility section as a comprehensive migration guide. Includes framework compatibility information, common migration patterns, architectural differences, and AI-assisted migration guidance. Added new chapter for providing feedback on Aurora DSQL. For more information, see Migrating from PostgreSQL to Aurora DSQL. | December 16, 2025 |
Updated content: Connecting to Aurora DSQL using AWS PrivateLink | Added documentation for private DNS setup and the cluster ID connection option to support customers using AWS PrivateLink with Direct Connect or Amazon VPC peering. Includes guidance for connecting without private DNS using the | December 11, 2025 |
Updated content: Aurora DSQL cluster lifecycle | Updated documentation for Aurora DSQL cluster lifecycle management. Explains cluster status definitions, state transitions, and operations available during Idle and Inactive states. For more information, see Aurora DSQL cluster lifecycle. | December 4, 2025 |
New content: Aurora DSQL connectors for Python and Node.js | Added documentation for Aurora DSQL connectors for Python (psycopg, psycopg2, asyncpg) and Node.js (node-postgres, Postgres.js). These connectors integrate IAM authentication for connecting applications to Aurora DSQL clusters. For more information, see Aurora DSQL connectors. | November 21, 2025 |
New content: Using JupyterLab with Aurora DSQL | Added step-by-step guide for connecting and querying Aurora DSQL using JupyterLab with Python. Includes instructions for both local JupyterLab installations and Amazon SageMaker AI environments. For more information, see Using JupyterLab with Aurora DSQL. | November 20, 2025 |
Updated content: Quotas for Aurora DSQL | Updated maximum cluster storage quota from 128 TiB to 256 TiB. For more information, see Quotas for Aurora DSQL. | November 19, 2025 |
New content: Getting started with the Aurora DSQL Query Editor | Added documentation for using the Aurora DSQL Query Editor in the AWS Management Console. Includes prerequisites, connection setup, and query execution instructions. For more information, see Getting started with the Aurora DSQL Query Editor. | November 18, 2025 |
Resource-based policy support for Amazon Aurora DSQL | Added resource-based policy (RBP) support with new permissions: | October 15, 2025 |
Aurora DSQL JDBC Connector | Added documentation for the Aurora DSQL JDBC Connector, a PgJDBC connector that integrates IAM Authentication for connecting Java applications to Amazon Aurora DSQL clusters. For more information, see Connecting to Aurora DSQL clusters with a JDBC connector. | September 2, 2025 |
AWS managed policy updates for AWS FIS integration | Updated | August 19, 2025 |
General availability (GA) of Amazon Aurora DSQL | Amazon Aurora DSQL is now generally available with added support for CloudWatch monitoring, enhanced data protection features, and AWS Backup integration. For more information, see Monitoring Aurora DSQL with CloudWatch, Backup and restore for Amazon Aurora DSQL, and Data encryption for Amazon Aurora DSQL. | May 27, 2025 |
AmazonAuroraDSQLFullAccess update | Adds the capability to perform backup and restore operations for Aurora DSQL clusters, including starting, stopping, and monitoring jobs. It also adds the capability to use customer-managed KMS keys for cluster encryption. For more information, see AmazonAuroraDSQLFullAccess and Using service-linked roles in Aurora DSQL . | May 21, 2025 |
AmazonAuroraDSQLConsoleFullAccess update | Adds the capability to perform backup and restore operations for Aurora DSQL clusters through the AWS Console Home. This includes starting, stopping, and monitoring jobs. It also supports using customer-managed KMS keys for cluster encryption and launching AWS CloudShell. For more information, see AmazonAuroraDSQLConsoleFullAccess and Using service-linked roles in Aurora DSQL. | May 21, 2025 |
AmazonAuroraDSQLReadOnlyAccess update | Includes the ability to determine the correct VPC endpoint service name when connecting to your Aurora DSQL clusters through AWS PrivateLink Aurora DSQL creates unique endpoints per cell, so this API helps ensure you can identify the correct endpoint for your cluster and avoid connection errors. For more information, see AmazonAuroraDSQLReadOnlyAccess and Using service-linked roles in Aurora DSQL . | May 13, 2025 |
AmazonAuroraDSQLFullAccess update | The policy adds four new permissions to create and manage database clusters across
multiple AWS Regions: | May 13, 2025 |
AmazonAuroraDSQLConsoleFullAccess update | Adds new permissions to Aurora DSQL to support multi-Region cluster management and VPC
endpoint connection. The new permissions include: | May 13, 2025 |
AuroraDsqlServiceLinkedRolePolicy update | Adds the ability to publish metrics to the | May 8, 2025 |
AWS PrivateLink for Amazon Aurora DSQL | Aurora DSQL now supports AWS PrivateLink. With AWS PrivateLink, you can simplify private network connectivity between virtual private clouds (VPCs), Aurora DSQL, and your on-premises data centers using interface Amazon VPC endpoints and private IP addresses. For more information, see Managing and connecting to Amazon Aurora DSQL clusters using AWS PrivateLink. | May 8, 2025 |
Initial release | Initial release of the Amazon Aurora DSQL User Guide. | December 3, 2024 |
