📂 1. Supported File Format: CSV

Currently supports uploading and analyzing CSV files. The first row must contain field names (column names), and each subsequent row represents a data record.

⚠️ Notes

• Default delimiter is a comma ,
• UTF-8 encoding is recommended
• Avoid spaces or special characters in column names
• Table name is derived from file name (case-sensitive). Use English file names such as order.csv
• All data is loaded into browser memory, so performance depends on your device and browser
• If issues occur, please try the latest version of Chrome
• Data will be lost after page refresh or closing the page

Example CSV Content (employee.csv):

⚙️ 2. Basic Workflow

1. Upload one or more CSV files
2. System automatically loads them as tables (table name = file name)
3. Write SQL queries in the input box
4. Click the Query button to execute and view results

🧾 SQL Query Examples

-- Query all data
SELECT * FROM order.csv

-- Filter conditions
SELECT * FROM 'order.csv' WHERE price > 30

-- Aggregation
SELECT department, COUNT(*) FROM 'order.csv' GROUP BY department

📊 Multi-file Analysis (JOIN)

After uploading multiple CSV files, each file is registered as an independent table. You can perform JOIN operations for cross-file analysis:

-- Example: file1.csv and file2.csv
SELECT a.id, a.name, b.score
FROM file1.csv a
JOIN file2.csv b
ON a.id = b.id;

🔒 3. Data Security

All data processing is performed locally in your browser. Files are never uploaded to any server or stored anywhere, ensuring complete data privacy and security.