How to Browse and Query Your D1 Database Visually

Cloudflare D1 is a great database. The tooling for interacting with it? Not so great. The dashboard gives you a basic query console. The CLI gives you raw JSON. Neither lets you comfortably browse your data the way you'd expect from a database client in 2026.

Cloudflare D1 deserves better tooling than a terminal and a bare-bones console — here's how to get a full visual database client in under two minutes.

Here's how to get a proper visual workflow for your D1 databases using MyD1.

Step 1: Get your Cloudflare credentials

You need two things from your Cloudflare account:

1. Account ID — go to Workers & Pages in the Cloudflare dashboard. Your Account ID is in the right sidebar.
2. API Token — go to My Profile → API Tokens → Create Token. Use the "Edit Cloudflare D1" template, or create a custom token with D1:Edit permissions.

Save both. You'll paste them into MyD1 once.

Step 2: Connect

Open MyD1, click the + button in the sidebar, and choose Cloudflare D1. Paste your Account ID and API Token, then click Connect.

MyD1 calls the Cloudflare D1 API to discover all databases on your account. They appear in the sidebar — click any one to open it.

Step 3: Browse your tables

Once connected, the sidebar shows every table in the selected database. Click a table name to see its contents in the main panel — a scrollable, sortable data grid.

The table view shows:

• All rows with pagination for large tables
• Column headers with data types
• Sortable columns — click a header to sort ascending/descending
• Null values clearly marked

Above the data grid, a schema tab shows the full column definitions: name, type, nullable, default value, primary key, and foreign key references.

Step 4: Run queries

Click the query editor tab (or press ⌘N) to open a blank SQL editor. This isn't a plain text box — it's a full editor with:

• SQLite syntax highlighting
• Auto-completion for table and column names
• Multi-query support (separate statements with semicolons)
• Keyboard shortcut to execute: ⌘Enter

Results appear in a grid below the editor. Each statement's results are shown in separate tabs if you run multiple queries.

Step 5: Edit data inline

In the table view, double-click any cell to edit it. Change the value, press Enter, and MyD1 generates and executes the UPDATE statement automatically. The cell highlights briefly to confirm the write.

This is ideal for fixing data during development — updating a test user's email, correcting a typo, toggling a boolean flag. No need to context-switch to the terminal for simple edits.

Step 6: Export your data

Right-click on a table or query result to export. Supported formats:

• CSV — for spreadsheets and data analysis tools
• JSON — for APIs and programmatic use
• SQL INSERT — for migrating data between databases

Step 7: Ask the AI Agent

MyD1's AI Agent sits beside the query editor. It knows your entire schema — every table, column, type, and relationship — and does more than just write queries. Ask a question in plain English:

"Which users created an account this week but haven't verified their email?"

The AI Agent generates the SQL, you review it, click Run, and see the results. No copy-pasting schema into ChatGPT, no guessing column names. Beyond query generation, the AI Agent can suggest indexes to speed up slow queries, spot performance bottlenecks, and help you discover insights buried in your data. It turns D1 from a database you query into a database you understand.

Works with MySQL, PostgreSQL, and SQLite too

The same workflow applies to MySQL, PostgreSQL, and SQLite connections. Add them in the sidebar, and you can switch between D1, MySQL, Postgres, and SQLite databases with a single click.

Download MyD1 for free and start browsing your D1 databases visually.

Related: Getting Started with D1 · Managing D1 Without the Terminal · D1 vs MySQL vs PostgreSQL