Skip to content

ROADMAP.md

Latest commit

 

History

History
970 lines (765 loc) · 27.2 KB

ROADMAP.md

File metadata and controls

970 lines (765 loc) · 27.2 KB

dbfordevs - Implementation Roadmap

This document outlines all potential features, improvements, and technical debt items identified for the dbfordevs project.

Table of Contents

  1. High Priority
  2. Medium Priority
  3. Low Priority
  4. Database Drivers
  5. Testing & Quality
  6. Technical Debt
  7. UI/UX Enhancements
  8. AI Assistant Improvements
  9. Performance Optimizations
  10. Documentation

High Priority

1. Data Import Functionality

Status: Not Implemented Impact: High Effort: Medium

Currently, the application supports export only (JSON, CSV, INSERT SQL). Import is a fundamental feature for any database tool.

Implementation Tasks:

  • CSV import with delimiter detection
  • Column mapping UI (source column → target column)
  • Data type validation and conversion
  • JSON import for structured data
  • SQL file execution (batch INSERT statements)
  • Import preview with first N rows
  • Error handling with row-level error reporting
  • Progress indicator for large imports
  • Duplicate handling options (skip, replace, fail)
  • Transaction support (rollback on error)

Files to modify:

  • src-tauri/src/commands/queries.rs - New import commands
  • src/components/data-grid/ - Import UI components
  • src/hooks/useDatabase.ts - Import hook methods

2. Query Execution Plan Visualization

Status: Not Implemented Impact: High Effort: Medium

Users cannot analyze query performance. EXPLAIN support would help optimize slow queries.

Implementation Tasks:

  • Add EXPLAIN/EXPLAIN ANALYZE execution command
  • Parse execution plan output per database type
  • Visual tree view for query plan nodes
  • Cost breakdown display
  • Index usage highlighting
  • Sequential scan warnings
  • Row estimate vs actual comparison
  • Query plan comparison (before/after optimization)
  • Save execution plans for reference

Database-specific considerations:

  • PostgreSQL: EXPLAIN (ANALYZE, BUFFERS, FORMAT JSON)
  • MySQL: EXPLAIN FORMAT=JSON
  • SQLite: EXPLAIN QUERY PLAN
  • MSSQL: SET SHOWPLAN_XML ON

3. SQL Formatter / Beautifier

Status: Implemented Impact: High Effort: Low

The Monaco editor now includes SQL formatting capabilities.

Implementation Tasks:

  • Integrate SQL formatting library (sql-formatter or similar)
  • Format document command (Shift+Alt+F)
  • Format selection command
  • Auto-format on paste option
  • Configurable formatting options:
    • Keyword case (UPPER, lower, Preserve)
    • Indentation style (spaces/tabs, size)
    • Comma position (before/after)
    • Line width limit
  • Per-database dialect support
  • Add to editor toolbar
  • Add to right-click context menu

Library used: sql-formatter (npm package)

4. Table Creation UI

Status: Implemented Impact: High Effort: Medium

Users can create new tables via a wizard-style GUI with full column, constraint, and index support.

Implementation Tasks:

  • Create Table dialog/wizard
  • Column definition editor:
    • Name, data type, length/precision
    • Nullable checkbox
    • Default value input
    • Primary key checkbox
    • Auto-increment option
  • Constraint editor:
    • Primary key (single/composite)
    • Foreign keys with reference picker
    • Unique constraints
    • Check constraints
  • Index creation
  • Preview generated DDL
  • Execute with confirmation
  • Template tables (common patterns)

Medium Priority

5. Query Bookmarks & Templates

Status: Implemented Impact: Medium Effort: Low

Implementation Tasks:

  • Save query as bookmark
  • Bookmark manager UI
  • Organize bookmarks in folders
  • Quick access panel/dropdown
  • Search within bookmarks
  • Share bookmarks between connections
  • Built-in query templates:
    • Basic SELECT with JOIN
    • INSERT template
    • UPDATE template
    • DELETE with WHERE
    • Common aggregations
    • Index creation
  • Custom template creation
  • Template variables/placeholders

Storage: Zustand store with localStorage persistence (dbfordevs-bookmarks)

6. Global Schema Search

Status: Implemented Impact: Medium Effort: Low

Implementation Tasks:

  • Search panel accessible via Ctrl+Shift+F in right activity bar
  • Search across:
    • Table names
    • Column names
    • View names
    • Stored procedures
    • Functions
    • Index names
    • Triggers
    • Sequences
    • MongoDB collections and databases
    • Redis keys
    • Cassandra keyspaces and tables
  • Fuzzy matching support with scoring
  • Highlight matches in results
  • Navigate to result on click (opens appropriate query/view)
  • Search history (types defined but not active)
  • Filter by object type

Files created:

  • src/components/schema-search/SchemaSearchPanel.tsx - Main search panel
  • src/components/schema-search/SchemaSearchFilters.tsx - Object type filters
  • src/components/schema-search/SchemaSearchResults.tsx - Grouped results display
  • src/components/schema-search/SchemaSearchResultItem.tsx - Individual result rendering
  • src/stores/schema-search.ts - Zustand store with persistence
  • src/lib/fuzzy-search.ts - Fuzzy matching algorithm
  • src/types/schema-search.ts - Type definitions

7. Customizable Keyboard Shortcuts

Status: Display only Impact: Medium Effort: Low

Settings show keybindings but they cannot be changed.

Implementation Tasks:

  • Keybinding configuration UI
  • Conflict detection
  • Reset to defaults
  • Import/export keybindings
  • Per-context bindings (editor, grid, global)
  • Search keybindings
  • Visual key recorder

Commands to make configurable:

  • Execute query
  • New tab
  • Close tab
  • Save query
  • Format SQL
  • Toggle sidebar
  • Focus search
  • Navigate tables

8. Query History Improvements

Status: Implemented Impact: Medium Effort: Low

Implementation Tasks:

  • Search within history
  • Filter by:
    • Date range
    • Connection (per-connection history)
    • Success/failure
    • Execution time
  • Star/favorite queries
  • History cleanup settings:
    • Max history items
    • Auto-delete after N days
    • Clear all button
  • Export history (JSON, CSV)
  • Query execution statistics
  • Duplicate detection

Files modified:

  • src/types/index.ts - Added QueryHistorySettings, QueryHistoryFilters, QueryHistoryStats types
  • src/stores/query.ts - Added history settings, cleanup, favorites, export, and statistics
  • src/components/query-history/QueryHistoryPanel.tsx - Complete rewrite with filters, stats, export
  • src/components/query-history/QueryHistoryItem.tsx - Added favorites support
  • src/components/query-history/QueryHistoryDropdownItem.tsx - Added favorites indicator
  • src/components/settings/SettingsDialog.tsx - Added Query History settings in Advanced tab
  • src/App.tsx - Added auto-cleanup on startup

9. Data Grid Enhancements

Status: Implemented Impact: Medium Effort: Medium

Implementation Tasks:

  • Column reordering (via header menu)
  • Column hiding/showing (ColumnVisibilityPopover)
  • Column pinning (freeze left/right)
  • Row height configuration (compact/default/comfortable/spacious)
  • Cell value formatting options:
    • Date/time formats (ISO, locale, relative, custom)
    • Number formats (compact, percentage, decimal places)
    • JSON pretty-print (collapsed, inline, pretty)
  • Conditional formatting (highlight cells with rule builder)
  • Column statistics (count, sum, avg, min, max, stdDev)
  • Copy cell/row/column (JSON, CSV, INSERT)
  • Find & replace in results (Ctrl+F, regex support)
  • NULL value display customization (text, style, color)
  • Binary data preview (hex view, base64, text)
  • Image preview for BLOB/BYTEA (auto-detect PNG/JPEG/GIF/WebP/BMP)

Files created:

  • src/types/grid.ts - Type definitions
  • src/stores/grid.ts - Zustand store with persistence
  • src/lib/format-utils.ts - Date/number/JSON formatting
  • src/lib/binary-utils.ts - Binary detection and hex view
  • src/components/data-grid/ColumnVisibilityPopover.tsx
  • src/components/data-grid/ColumnHeaderMenu.tsx
  • src/components/data-grid/CellContextMenu.tsx
  • src/components/data-grid/ColumnStatisticsDialog.tsx
  • src/components/data-grid/FindReplaceBar.tsx
  • src/components/data-grid/BinaryPreviewDialog.tsx
  • src/components/data-grid/ConditionalFormatDialog.tsx
  • src/components/settings/GridSettingsTab.tsx

Low Priority

10. Multiple Result Sets

Status: Not Implemented Impact: Low Effort: Medium

Support queries returning multiple result sets.

Implementation Tasks:

  • Tab per result set
  • Result set navigation
  • Stored procedure output parameters
  • PRINT/RAISERROR message capture (MSSQL)

11. Database Object Management

Status: Implemented Impact: Low Effort: High

Implementation Tasks:

  • Create/Edit/Drop Views
  • Create/Edit/Drop Indexes
  • Create/Edit/Drop Stored Procedures
  • Create/Edit/Drop Functions
  • Create/Edit/Drop Triggers
  • Create/Edit/Drop Sequences
  • User/Role management
  • Permission management

Files created:

  • src-tauri/src/commands/views.rs - View management commands
  • src-tauri/src/commands/indexes.rs - Index management commands
  • src/stores/views.ts - Views Zustand store
  • src/stores/indexes.ts - Indexes Zustand store
  • src/stores/users.ts - Users/Roles Zustand store
  • src/components/users/ - User management UI components

12. Schema Diff Tool

Status: Implemented Impact: Medium Effort: Medium

Implementation Tasks:

  • Compare two query results
  • Schema diff between connections
  • Data diff between tables
  • Generate migration scripts
  • Side-by-side view
  • Visual diff with change categorization

Files created:

  • src-tauri/src/db/diff.rs - Diff engine (1,859 lines) with database-specific migration SQL generation
  • src-tauri/src/commands/diff.rs - Tauri commands (compare, snapshot, list, delete)
  • src-tauri/src/models/diff.rs - Data models
  • src-tauri/src/storage/snapshots.rs - Snapshot persistence
  • src/components/diff/SchemaDiffDialog.tsx - 3-step wizard UI
  • src/components/diff/SourceSelectionStep.tsx - Connection/table/snapshot selection
  • src/components/diff/DiffVisualizationStep.tsx - Visual diff display
  • src/components/diff/MigrationPreviewStep.tsx - Migration script preview and export
  • src/stores/diff.ts - Zustand store
  • src/types/diff.ts - TypeScript types

Features:

  • Compare schemas across connections, tables, or vs snapshots
  • Point-in-time schema snapshots
  • Color-coded diff (green=added, red=removed, blue=modified)
  • Database-specific migration SQL (PostgreSQL, MySQL, SQLite, Oracle, MSSQL)
  • Destructive operation warnings
  • Copy/download migration scripts
  • 8 unit tests for diff logic

13. Connection Groups & Tags

Status: Implemented Impact: Low Effort: Low

Implementation Tasks:

  • Group connections by environment (dev/staging/prod)
  • Custom tags/labels
  • Color coding
  • Collapse/expand groups
  • Filter by group/tag
  • Bulk operations on groups

Files created:

  • src/components/ui/color-picker.tsx - Color palette picker
  • src/components/ui/tag-badge.tsx - Colored tag badge component
  • src/components/connections/ConnectionFilterBar.tsx - Search and filter UI
  • src/components/connections/GroupManagerDialog.tsx - Group CRUD dialog
  • src/components/connections/AssignGroupDialog.tsx - Assign group/tags to connection
  • src/components/layout/ConnectionGroupItem.tsx - Collapsible group container

Files modified:

  • src/types/index.ts - Added ConnectionGroup, ConnectionTag interfaces
  • src/stores/connections.ts - Extended with groups, tags, filters, migration
  • src/stores/ui.ts - Added dialog state management
  • src/components/layout/Sidebar.tsx - Integrated grouped rendering

14. Query Scheduler

Status: Not Implemented Impact: Low Effort: High

Implementation Tasks:

  • Schedule query execution
  • Cron-like scheduling
  • Export results automatically
  • Email notifications
  • Execution history
  • Error alerting

Database Drivers

15. MongoDB Driver

Status: Implemented Impact: High Effort: High

Implementation Tasks:

  • Add mongodb Rust crate dependency
  • Implement DatabaseDriver trait for MongoDB
  • Collection listing (equivalent to tables)
  • Document querying with MongoDB query syntax
  • Document CRUD operations
  • Index management
  • Aggregation pipeline support
  • Schema inference for documents
  • Connection string parsing (standard and Atlas SRV)
  • Authentication (SCRAM-SHA-256)

Files Created:

  • src-tauri/src/db/mongodb.rs - Core MongoDB driver (~1100 lines)
  • src-tauri/src/commands/mongodb.rs - 25+ Tauri commands
  • src/types/mongodb.ts - TypeScript interfaces
  • src/stores/mongodb.ts - Zustand store
  • src/hooks/useMongoDB.ts - React hook wrapper
  • src/components/mongodb/ - UI components (MongoConnectionContent, MongoBrowser, MongoDocumentViewer, MongoDocumentEditor, MongoShell, MongoServerInfo)

Features Implemented:

  • Database and collection browsing with tree view
  • Document browser with filter, sort, and pagination
  • Document CRUD operations (view, insert, edit, delete)
  • Index management (list, create, drop)
  • Aggregation pipeline support
  • MongoDB Shell for raw command execution
  • Server info dashboard with connection and storage stats
  • Support for both mongodb:// and mongodb+srv:// (Atlas) connection strings

16. Redis Driver

Status: Implemented Impact: Medium Effort: Medium

Implementation Tasks:

  • Add redis Rust crate dependency
  • Key listing with pattern matching
  • Key type detection
  • Value viewing/editing per type:
    • Strings
    • Lists
    • Sets
    • Sorted Sets
    • Hashes
    • Streams
  • TTL management
  • Key deletion
  • Redis CLI mode
  • Pub/Sub viewer
  • Memory usage statistics

17. Oracle Driver

Status: Implemented Impact: Medium Effort: High

Implementation Tasks:

  • Evaluate Rust Oracle crates (oracle, sibyl)
  • Implement DatabaseDriver trait
  • Handle Oracle-specific types (NUMBER, VARCHAR2, CLOB, BLOB)
  • PL/SQL execution support
  • Package/procedure browsing
  • TNS connection string support (Easy Connect format)
  • Oracle Wallet authentication

Files: src-tauri/src/db/oracle.rs

Features Implemented:

  • Full Oracle driver using oracle crate with deadpool connection pooling
  • Easy Connect format support (//host:port/service_name)
  • All core operations: queries, tables, schemas, indexes, constraints, foreign keys
  • Oracle-specific type handling (NUMBER, VARCHAR2, CHAR, CLOB, BLOB, DATE, TIMESTAMP)
  • EXPLAIN PLAN visualization with DBMS_XPLAN
  • DDL generation using DBMS_METADATA
  • System schema filtering (SYS, SYSTEM, APEX_*, etc.)

18. Cassandra Driver

Status: Implemented Impact: Medium Effort: High

Implementation Tasks:

  • Add scylla crate
  • Keyspace/table listing
  • CQL query execution
  • Partition key awareness
  • Cluster topology view (server info with nodes, datacenters)
  • Consistency level configuration
  • Keyspace management (create, drop)
  • Table management (describe, drop, truncate)
  • Index listing
  • CQL Shell with history
  • SSH tunnel support

Files created:

  • src-tauri/src/db/cassandra.rs - Core driver (~1,200 lines) using scylla crate
  • src-tauri/src/commands/cassandra.rs - 10 Tauri commands
  • src/types/cassandra.ts - TypeScript interfaces (148 lines)
  • src/stores/cassandra.ts - Zustand store (339 lines)
  • src/hooks/useCassandra.ts - React hook (474 lines)
  • src/components/cassandra/CassandraShell.tsx - CQL editor
  • src/components/cassandra/CassandraBrowser.tsx - Schema browser
  • src/components/cassandra/CassandraConnectionContent.tsx - Main interface
  • src/components/cassandra/CassandraServerInfo.tsx - Cluster info

Testing & Quality

19. End-to-End Tests

Status: Not Implemented Impact: High Effort: High

Implementation Tasks:

  • Set up Playwright or Cypress
  • Connection creation flow test
  • Query execution flow test
  • Export functionality test
  • Theme switching test
  • AI assistant interaction test
  • Error handling scenarios
  • CI/CD integration

20. Rust Command Handler Tests

Status: Not Implemented Impact: Medium Effort: Medium

Implementation Tasks:

  • Unit tests for commands/connections.rs
  • Unit tests for commands/queries.rs
  • Unit tests for commands/tables.rs
  • Mock database connections
  • Error case coverage

21. Frontend Component Tests

Status: Partial Impact: Medium Effort: Medium

Implementation Tasks:

  • Data grid component tests
  • Connection form tests
  • Settings dialog tests
  • AI panel tests
  • Query editor tests
  • Increase coverage to 80%+

Technical Debt

22. Parameterized Queries for CRUD

Status: Completed Impact: Critical (Security) Effort: Medium

Location: src-tauri/src/commands/queries.rs, src-tauri/src/db/connection.rs

Implementation Tasks:

  • Replace string interpolation with parameterized queries
  • Update insert_row command
  • Update update_row command
  • Update delete_row command
  • Add input validation
  • SQL injection test cases
  • Implement execute_parameterized for PostgreSQL, MySQL, SQLite, MSSQL, Oracle
  • Unit tests for placeholder generation and WHERE condition formatting

23. Error Handling Standardization

Status: Inconsistent Impact: Medium Effort: Low

Implementation Tasks:

  • Standardize error types across all commands
  • User-friendly error messages
  • Error codes for programmatic handling
  • Logging improvements
  • Error tracking/reporting

24. Connection Pool Management

Status: Basic Impact: Medium Effort: Medium

Implementation Tasks:

  • Connection pool statistics UI
  • Pool size configuration
  • Connection timeout settings
  • Idle connection cleanup
  • Connection health checks
  • Reconnection strategies

UI/UX Enhancements

25. Dark Mode Improvements

Status: Implemented Impact: Low Effort: Low

Implementation Tasks:

  • More theme variants (Solarized Dark/Light, One Dark, High Contrast)
  • Custom theme creator UI with live preview
  • Theme import/export (JSON format)
  • Syntax highlighting theme sync (Monaco editor)
  • High contrast mode (WCAG AAA compliant)

Files created:

  • src/types/theme.ts - Theme type definitions and default color constants
  • src/stores/themes.ts - Custom themes Zustand store with persistence
  • src/lib/themes/utils.ts - Theme application utilities (CSS injection)
  • src/lib/themes/validation.ts - Theme validation functions
  • src/lib/themes/monaco-generator.ts - Monaco theme generation
  • src/components/themes/ThemeManagerDialog.tsx - Theme management dialog
  • src/components/themes/ThemeEditor.tsx - Color editing panel with collapsible sections
  • src/components/themes/ThemePreview.tsx - Live theme preview component
  • src/components/ui/hsl-color-picker.tsx - HSL color picker with hex support

Files modified:

  • src/index.css - Added 4 new theme CSS classes (~300 lines)
  • src/stores/ui.ts - Extended Theme type to support custom:${id} format
  • src/components/editor/monaco-themes.ts - Added 4 Monaco themes
  • src/components/settings/SettingsDialog.tsx - Theme manager integration

26. Accessibility (a11y)

Status: Basic Impact: Medium Effort: Medium

Implementation Tasks:

  • Keyboard navigation audit
  • Screen reader support
  • ARIA labels
  • Focus indicators
  • Color contrast compliance
  • Reduced motion support

27. Responsive Design

Status: Desktop only Impact: Low Effort: Medium

Implementation Tasks:

  • Tablet layout optimization
  • Collapsible panels for small screens
  • Touch-friendly controls
  • Mobile companion app (future)

28. Onboarding & Tutorials

Status: Not Implemented Impact: Medium Effort: Low

Implementation Tasks:

  • First-run welcome wizard
  • Feature tour/highlights
  • Sample database option
  • Quick start guide
  • Contextual help tooltips
  • Video tutorial links

29. Notifications & Alerts

Status: Basic toasts Impact: Low Effort: Low

Implementation Tasks:

  • Notification center
  • Notification history
  • Query completion notifications
  • Error notifications with actions
  • Desktop notifications (optional)

AI Assistant Improvements

30. AI Context Enhancements

Status: Implemented Impact: Medium Effort: Medium

Implementation Tasks:

  • Include foreign key relationships in context
  • Include indexes in context
  • Include sample data option
  • Context size indicator
  • Manual context editing
  • Context templates

Files created:

  • src/lib/ai/context-builder.ts - Context building with relationships, indexes, sample data
  • src/lib/ai/types.ts - Type definitions for context entries
  • src/components/ai/AIContextPanel.tsx - Context UI with size indicator and manual editing
  • src/components/ai/ContextConfigDialog.tsx - Template management UI

31. AI Query Validation

Status: Implemented Impact: Medium Effort: Medium

Implementation Tasks:

  • Syntax validation before execution
  • Semantic validation (table/column existence)
  • Performance warnings
  • Security warnings (DROP, TRUNCATE, etc.)
  • Suggested improvements

Files created:

  • src/lib/ai/validation.ts - Full validation engine with syntax, semantic, performance, and security checks
  • src/components/ai/QueryValidationBadge.tsx - Interactive validation UI with issue popover

32. AI Chat Export

Status: Partial Impact: Low Effort: Low

Implementation Tasks:

  • Export chat history to Markdown
  • Export to PDF
  • Share chat sessions
  • Chat templates

Files created:

  • src/lib/ai/export.ts - Markdown and JSON export with timestamps, usage stats, SQL-only mode
  • src/components/ai/ChatExportDialog.tsx - Export UI with preview, copy, and download
  • src/components/ai/ChatTemplateSelector.tsx - Chat template selection UI

Performance Optimizations

33. Query Result Streaming

Status: Not Implemented Impact: Medium Effort: High

Implementation Tasks:

  • Stream large result sets
  • Progressive loading
  • Cancel long-running queries
  • Memory usage optimization
  • Result set pagination

34. Connection Caching

Status: Basic Impact: Low Effort: Low

Implementation Tasks:

  • Schema metadata caching
  • Table list caching
  • Cache invalidation strategies
  • Cache size limits
  • Manual cache refresh

35. Lazy Loading

Status: Partial Impact: Low Effort: Low

Implementation Tasks:

  • Lazy load schema tree
  • Lazy load large tables
  • Code splitting optimization
  • Bundle size reduction

Documentation

36. User Documentation

Status: Minimal Impact: Medium Effort: Medium

Implementation Tasks:

  • User guide
  • Feature documentation
  • Keyboard shortcuts reference
  • FAQ section
  • Troubleshooting guide
  • Video tutorials

37. Developer Documentation

Status: CLAUDE.md exists Impact: Low Effort: Low

Implementation Tasks:

  • Architecture documentation
  • API documentation
  • Contributing guidelines expansion
  • Code style guide

Implementation Priority Matrix

Priority Feature Impact Effort Status
P0 Parameterized Queries (Security) Critical Medium Implemented
P1 Data Import High Medium Implemented
P1 Query Execution Plans High Medium Implemented
P1 SQL Formatter High Low Implemented
P2 Table Creation UI High Medium Implemented
P2 Query Bookmarks Medium Low Implemented
P2 Global Schema Search Medium Low Implemented
P2 MongoDB Driver High High Implemented
P3 Customizable Keybindings Medium Low Not Started
P3 E2E Tests High High Not Started
P4 Redis Driver Medium Medium Implemented
P4 Oracle Driver Medium High Implemented
P4 Cassandra Driver Medium High Implemented
P2 Schema Diff Medium Medium Implemented
P2 View Management Medium Medium Implemented
P2 Index Management Medium Medium Implemented
P2 User/Role Management Medium Medium Implemented
P2 Query History Enhancements Medium Low Implemented
P2 Data Grid Enhancements Medium Medium Implemented
P3 Dark Mode Improvements Low Low Implemented
P3 AI Context Enhancements Medium Medium Implemented
P3 AI Query Validation Medium Medium Implemented
P4 AI Chat Export Low Low Partial

Version Milestones (Suggested)

v0.3.0 - Data Management ✅ RELEASED

  • ✅ Data Import (CSV, JSON, SQL)
  • ✅ SQL Formatter
  • ✅ Query Bookmarks
  • ✅ Query Execution Plans
  • ✅ Table Creation UI
  • ✅ Oracle Driver

v0.3.5 - Schema & User Management ✅ RELEASED

  • ✅ View Management (Create/Drop/DDL)
  • ✅ Index Management (Create/Drop/DDL)
  • ✅ User/Role Management
  • ✅ Permission Controls
  • ✅ Query History Enhancements
  • ✅ Data Grid Enhancements

v0.4.0 - NoSQL Support ✅ RELEASED

  • ✅ MongoDB Driver (full implementation)
  • ✅ Redis Driver (full implementation)
  • ✅ Document Viewer/Editor
  • ✅ MongoDB Shell & Aggregation Pipeline
  • ✅ Redis CLI & Pub/Sub

v0.5.0 - Query Intelligence ✅ RELEASED

  • ✅ Query Validation (AI-powered)
  • ✅ Performance Warnings
  • ✅ AI Context Enhancements (relationships, indexes, sample data)
  • ✅ Global Schema Search (full implementation with fuzzy search)
  • ✅ Schema Diff (3-step wizard with migration script generation)
  • ✅ Cassandra Driver (full implementation)
  • ✅ MSSQL Named Instance Support

v0.6.0 - Polish & Quality

  • ✅ Parameterized CRUD Queries (security improvement)
  • Table Truncate
  • Customizable Keybindings
  • Command Palette
  • E2E Test Infrastructure

v1.0.0 - Production Ready

  • Full Test Coverage
  • Backup/Restore
  • Accessibility Compliance
  • Data Visualization basics

Last updated: February 1, 2026 Updated from codebase analysis - v0.5.3