v0.1.8 - Files as Databases, Analyze Instantly

🎉 Highlights

This release introduces multi-source connection support for connecting to local files and remote data sources, enabling powerful data analysis capabilities beyond traditional MySQL databases.

✨ New Features

Multi-Source Connection Support

Connect to multiple data sources seamlessly:

• Local Files: CSV and Excel (.xlsx) files
• Remote Files: HTTP/HTTPS URLs for data files
• Multiple Files: Connect to multiple files simultaneously in a single session

Example:

# Connect to a local CSV file
> /connect sales.csv

# Connect to multiple files
> /connect file1.csv file2.xlsx

# Connect to a remote file
> /connect https://example.com/data.csv

Data Analysis Tool

New DataAnalyzer tool for executing analytical SQL queries:

• Support for complex analytical queries (CTEs, JOINs, aggregations, window functions)
• Statistical analysis capabilities (COUNT, SUM, AVG, MIN, MAX, STDDEV, etc.)
• Works seamlessly with MySQL databases and file-based data sources

One-Click Installation

New installation script for easier setup:

curl -LsSf https://raw.githubusercontent.com/aliyun/rdsai-cli/main/install.sh | sh

Also includes version option (--version, -v) to display CLI version.

Simplified MySQL Tools

• Consolidated MySQL utility module for better maintainability
• Enhanced MySQLSelect, MySQLShow, and new MySQLDesc tools
• Removed redundant tools in favor of a unified approach

🐛 Bug Fixes

• Fixed connection interruption handling during database connection
• Improved error messages and recovery mechanisms
• Better user experience when connection fails

📚 Documentation

• Added comprehensive guide for local file analysis scenario
• Examples for CSV and Excel file analysis
• Available in both English and Chinese

🔗 Links

• Full Changelog
• Local File Analysis Guide
• Documentation