InsightSQL

English | 中文

A tool that can quickly view Excel, CSV and Parquet using SQL, base on Tauri.

screenshot

• polars SQL for query

  

• Cat

  

• Rename

  

• select

  

✨Features

• Use Polars SQL for querying, allows to load Excel, CSV and Parquet files, support exporting as csv or xlsx files
• Concatenate CSV and Excel files
• Exports Excel to a csv file
• Count the rows of CSV files
• Exports csv to a xlsx file
• Rename the columns of a CSV
• Select, re-order columns
• Select fields matching rows
• Fill empty fields in selected columns of a CSV
• Split one CSV file into many CSV files
• Add an index for a CSV
• Drop headers from CSV

🍖How to use?

• Download InsightSQL.7z, extract and run InsightSQL.exe

🏃‍Runtime Environment

• Node.js 18+
• pnpm 9.9.0+
• 🦀Rust 1.81.0+

🚀Development

1. Clone this repositories

   git clone https://github.com/tansen87/InsightSQL.git

2. cd to the directory of the project

   cd InsightSQL

3. Install dependencies

   pnpm i

4. Development

   pnpm tauri:dev

5. Build

   pnpm tauri:build

video

• bilibili

Thanks

• tauri-pure-admin
• qsv