All skills
Skillintermediate

Hyperdrive

Accelerates database queries from Workers via connection pooling, edge setup, query caching.

Claude Code Knowledge Pack7/10/2026

Overview

Hyperdrive

Accelerates database queries from Workers via connection pooling, edge setup, query caching.

Key Features

  • Connection Pooling: Persistent connections eliminate TCP/TLS/auth handshakes (~7 round-trips)
  • Edge Setup: Connection negotiation at edge, pooling near origin
  • Query Caching: Auto-cache non-mutating queries (default 60s TTL)
  • Support: PostgreSQL, MySQL + compatibles (CockroachDB, Timescale, PlanetScale, Neon, Supabase)

Architecture

Worker → Edge (setup) → Pool (near DB) → Origin
         ↓ cached reads
         Cache

Quick Start

# Create config
npx wrangler hyperdrive create my-db \\
  --connection-string="postgres://user:pass@host:5432/db"

# wrangler.jsonc
{
  "compatibility_flags": ["nodejs_compat"],
  "hyperdrive": [{"binding": "HYPERDRIVE", "id": ""}]
}

  async fetch(req: Request, env: Env): Promise {
    const client = new Client({
      connectionString: env.HYPERDRIVE.connectionString,
    });
    await client.connect();
    const result = await client.query("SELECT * FROM users WHERE id = $1", [123]);
    await client.end();
    return Response.json(result.rows);
  },
};

When to Use

✅ Global access to single-region DBs, high read ratios, popular queries, connection-heavy loads ❌ Write-heavy, real-time data (<1s), single-region apps close to DB

💡 Pair with Smart Placement for Workers making multiple queries - executes near DB to minimize latency.

Driver Choice

DriverUse WhenNotes
pg (recommended)General use, TypeScript, ecosystem compatibilityStable, widely used, works with most ORMs
postgres.jsAdvanced features, template literals, streamingLighter than pg, prepare: true is default
mysql2MySQL/MariaDB/PlanetScaleMySQL only, less mature support

Reading Order

New to HyperdriveImplementingTroubleshooting
1. README (this)1. configuration.md1. gotchas.md
2. configuration.md2. api.md2. patterns.md
3. api.md3. patterns.md3. api.md

In This Reference

  • configuration.md - Setup, wrangler config, Smart Placement
  • api.md - Binding APIs, query patterns, driver usage
  • patterns.md - Use cases, ORMs, multi-query optimization
  • gotchas.md - Limits, troubleshooting, connection management

See Also

  • smart-placement - Optimize multi-query Workers near databases
  • d1 - Serverless SQLite alternative for edge-native apps
  • workers - Worker runtime with database bindings