Home

D1 Database Manager Wiki

Last Updated January 12, 2026

Welcome to the comprehensive wiki for D1 Database Manager - a modern, full-featured web application for managing Cloudflare D1 databases with enterprise-grade authentication.

🎯 Quick Links

• Live Demo - Try it in action
• GitHub Repository
• Docker Hub
• Support Blog

📚 Wiki Contents

Getting Started

• Installation - Set up D1 Manager locally or in production
• Quick Start Guide - Get up and running in minutes
• Configuration - Environment variables and configuration options
• Authentication Setup - Configure Cloudflare Access (Zero Trust)

Core Features

• Database Management - Create, rename, delete, and manage databases
• R2 Backup Restore - Backup databases to R2 storage and restore from backups
• Scheduled Backups - Automate recurring backups with cron triggers
• Table Operations - Browse, create, modify, and manage tables
• Query Console - Execute SQL queries with advanced features
• Schema Designer - Visual table creation tool
• Column Management - Add, modify, rename, and delete columns
• Bulk Operations - Multi-select operations for databases and tables
• Job History - Track and monitor bulk operations with event timelines
• Time Travel - View bookmarks, checkpoint history, and CLI restore commands
• Read Replication - Enable/disable global read replicas with D1 Sessions API info
• Undo Rollback - Restore dropped tables, columns, or deleted rows

Advanced Features

• Bulk Operations - Multi-select operations for databases and tables
• Row Level Filtering - Type-aware filtering with SQL WHERE clauses
• Foreign Key Visualizer - Interactive graph-based relationship management with visual editing
• ER Diagram - Visual entity-relationship diagram for schema documentation
• Foreign Key Dependencies - Relationship analysis and dependency viewer
• Cascade Impact Simulator - Preview deletion cascades with visual graph
• Index Analyzer - Intelligent index recommendations for optimal performance
• Cross Database Search - Search across multiple databases
• Database Comparison - Compare schemas between databases
• Migration Wizard - Transfer data between databases
• Webhooks - Event-driven HTTP notifications for database events
• Observability - External logging integration (Datadog, Grafana, Sentry)

Development

• Architecture - Technical architecture and design patterns
• API Reference - Complete API endpoint documentation
• Local Development - Development environment setup
• Worker Implementation - Cloudflare Worker backend details
• Frontend Architecture - React app structure and components

Deployment & Operations

• Production Deployment - Deploy to Cloudflare Workers
• Docker Deployment - Run D1 Manager in Docker
• Database Optimization - Indexing, ANALYZE, and performance tuning
• Security Best Practices - Secure your deployment
• Troubleshooting - Common issues and solutions

Reference

• Technology Stack - Complete list of technologies used
• File Structure - Project organization and key files
• Environment Variables - All configuration options
• Changelog - Version history and updates
• Roadmap - Planned features and improvements

Contributing

• Contributing Guide - How to contribute to the project
• Development Workflow - Git workflow and best practices
• Code Style Guide - Coding standards and conventions
• Testing Guide - How to test your changes

🌟 Key Features at a Glance

Database Management

• ✅ Grid/List views with search filters to browse all D1 databases
• ✅ Create, rename, clone, delete, download, and optimize databases; import/paste SQL
• ✅ R2 Backup/Restore + Backup Hub (Workers with R2) - Undo history and R2 backups in one dialog with bulk restore/download/delete and orphaned-backup visibility
• ✅ Scheduled R2 Backups (Workers with cron triggers) - Daily/weekly/monthly schedules with next-run tracking and enable/disable controls
• ✅ Safety Backups (Workers) - Delete and rename operations automatically create R2 backups before proceeding
• ✅ Bulk operations with job history timelines
• ✅ Database comparison, migration tools, color tags, and FTS5 badges

Table Operations

• ✅ Grid/List views for tables with search and row search filters
• ✅ View table schemas with column details
• ✅ Create, rename, delete, and clone tables with bulk export/clone/delete
• ✅ Import/export tables (SQL/CSV/JSON) with duplicate handling and auto-add missing columns
• ✅ Table-level R2 Backup/Restore (Workers with R2) plus undo snapshots for destructive operations (STRICT mode, delete, rename, convert)
• ✅ Table color tags and status badges (STRICT, FTS5)

Advanced Capabilities

• ✅ Unified Backup & Restore Hub (Workers with R2) - Undo history and R2 backups in one dialog with bulk restore/download/delete and orphaned-backup visibility
• ✅ Foreign Key Visualizer & ER Diagram (fullscreen) - Interactive graphs with multi-format export and alphabetized dropdowns
• ✅ Cascade Impact Simulator with optimized dependency checks
• ✅ Time Travel - Database bookmarks, checkpoint history, and CLI restore guidance
• ✅ Read Replication - Enable/disable global read replicas with D1 Sessions API info
• ✅ FTS5 Full-Text Search - Manage virtual tables, convert to/from regular tables, and dedicated FTS5 search mode
• ✅ Index Analyzer with "Create All Indexes" one-click apply
• ✅ Metrics Dashboard - Query volume, latency, rows read, and storage trends
• ✅ Query Console upgrades - SQL Diff, SQL formatter, syntax highlighting, word wrap toggle, inline error squiggles, autocomplete toggle, and Drizzle ORM console (introspect, migrate, push, export)
• ✅ Cross-database search and database comparison

User Experience

• ✅ Dark/Light/System theme support
• ✅ Responsive design (desktop, tablet, mobile)
• ✅ Beautiful UI with shadcn/ui components
• ✅ Keyboard shortcuts
• ✅ Real-time progress tracking

🚀 Version Information

Current Version: 2.4.0
Last Updated: January 12, 2026
Status: Production/Stable

Technology Stack

• Frontend: React 19.2.3, Vite 7.3.1, TypeScript 5.9.3
• UI: Tailwind CSS 4.1.17, shadcn/ui
• Backend: Cloudflare Workers, D1 + R2 + Durable Objects
• Auth: Cloudflare Access (Zero Trust)

📖 About This Wiki

This wiki provides comprehensive documentation for:

• Users - Learn how to use D1 Manager effectively
• Developers - Understand the architecture and contribute
• Operators - Deploy and maintain production instances

Navigation Tips

• Use the sidebar (if available) to browse all pages
• Each page has links to related topics
• Code examples are provided throughout
• Screenshots and diagrams illustrate key concepts

🤝 Getting Help

• Bug Reports: GitHub Issues
• Feature Requests: GitHub Discussions
• Security Issues: See Security Policy

📄 License

D1 Database Manager is released under the MIT License. See the LICENSE file for details.

---

Made with ❤️ for the Cloudflare community