Readyset is a transparent caching proxy for PostgreSQL and MySQL that sits between an application and its database, intercepting SQL queries and serving cached results from memory. It automatically caches query results on first execution and keeps those caches consistent by consuming the database’s replication stream in real time, enabling faster repeated reads without application code changes. The proxy also supports caching advanced SQL functions such as window functions, bucket functions, and locale-aware collation sorting, and exposes an interface that allows AI agents to inspect proxied queries and dynamically create or drop caches.
What distinguishes Readyset is its real-time cache synchronization via change-data-capture, combined with high-availability support through global transaction identifiers (GTIDs) to maintain consistency during database failovers. Developers can embed SQL comment hints to control caching behavior on a per-query basis, and a CLI tool allows diagnosing SQL workload performance before production deployment. The proxy also features agent-oriented cache management, where AI agents can programmatically inspect workloads and adjust caching strategies.
Beyond its core identity, Readyset offers a range of operational capabilities: it can be deployed as a transparent proxy without modifying application code, installed as a binary or packaged as systemd services for x86-64 and ARM64, and integrated with existing connection poolers and cloud platforms. Monitoring features list all cached SQL queries and their status, while cache management is also available through custom SQL commands to create, show, or remove cached queries.
Installation options include a downloadable binary, deb and rpm packages for systemd service deployment, and setup that does not require changes to application code or ORM layers.