SQL CLI v1.9.11

SQL CLI v1.9.11

Release Date: August 08, 2025

✨ What's New

🚀 Features

• complete Phase 5-6 of input migration
• complete Phase 3-4 of input migration
• migrate column_stats to buffer system

🐛 Bug Fixes

• restore mcfly history recall with schema-aware filtering
• critical bug - infinite recursion in get_results() wrapper

📝 All Changes

Click to expand full commit list

• refactor: remove legacy data fields from TUI - enforce buffer-only access (TimelordUK)
• fix: restore mcfly history recall with schema-aware filtering (TimelordUK)
• fix: critical bug - infinite recursion in get_results() wrapper (TimelordUK)
• feat: complete Phase 5-6 of input migration (TimelordUK)
• feat: complete Phase 3-4 of input migration (TimelordUK)
• feat: migrate column_stats to buffer system (TimelordUK)

🎯 Highlights

• Dynamic Column Sizing: Columns automatically adjust width based on visible data
• Compact Mode: Press 'C' to reduce padding and fit more columns
• Viewport Lock: Press Space to anchor scrolling position
• Auto-Execute: CSV/JSON files show data immediately on load
• Visual Source Indicators: See where your data comes from (📦 📁 🌐 🗄️)

📦 Installation

Download the appropriate binary for your platform from the assets below.

Supported Platforms

• Linux x64: sql-cli-linux-x64.tar.gz
• Windows x64: sql-cli-windows-x64.zip
• macOS x64 (Intel): sql-cli-macos-x64.tar.gz
• macOS ARM64 (Apple Silicon): sql-cli-macos-arm64.tar.gz

Quick Start

# Load a CSV file with instant preview
sql-cli data/customers.csv

# Connect to API
sql-cli --url http://localhost:5000

SQL CLI v1.9.10

SQL CLI v1.9.10

Release Date: August 08, 2025

✨ What's New

🚀 Features

• migrate column_search_state to buffer system
• implement multi-buffer system with independent results and config
• complete Phase 9-10 of input migration
• add comprehensive logging with tracing and ring buffer
• add alternative buffer navigation keys and fix file loading
• implement multi-file loading into separate buffers
• Phase 8 - multi-buffer support
• Phase 7 - centralized undo/redo through BufferAPI

🐛 Bug Fixes

• use working key bindings for buffer switching
• properly load CSV/JSON data for each buffer in multi-file mode

📚 Documentation

• update migration plan with current status

📝 All Changes

Click to expand full commit list

• feat: migrate column_search_state to buffer system (TimelordUK)
• docs: update migration plan with current status (TimelordUK)
• refactor: migrate fuzzy_filter_state to buffer system (TimelordUK)
• refactor: migrate results field to buffer system (TimelordUK)
• refactor: make BufferManager non-optional (Stage 1) (TimelordUK)
• feat: implement multi-buffer system with independent results and config (TimelordUK)
• feat: complete Phase 9-10 of input migration (TimelordUK)
• fix: use working key bindings for buffer switching (TimelordUK)
• feat: add comprehensive logging with tracing and ring buffer (TimelordUK)
• fix: properly load CSV/JSON data for each buffer in multi-file mode (TimelordUK)
• feat: add alternative buffer navigation keys and fix file loading (TimelordUK)
• feat: implement multi-file loading into separate buffers (TimelordUK)
• feat: Phase 8 - multi-buffer support (TimelordUK)
• feat: Phase 7 - centralized undo/redo through BufferAPI (TimelordUK)

🎯 Highlights

• Dynamic Column Sizing: Columns automatically adjust width based on visible data
• Compact Mode: Press 'C' to reduce padding and fit more columns
• Viewport Lock: Press Space to anchor scrolling position
• Auto-Execute: CSV/JSON files show data immediately on load
• Visual Source Indicators: See where your data comes from (📦 📁 🌐 🗄️)

📦 Installation

Download the appropriate binary for your platform from the assets below.

Supported Platforms

• Linux x64: sql-cli-linux-x64.tar.gz
• Windows x64: sql-cli-windows-x64.zip
• macOS x64 (Intel): sql-cli-macos-x64.tar.gz
• macOS ARM64 (Apple Silicon): sql-cli-macos-arm64.tar.gz

Quick Start

# Load a CSV file with instant preview
sql-cli data/customers.csv

# Connect to API
sql-cli --url http://localhost:5000

SQL CLI v1.9.9

SQL CLI v1.9.9

Release Date: August 08, 2025

✨ What's New

🚀 Features

• route key events through buffer API for proper input handling
• add helper methods for buffer-based input reading

🐛 Bug Fixes

• complete Phase 4 of input migration to buffer API
• route Tab completion through buffer API
• route undo and yank operations through buffer API
• route kill line operations through buffer API
• route Ctrl+A and Ctrl+E navigation through buffer API
• sync visual rendering with buffer input state
• correct method names and string references in buffer API usage

📚 Documentation

• update status - Phase 4 complete 🎉

📝 All Changes

Click to expand full commit list

• refactor: Phase 6 - reduce direct input field access (TimelordUK)
• refactor: Phase 5 - unified input handling through BufferAPI (TimelordUK)
• docs: update status - Phase 4 complete 🎉 (TimelordUK)
• Merge branch 'feature/input-migration-phase4-read-ops' (TimelordUK)
• test: add comprehensive input navigation test suite (TimelordUK)
• fix: complete Phase 4 of input migration to buffer API (TimelordUK)
• fix: route Tab completion through buffer API (TimelordUK)
• fix: route undo and yank operations through buffer API (TimelordUK)
• fix: route kill line operations through buffer API (TimelordUK)
• fix: route Ctrl+A and Ctrl+E navigation through buffer API (TimelordUK)
• fix: sync visual rendering with buffer input state (TimelordUK)
• feat: route key events through buffer API for proper input handling (TimelordUK)
• fix: correct method names and string references in buffer API usage (TimelordUK)
• feat: add helper methods for buffer-based input reading (TimelordUK)

🎯 Highlights

• Dynamic Column Sizing: Columns automatically adjust width based on visible data
• Compact Mode: Press 'C' to reduce padding and fit more columns
• Viewport Lock: Press Space to anchor scrolling position
• Auto-Execute: CSV/JSON files show data immediately on load
• Visual Source Indicators: See where your data comes from (📦 📁 🌐 🗄️)

📦 Installation

Download the appropriate binary for your platform from the assets below.

Supported Platforms

• Linux x64: sql-cli-linux-x64.tar.gz
• Windows x64: sql-cli-windows-x64.zip
• macOS x64 (Intel): sql-cli-macos-x64.tar.gz
• macOS ARM64 (Apple Silicon): sql-cli-macos-arm64.tar.gz

Quick Start

# Load a CSV file with instant preview
sql-cli data/customers.csv

# Connect to API
sql-cli --url http://localhost:5000

SQL CLI v1.9.8

SQL CLI v1.9.8

Release Date: August 08, 2025

✨ What's New

🚀 Features

• add key press debugging and Alt+Up/Down as history navigation alternatives
• add Ctrl+P/N for history navigation (Option 2 - simple and reliable)
• add session history and star system for better history management
• add history navigation support to InputManager
• add InputManager abstraction for unified input handling (Phase 1-2)

🐛 Bug Fixes

• properly track and display key press history in debug mode
• resolve borrow checker issue in history navigation
• apply rustfmt formatting to pass CI checks
• add case-insensitive support for equality operator in WHERE clauses

📚 Documentation

• capture future improvement ideas from debug observations
• add branch status tracking for input migration work

📝 All Changes

Click to expand full commit list

• test: add comprehensive tests for complex date queries (TimelordUK)
• docs: capture future improvement ideas from debug observations (TimelordUK)
• docs: add branch status tracking for input migration work (TimelordUK)
• debug: add diagnostic output for history navigation (TimelordUK)
• fix: properly track and display key press history in debug mode (TimelordUK)
• feat: add key press debugging and Alt+Up/Down as history navigation alternatives (TimelordUK)
• fix: resolve borrow checker issue in history navigation (TimelordUK)
• feat: add Ctrl+P/N for history navigation (Option 2 - simple and reliable) (TimelordUK)
• feat: add session history and star system for better history management (TimelordUK)
• feat: add history navigation support to InputManager (TimelordUK)
• feat: add InputManager abstraction for unified input handling (Phase 1-2) (TimelordUK)
• fix: apply rustfmt formatting to pass CI checks (TimelordUK)
• fix: add case-insensitive support for equality operator in WHERE clauses (TimelordUK)

🎯 Highlights

• Dynamic Column Sizing: Columns automatically adjust width based on visible data
• Compact Mode: Press 'C' to reduce padding and fit more columns
• Viewport Lock: Press Space to anchor scrolling position
• Auto-Execute: CSV/JSON files show data immediately on load
• Visual Source Indicators: See where your data comes from (📦 📁 🌐 🗄️)

📦 Installation

Download the appropriate binary for your platform from the assets below.

Supported Platforms

• Linux x64: sql-cli-linux-x64.tar.gz
• Windows x64: sql-cli-windows-x64.zip
• macOS x64 (Intel): sql-cli-macos-x64.tar.gz
• macOS ARM64 (Apple Silicon): sql-cli-macos-arm64.tar.gz

Quick Start

# Load a CSV file with instant preview
sql-cli data/customers.csv

# Connect to API
sql-cli --url http://localhost:5000

SQL CLI v1.9.7

SQL CLI v1.9.7

Release Date: August 07, 2025

✨ What's New

🚀 Features

• migrate search_state to buffer system

🐛 Bug Fixes

• apply compact_mode from config when creating buffers

📝 All Changes

Click to expand full commit list

• fix: apply compact_mode from config when creating buffers (TimelordUK)
• feat: migrate search_state to buffer system (TimelordUK)

🎯 Highlights

• Dynamic Column Sizing: Columns automatically adjust width based on visible data
• Compact Mode: Press 'C' to reduce padding and fit more columns
• Viewport Lock: Press Space to anchor scrolling position
• Auto-Execute: CSV/JSON files show data immediately on load
• Visual Source Indicators: See where your data comes from (📦 📁 🌐 🗄️)

📦 Installation

Download the appropriate binary for your platform from the assets below.

Supported Platforms

• Linux x64: sql-cli-linux-x64.tar.gz
• Windows x64: sql-cli-windows-x64.zip
• macOS x64 (Intel): sql-cli-macos-x64.tar.gz
• macOS ARM64 (Apple Silicon): sql-cli-macos-arm64.tar.gz

Quick Start

# Load a CSV file with instant preview
sql-cli data/customers.csv

# Connect to API
sql-cli --url http://localhost:5000

SQL CLI v1.9.6

SQL CLI v1.9.6

Release Date: August 07, 2025

✨ What's New

🚀 Features

• migrate filtered_data to buffer system
• migrate csv_client to buffer system
• migrate cached_data to buffer system
• migrate last_visible_rows to buffer system
• migrate undo_stack, redo_stack, and kill_ring to buffer system

📝 All Changes

Click to expand full commit list

• feat: migrate filtered_data to buffer system (TimelordUK)
• feat: migrate csv_client to buffer system (TimelordUK)
• feat: migrate cached_data to buffer system (TimelordUK)
• feat: migrate last_visible_rows to buffer system (TimelordUK)
• feat: migrate undo_stack, redo_stack, and kill_ring to buffer system (TimelordUK)

🎯 Highlights

• Dynamic Column Sizing: Columns automatically adjust width based on visible data
• Compact Mode: Press 'C' to reduce padding and fit more columns
• Viewport Lock: Press Space to anchor scrolling position
• Auto-Execute: CSV/JSON files show data immediately on load
• Visual Source Indicators: See where your data comes from (📦 📁 🌐 🗄️)

📦 Installation

Download the appropriate binary for your platform from the assets below.

Supported Platforms

• Linux x64: sql-cli-linux-x64.tar.gz
• Windows x64: sql-cli-windows-x64.zip
• macOS x64 (Intel): sql-cli-macos-x64.tar.gz
• macOS ARM64 (Apple Silicon): sql-cli-macos-arm64.tar.gz

Quick Start

# Load a CSV file with instant preview
sql-cli data/customers.csv

# Connect to API
sql-cli --url http://localhost:5000

SQL CLI v1.9.5

SQL CLI v1.9.5

Release Date: August 07, 2025

✨ What's New

🚀 Features

• migrate mode and cache_mode fields to buffer system
• migrate csv_table_name field to buffer system

📝 All Changes

Click to expand full commit list

• feat: migrate mode and cache_mode fields to buffer system (TimelordUK)
• feat: migrate csv_table_name field to buffer system (TimelordUK)

🎯 Highlights

• Dynamic Column Sizing: Columns automatically adjust width based on visible data
• Compact Mode: Press 'C' to reduce padding and fit more columns
• Viewport Lock: Press Space to anchor scrolling position
• Auto-Execute: CSV/JSON files show data immediately on load
• Visual Source Indicators: See where your data comes from (📦 📁 🌐 🗄️)

📦 Installation

Download the appropriate binary for your platform from the assets below.

Supported Platforms

• Linux x64: sql-cli-linux-x64.tar.gz
• Windows x64: sql-cli-windows-x64.zip
• macOS x64 (Intel): sql-cli-macos-x64.tar.gz
• macOS ARM64 (Apple Silicon): sql-cli-macos-arm64.tar.gz

Quick Start

# Load a CSV file with instant preview
sql-cli data/customers.csv

# Connect to API
sql-cli --url http://localhost:5000

SQL CLI v1.9.4

SQL CLI v1.9.4

Release Date: August 07, 2025

✨ What's New

🚀 Features

• migrate csv_mode field to buffer system
• migrate column_widths field to buffer system
• migrate viewport_lock fields to buffer system
• migrate show_row_numbers field to buffer system

📝 All Changes

Click to expand full commit list

• feat: migrate csv_mode field to buffer system (TimelordUK)
• feat: migrate column_widths field to buffer system (TimelordUK)
• feat: migrate viewport_lock fields to buffer system (TimelordUK)
• feat: migrate show_row_numbers field to buffer system (TimelordUK)

🎯 Highlights

• Dynamic Column Sizing: Columns automatically adjust width based on visible data
• Compact Mode: Press 'C' to reduce padding and fit more columns
• Viewport Lock: Press Space to anchor scrolling position
• Auto-Execute: CSV/JSON files show data immediately on load
• Visual Source Indicators: See where your data comes from (📦 📁 🌐 🗄️)

📦 Installation

Download the appropriate binary for your platform from the assets below.

Supported Platforms

• Linux x64: sql-cli-linux-x64.tar.gz
• Windows x64: sql-cli-windows-x64.zip
• macOS x64 (Intel): sql-cli-macos-x64.tar.gz
• macOS ARM64 (Apple Silicon): sql-cli-macos-arm64.tar.gz

Quick Start

# Load a CSV file with instant preview
sql-cli data/customers.csv

# Connect to API
sql-cli --url http://localhost:5000

SQL CLI v1.9.3

SQL CLI v1.9.3

Release Date: August 07, 2025

✨ What's New

🚀 Features

• migrate compact_mode to buffer system
• implement smart numeric coercion and LIMIT/OFFSET clauses
• migrate pinned_columns to buffer system
• migrate current_column to buffer system

📚 Documentation

• add TODO for fuzzy filter row count issue
• update migration plan with current_column completion

📝 All Changes

Click to expand full commit list

• feat: migrate compact_mode to buffer system (TimelordUK)
• fix build error (TimelordUK)
• feat: implement smart numeric coercion and LIMIT/OFFSET clauses (TimelordUK)
• feat: migrate pinned_columns to buffer system (TimelordUK)
• docs: add TODO for fuzzy filter row count issue (TimelordUK)
• docs: update migration plan with current_column completion (TimelordUK)
• feat: migrate current_column to buffer system (TimelordUK)

🎯 Highlights

• Dynamic Column Sizing: Columns automatically adjust width based on visible data
• Compact Mode: Press 'C' to reduce padding and fit more columns
• Viewport Lock: Press Space to anchor scrolling position
• Auto-Execute: CSV/JSON files show data immediately on load
• Visual Source Indicators: See where your data comes from (📦 📁 🌐 🗄️)

📦 Installation

Download the appropriate binary for your platform from the assets below.

Supported Platforms

• Linux x64: sql-cli-linux-x64.tar.gz
• Windows x64: sql-cli-windows-x64.zip
• macOS x64 (Intel): sql-cli-macos-x64.tar.gz
• macOS ARM64 (Apple Silicon): sql-cli-macos-arm64.tar.gz

Quick Start

# Load a CSV file with instant preview
sql-cli data/customers.csv

# Connect to API
sql-cli --url http://localhost:5000

SQL CLI v1.9.2

SQL CLI v1.9.2

Release Date: August 07, 2025

✨ What's New

🚀 Features

• add auto-format build scripts
• migrate filter_state to use wrapper methods
• migrate table_state field to use buffer system wrappers
• migrate scroll_offset field to buffer system
• complete status_message field migration to buffer system
• add performance benchmarking and README performance section
• migrate 29 status_message calls to wrapper pattern
• start migrating status_message field to use wrapper methods
• add compatibility wrappers for core query/results state
• create GlobalState struct for application-wide state
• auto-clean history file on startup
• initialize BufferManager and add buffer debug to F5
• migrate Phase 1 simple fields to Buffer
• begin gradual migration to BufferAPI with edit_mode
• create BufferAPI abstraction layer for gradual migration
• add initial buffer system support with multiple file loading
• major TUI improvements with clipboard, cell mode, and configuration system
• improve editor functionality and cross-platform data paths

🐛 Bug Fixes

• clear fuzzy filter state when executing new queries
• complete remaining status_message migration issues
• resolve borrow checker issue in kill_line method
• complete status_message batch 3 migration - remaining calls
• clear fuzzy filter indicator when re-entering filter mode
• deduplicate command history entries
• apply case_insensitive config to CSV/JSON buffers
• properly initialize buffer when loading CSV/JSON files
• default to case-insensitive mode for practical use

📚 Documentation

• update migration plan with filter_state completion
• mark table_state migration as complete
• mark scroll_offset migration as complete in migration plan
• update migration plan with completed status_message and in-progress scroll_offset
• improve README clarity and add column search demo

📝 All Changes

Click to expand full commit list

• refactor: reorganize test files from src to tests folder (TimelordUK)
• test: add complex query parser tests (TimelordUK)
• feat: add auto-format build scripts (TimelordUK)
• docs: update migration plan with filter_state completion (TimelordUK)
• feat: migrate filter_state to use wrapper methods (TimelordUK)
• docs: mark table_state migration as complete (TimelordUK)
• feat: migrate table_state field to use buffer system wrappers (TimelordUK)
• docs: mark scroll_offset migration as complete in migration plan (TimelordUK)
• fix: clear fuzzy filter state when executing new queries (TimelordUK)
• refactor: move trade data generator to scripts directory (TimelordUK)
• docs: update migration plan with completed status_message and in-progress scroll_offset (TimelordUK)
• feat: migrate scroll_offset field to buffer system (TimelordUK)
• chore: add large trade data files to gitignore (TimelordUK)
• fix: complete remaining status_message migration issues (TimelordUK)
• fix: resolve borrow checker issue in kill_line method (TimelordUK)
• feat: complete status_message field migration to buffer system (TimelordUK)
• fix: complete status_message batch 3 migration - remaining calls (TimelordUK)
• Merge feat/status-message-batch2: status_message batch 2 migration (27 more calls) (TimelordUK)
• feat: add performance benchmarking and README performance section (TimelordUK)
• Merge feat/phase2b-field-migration: status_message field migration completed (TimelordUK)
• feat: migrate 29 status_message calls to wrapper pattern (TimelordUK)
• feat: start migrating status_message field to use wrapper methods (TimelordUK)
• Merge feat/buffer-phase2: Phase 2A migration infrastructure (TimelordUK)
• feat: add compatibility wrappers for core query/results state (TimelordUK)
• feat: create GlobalState struct for application-wide state (TimelordUK)
• Merge feat/buffer-system: Phase 1 buffer migration complete (TimelordUK)
• fix: clear fuzzy filter indicator when re-entering filter mode (TimelordUK)
• feat: auto-clean history file on startup (TimelordUK)
• fix: deduplicate command history entries (TimelordUK)
• fix: apply case_insensitive config to CSV/JSON buffers (TimelordUK)
• fix: properly initialize buffer when loading CSV/JSON files (TimelordUK)
• fix: default to case-insensitive mode for practical use (TimelordUK)
• feat: initialize BufferManager and add buffer debug to F5 (TimelordUK)
• test: add comprehensive test suite for complex queries (TimelordUK)
• feat: migrate Phase 1 simple fields to Buffer (TimelordUK)
• feat: begin gradual migration to BufferAPI with edit_mode (TimelordUK)
• feat: create BufferAPI abstraction layer for gradual migration (TimelordUK)
• feat: add initial buffer system support with multiple file loading (TimelordUK)
• feat: major TUI improvements with clipboard, cell mode, and configuration system (TimelordUK)
• docs: improve README clarity and add column search demo (TimelordUK)
• feat: improve editor functionality and cross-platform data paths (TimelordUK)

🎯 Highlights

• Dynamic Column Sizing: Columns automatically adjust width based on visible data
• Compact Mode: Press 'C' to reduce padding and fit more columns
• Viewport Lock: Press Space to anchor scrolling position
• Auto-Execute: CSV/JSON files show data immediately on load
• Visual Source Indicators: See where your data comes from (📦 📁 🌐 🗄️)

📦 Installation

Download the appropriate binary for your platform from the assets below.

Supported Platforms

• Linux x64: sql-cli-linux-x64.tar.gz
• Windows x64: sql-cli-windows-x64.zip
• macOS x64 (Intel): sql-cli-macos-x64.tar.gz
• macOS ARM64 (Apple Silicon): sql-cli-macos-arm64.tar.gz

Quick Start

# Load a CSV file with instant preview
sql-cli data/customers.csv

# Connect to API
sql-cli --url http://localhost:5000