EasyDB easydb

Open-source, cross-platform database management tool Connection Management · Object Browser · SQL Editor · Data Tracker · DDL Audit · Structure Diff · Data Migration · Data Sync · Data Export · Backup & Restore · Slow Query Analysis · Task Center · Secure Connection ✨ Features 🔌 Connection Management - Create, edit, test, group, and search MySQL connections - SSH Tunnel: JSch local port forwarding — bypass jump servers to access internal databases (password & private key authentication) - SSL/TLS Encryption: CA certificate verification, mutual TLS authentication (PEM format, no JKS conversion needed) - Encrypted Credential Storage: Connection passwords encrypted at rest with AES-256-GCM (machine-bound key); API responses automatically masked 🗂️ Database Workbench - Object tree browser with categorized nodes: Tables · Views · Stored Procedures · Functions · Triggers - Data preview with WHERE filter, column sorting, and field auto-completion - View support: data preview (read-only) and DDL viewer - Stored procedure / function / trigger DDL viewer - Table structure designer and DDL viewer ⚙️ Stored Procedure Execution - Right-click menu entry in workbench object tree (⚙ Execute Procedure / ⨍ Call Function) - Auto-load parameter metadata (IN/OUT/INOUT direction, data types) - Type-aware input components (integer, decimal, boolean, date, datetime, text) - NULL checkbox for each parameter - OUT parameter value display after execution - Multi-result-set support with tabbed display - Function return value display - Execution duration tracking - ProcedureAdapter architecture — extendable to PostgreSQL / DM (KingbaseES) ✏️ SQL Editor - Powered by Monaco Editor with syntax highlighting - Smart auto-completion: table names, column names, SQL keywords, MySQL functions - Context-aware: auto-detects tables in FROM/JOIN clauses and suggests columns - Execute selected text or full script with ⌘+Enter - SQL History: configurable per-database query history, searchable, re-run with one click (can be toggled per-database in Settings) 🔍 Data Tracker (CDC) - Real-time Binlog event capture: INSERT / UPDATE / DELETE (row-level) - Replay mode: replay historical Binlog files with configurable start/end positions - Server-side pagination — backend stores all events, frontend pulls on demand - Per-column diff view for UPDATE events, diff-only mode hides unchanged columns - Rollback SQL generation: reverse DML to DELETE/INSERT/UPDATE; download as .sql - Forward replay SQL generation - DDL Audit (v1.5 new): captures table-level DDL from Binlog QUERY events - 5 DDL types: CREATE TABLE / ALTER TABLE / DROP TABLE / TRUNCATE TABLE / RENAME TABLE - Risk classification: low / medium / high / critical - Raw SQL preserved for full audit trail - Dedicated DDL detail panel (no rollback/replay — read-only audit) - DDL filter in event list, DDL count in statistics panel - DDL events excluded from rollback/replay SQL generation 🆚 Structure Diff - Table-level structure comparison between two MySQL instances - Extended object comparison: Views · Stored Procedures · Functions · Triggers - DDL normalization: strips DEFINER, comments, and whitespace before diff - Side-by-side DDL comparison for non-table objects 🚀 Data Migration - Wizard-style workflow: Select Connection → Select Objects → Configure Strategy → Execute - Supports both schema migration and data migration 🔄 Data Sync - Table-level real-time sync with INSERT / UPSERT strategies - Performance optimized: 1.9M rows sync reduced from 48 min → 5 min 25 sec (9x faster) - rewriteBatchedStatements for batch writes - Disables unique_checks / foreign_key_checks during sync - Dynamic batch size (5,000 for regular tables, 10,000 for large tables) 📤 Data Export - Export to SQL/ZIP files for viewing, delivery, and compatibility - Support export cancellation with automatic cleanup of incomplete files - Direct download of exported files 💾 Database Backup & Restore - Backup - Create standard backup packages (.edbkp) with structure, data, and checksums - Three backup modes: full, structure-only, data-only - Table-level selection: choose specific tables or entire database - Consistent snapshot backup with Binlog position for PITR - SHA-256 checksum ensures data integrity - Custom output path, size estimation, progress tracking - Restore - Restore database from standard backup packages - File inspection: verify integrity, SHA-256, consistency status - Two restore strategies: restore to new database, overwrite existing - Three restore modes: full, structure-only, data-only - Table-level selection: restore specific tables - Real-time progress, log output, cancellation support 📥 SQL File Import - Native file picker (Tauri system dialog) - Drag & drop upload / manual path input - Stream-based import, no memory pressure for large files - Execution stats: success, failure, skip counts - Progress tracking, log viewer, cancellation support 🔍 Slow Query Analysis - Based on MySQL performance_schema — no Binlog or slow log parsing required - SQL fingerprint aggregation: group by digest, view execution count, average/max latency, rows scanned - Filter by minimum latency threshold, database, keyword search - Index-miss-only filter to surface queries without proper indexing - Sort by average latency, max latency, or execution count - One-click EXPLAIN execution plan analysis - Auto-detect performance_schema availability with capability check 📋 Task Center - Unified management for migration, sync, export, and import tasks - Real-time progress, elapsed time, and log viewer - Task cancellation, filtering, and history ⚙️ Settings - Dark / Light / System theme switching - Storage management: disk usage visualization, categorized cleanup (exports / logs / backups / task records) - Backup file management: list view, individual delete, batch cleanup by days - Auto-update check