Readyset

ReadySet is a drop-in Postgres/MySQL proxy that caches query results in memory and keeps them consistent with the source database via change data capture — no application code changes required. For agents and backend services: deploy ReadySet between the application and Postgres, point the connection string to ReadySet's port, and cache expensive repeated read queries with a CACHE QUERY command. ReadySet handles cache invalidation automatically when underlying data changes. Primary benefit: sub-millisecond read latency for cached queries vs. 10–100ms direct Postgres queries. Open-source (BSL license). Confidence is docs-derived.

ReadySet is a proxy — no REST API. Integration: change the Postgres connection string to point to ReadySet (default port 5433). ReadySet forwards all queries to Postgres; cacheable queries are identified and cached. Management commands via psql: SHOW PROXIED QUERIES lists all queries seen by ReadySet with cache status (supported/unsupported/cached). CACHE QUERY '<select statement>' adds a query to the cache. DROP CACHE '<query_id>' removes a cached query. SHOW CACHES lists all active caches. ReadySet Cloud: management API and dashboard for cache configuration and monitoring.

No API key for the proxy itself (access controlled by Postgres credentials). ReadySet accepts the same credentials as the underlying Postgres instance. TLS support: configure ReadySet with TLS certificates for encrypted client connections. ReadySet to Postgres replication uses Postgres logical replication (requires wal_level = logical). Replication user requires REPLICATION privilege. ReadySet Cloud: account auth via ReadySet Cloud dashboard; managed replication credentials.

Proxy crash: ReadySet restarts automatically (Kubernetes/Docker); applications reconnect transparently. Cache miss: ReadySet falls through to Postgres (transparent to application). Unsupported queries: proxied to Postgres without caching (no application error). CDC lag: cache consistency depends on replication lag; typically milliseconds behind Postgres. ReadySet Cloud uptime at status.readyset.io. Self-hosted reliability depends on operator's deployment. SHOW PROXIED QUERIES shows which queries are not yet supported for caching (useful for debugging).

docs.readyset.io provides quickstart guide (Docker Compose), caching guide (CACHE QUERY syntax), compatibility reference, and deployment guide (Kubernetes, ReadySet Cloud). Getting started: pull Docker image, set connection string, first cache in under 15 minutes. SHOW PROXIED QUERIES makes it easy to identify what to cache. Open-source (GitHub: readysettech/readyset). Active community via ReadySet Discord and GitHub. BSL license: free to use; commercial redistribution requires agreement.