Skip to main content

Documentation Index

Fetch the complete documentation index at: https://docs.tablepro.app/llms.txt

Use this file to discover all available pages before exploring further.

​
Cloudflare D1 Connections

TablePro supports Cloudflare D1, a serverless SQLite-compatible database. TablePro connects via the Cloudflare REST API using your API token - no direct database connections or SSH tunnels needed.

​
Install Plugin

The Cloudflare D1 driver is available as a downloadable plugin. When you select Cloudflare D1 in the connection form, TablePro will prompt you to install it automatically. You can also install it manually:
  1. Open Settings > Plugins > Browse
  2. Find Cloudflare D1 Driver and click Install
  3. The plugin downloads and loads immediately - no restart needed

​
Quick Setup

1

Open Connection Form

Click New Connection from the Welcome screen or File > New Connection
2

Select Cloudflare D1

Choose Cloudflare D1 from the database type selector
3

Enter Connection Details

Fill in your database name (or UUID), Cloudflare Account ID, and API token
4

Test and Connect

Click Test Connection, then Create

​
Connection Settings

​
Required Fields

FieldDescription
NameConnection identifier
DatabaseD1 database name or UUID
Account IDYour Cloudflare account ID
API TokenCloudflare API token with D1 permissions
You can use either the database name (e.g., my-app-db) or the database UUID. If you use a name, TablePro resolves it to the UUID automatically via the Cloudflare API.

​
Getting Your Credentials

​
Account ID

Find your Account ID on the Cloudflare dashboard right sidebar, or run: 
npx wrangler whoami

​
API Token

  1. Go to Cloudflare API Tokens
  2. Click Create Token
  3. Select Custom token template
  4. Add permission: Account > D1 > Edit
  5. Save and copy the token
Store your API token securely. TablePro saves it in the macOS Keychain, but the token grants access to all D1 databases in your account.

​
Create a D1 Database

Create databases with wrangler d1 create my-app-db or from TablePro’s Create Database button.

​
Example Configuration

Name:       My D1 Database
Database:   my-app-db
Account ID: abc123def456
API Token:  (your Cloudflare API token)

​
Features

​
Database Browsing

After connecting, use the database switcher in the toolbar to list and switch between all D1 databases in your Cloudflare account. The sidebar shows tables and views in the selected database.

​
Table Browsing

For each table, TablePro shows:
  • Structure: Columns with SQLite data types, nullability, default values, and primary key info
  • Indexes: B-tree indexes with column details
  • Foreign Keys: Foreign key constraints with referenced tables
  • DDL: The full CREATE TABLE statement

​
Query Editor

Write and execute SQL queries using SQLite syntax: 
-- Query data
SELECT name, email FROM users WHERE id > 10 ORDER BY name;

-- Create tables
CREATE TABLE posts (
    id INTEGER PRIMARY KEY AUTOINCREMENT,
    user_id INTEGER REFERENCES users(id),
    title TEXT NOT NULL,
    content TEXT,
    created_at DATETIME DEFAULT CURRENT_TIMESTAMP
);

-- Aggregations
SELECT user_id, COUNT(*) as post_count
FROM posts
GROUP BY user_id
HAVING post_count > 5;

​
EXPLAIN Query Plan

Analyze query execution plans using the Explain button in the query editor. TablePro uses EXPLAIN QUERY PLAN to show how SQLite processes your queries.

​
Data Editing

Edit cell values, insert rows, and delete rows directly in the data grid. Changes are submitted as standard INSERT, UPDATE, and DELETE statements via the D1 API.

​
Database Management

  • List Databases: View all D1 databases in your Cloudflare account
  • Switch Database: Switch between databases without reconnecting
  • Create Database: Create new D1 databases directly from TablePro

​
Export

Export query results or table data to CSV, JSON, SQL, and other formats.

​
SQL Dialect

D1 uses SQLite syntax. See SQLite for details.

​
Troubleshooting

​
Authentication Failed

Symptoms: “Authentication failed. Check your API token and Account ID.” Solutions:
  1. Verify your API token has D1 Edit permissions
  2. Check that the Account ID matches your Cloudflare account
  3. Ensure the token has not expired or been revoked
  4. Try creating a new API token

​
Database Not Found

Symptoms: “Database ‘name’ not found in account” Solutions:
  1. Verify the database name or UUID is correct
  2. Check that the database exists: wrangler d1 list
  3. Ensure your API token has access to the account containing the database

​
Rate Limited

Symptoms: “Rate limited by Cloudflare” Solutions:
  1. Wait for the retry period indicated in the error message
  2. Reduce query frequency
  3. Use pagination for large result sets instead of fetching all rows

​
Connection Timeout

Symptoms: Queries take too long or time out Solutions:
  1. Check your internet connection
  2. Verify the Cloudflare API is operational at Cloudflare Status
  3. Simplify complex queries that may exceed D1’s execution limits

​
Known Limitations

  • No persistent connections: each query is an independent HTTP request with no session state
  • No multi-statement transactions: each SQL statement auto-commits independently
  • No schema editing UI: use SQL in the query editor for ALTER TABLE
  • 10 GB database limit per D1 database. Shard for larger datasets
  • API rate limits apply. TablePro shows rate limit errors with retry timing
  • No bulk import through the plugin: use wrangler d1 execute with SQL files
  • No custom SSL/SSH: D1 is HTTPS-only via Cloudflare API