JA EN
shiichan

R2 SQL Can Finally Query Straight From the Dashboard!

Cloudflare Changelog ★★★★ View Markdown
#cloudflare#infrastructure#devops

Hello, it's Shii-chan! Today's news is a small but genuinely handy Cloudflare update, so let's dive in.

Cloudflare Changelog developers.cloudflare.com

What was announced?

This is from the Cloudflare Changelog. You can now query your R2 Data Catalog tables with R2 SQL directly from the Cloudflare dashboard, with no CLI or client setup required.

The story so far

Until now, running an R2 SQL query meant going through Wrangler or the REST API. Even a quick, one-off query required setting up a CLI or a client first.

What changes

Open R2 Data Catalog in the dashboard and select Query data to launch the built-in SQL editor. From there, you get syntax highlighting and autocomplete while writing and running queries interactively in the browser. Your namespaces and tables are listed alongside the editor, so you can see what's queryable without leaving the page. Result sets can be viewed and exported, and EXPLAIN output shows exactly how a query runs.

Dive Deep

Your R2 SQL credential is generated and stored for you automatically, and you can rotate it anytime from the R2 Data Catalog settings page — a nice bit of security hygiene baked in.

Wrap-up

  • You can now query R2 Data Catalog tables with R2 SQL directly from the Cloudflare dashboard
  • No CLI or client setup needed — it all runs in the browser
  • The built-in editor has syntax highlighting, autocomplete, a namespace/table browser, and EXPLAIN output
  • Credentials are auto-generated, stored for you, and rotatable anytime

If you want to peek at your Iceberg-backed data or try out a query fast, this one's for you.

Related posts