Amazon Aurora DSQL supports PostgreSQL JSON data type with compression

Aurora Distributed SQL added PostgreSQL-compatible JSON data type support with built-in compression to efficiently store semi-structured data.

By Clara Morgan · Editorial pseudonym · 2026-05-04 · 1 min read

AI-ASSISTED REPORTING · RETROSPECTIVE ARCHIVE

Retrospective edition: 2026-05-04. Source published: 2026-05-04. Added to this archive: 2026-11-03. This briefing was prepared later from the linked announcement; it was not published on this website on the historical edition date.

With this update, Aurora DSQL allows users to create or modify tables using the PostgreSQL JSON data type, facilitating native handling of semi-structured data like API payloads and event logs alongside relational data. The JSON data type support maintains compatibility with PostgreSQL tools and code without modification.

Compression for larger JSON payloads is enabled by default, reducing storage costs by storing data more efficiently. This enhancement simplifies development workflows and offers cost savings in managing diverse data formats within Aurora DSQL clusters, available with the AWS Free Tier across supported regions.

Source & further reading

Amazon Aurora DSQL now supports the JSON data type with compression ↗

Source published 2026-05-04. This report was prepared with AI assistance from the linked primary-source material. Claims and limitations should be checked against the original announcement or research.