PostgreSQL 19 Beta 1 lands in Amazon RDS Preview with native graph queries

AWS made PostgreSQL 19 Beta 1 available in the Amazon RDS Database Preview Environment, allowing developers to test the upcoming major release with managed-database conveniences before general availability. The headline feature is native graph query support via SQL Property Graph Queries (SQL/PGQ), bringing graph-style traversals into standard PostgreSQL without bolt-on extensions.

Native SQL/PGQ is significant because graph workloads — fraud detection, recommendation, knowledge graphs, and increasingly AI retrieval/grounding — have typically required separate graph databases (Neo4j, Amazon Neptune) or extensions. Folding property-graph queries into core PostgreSQL lets teams keep relational and graph data in one engine, simplifying architecture.

The RDS preview environment is purpose-built for evaluating pre-GA Postgres versions without provisioning self-managed instances, lowering the barrier for early testing and feedback to the PostgreSQL community.

This is part of AWS's broader June database push, which also included Aurora DSQL adding JSONB with compression and RDS for Db2 12.1 with a Community Edition. For AI builders, graph queries plus JSONB strengthen Postgres as a one-stop store for semi-structured and relationship-rich data feeding RAG pipelines. Caveat: this is a beta in a preview environment — not for production — and SQL/PGQ adoption will depend on tooling and ORM support maturing. Watch for the PostgreSQL 19 GA timeline.