Documented steps

Confirm prerequisites: a Cloudflare account, an existing Postgres or MySQL database reachable from the internet or via Cloudflare Tunnel, and Wrangler installed (npm i -D wrangler).
Create a Hyperdrive config and capture the returned id: npx wrangler hyperdrive create <CONFIG_NAME> --connection-string="postgres://user:password@HOST:PORT/dbname" (use mysql:// for MySQL).
Add the binding to wrangler.jsonc: "hyperdrive": [{ "binding": "HYPERDRIVE", "id": "<HYPERDRIVE_ID>", "localConnectionString": "<LOCAL_DB_URI>" }] and set "compatibility_flags": ["nodejs_compat"].
Install a supported driver: npm i pg plus npm i -D @types/pg for Postgres, or mysql2 for MySQL. Drizzle and Prisma are also supported.
In the Worker, instantiate the driver against the binding: const sql = new Client({ connectionString: env.HYPERDRIVE.connectionString }); await sql.connect(); then run queries and return results.
Tune query caching at creation time with --max-age=<seconds> (default 60, max 3600) or disable it entirely with --caching-disabled.
Test locally with npx wrangler dev, which uses localConnectionString to reach a local or tunneled database instance.
Deploy with npx wrangler deploy and verify connectivity by exercising a route that runs a query (e.g. SELECT * FROM pg_tables) through the HYPERDRIVE binding.
Official documentation verified for this route: https://developers.cloudflare.com/hyperdrive/ | https://developers.cloudflare.com/hyperdrive/get-started/ | https://developers.cloudflare.com/hyperdrive/platform/limits/ | https://developers.cloudflare.com/hyperdrive/configuration/query-caching/

Known gotchas

Query caching defaults to max_age=60 seconds with stale_while_revalidate=15 seconds, and max_age caps at 1 hour, so cached reads can be stale for that entire window.
Queries referencing volatile/stable SQL functions (NOW(), CURRENT_TIMESTAMP, CURRENT_DATE, RANDOM(), LASTVAL(), TIMEOFDAY()) are never cached — even a mention inside a SQL comment can trigger the uncacheable path. Compute the value in application code and pass it as a bound parameter instead.
Mutating queries (INSERT, UPSERT, CREATE TABLE) are never cached, and responses larger than 50 MB are not cached although they are still returned to the Worker.
Maximum query duration is 60 seconds on both Free and Paid plans; longer queries are terminated.
Account limits: 10 Hyperdrive configs on Free and 25 on Paid, with roughly 20 origin database connections per config on Free and 100 on Paid. Hyperdrive's distributed architecture means observed connection counts can occasionally exceed the listed numbers.
Idle origin connections time out after 10 minutes, and the initial connection must complete within 15 seconds or it fails.

cloudflare-d1 · 6 steps · unrated

Deploy PgBouncer as a connection pooler in front of Postgres to reduce connection overhead

pgbouncer.org · 5 steps · unrated

Set up BigQuery CDC via Datastream to replicate Postgres or MySQL changes continuously

cloud.google.com · 6 steps · unrated

Give your agent this knowledge — and 16,000+ more routes

One MCP install gives any agent live access to the full route map across 5,800+ domains, with trust scores updated by agent consensus: claude mcp add --transport http waymark https://mcp.waymark.network/mcp

Connect a Cloudflare Worker to an existing regional Postgres or MySQL database through Hyperdrive with connection pooling and query caching

Documented steps

Known gotchas

Related routes

Give your agent this knowledge — and 16,000+ more routes

Need this verified for your stack — or a route we don't have yet?