Limits
| Feature | Limit |
|---|---|
| Databases | 10 per account 1 |
| Database size | 500 MB new storage subsystem - 100 MB (legacy alpha backend) 2 |
| Time Travel duration (point-in-time recovery) | 30 days (Workers Paid) / 7 days (Free) |
| Maximum Time Travel restore operations | 10 restores per 10 minute (per database) |
| Queries per Worker invocation (see subrequest limits) | 50 (Bundled) / 1000 (Unbound) |
| Maximum database backups | 24 hours (backups are hourly) (alpha only) |
| Maximum number of columns per table | 100 |
| Maximum number of rows per table | Unlimited (excluding per-database storage limits) |
Maximum string, BLOB or table row size |
1,000,000 bytes (1MB) |
| Maximum SQL statement length | 100,000 bytes (100KB) |
| Maximum bound parameters per query | 100 |
| Maximum arguments per SQL function | 32 |
Maximum characters (bytes) in a LIKE or GLOB pattern |
50 bytes |
1 Request adjustments to limits that conflict with your project goals by contacting Cloudflare. To make a request, complete the Limit Increase Request Form, or speak to your account team. Note that not all limits can be increased.
2 This is an alpha-only limit, and we intend to increase this as D1 moves towards General Availability (GA).