I built Knowhere, a lightweight SQL engine written in Rust that lets you query CSV, Parquet, Delta Lake, and SQLite files directly—no database import required.
It’s built on top of Apache DataFusion for high-performance vectorized query execution and supports two interfaces:
1. Interactive TUI: A Vim-style terminal interface (using Ratatui) for quick data exploration.
2. Desktop GUI: A modern IDE-like experience (built with Tauri + React) with a Monaco editor and glorious dark mode.
I wanted a tool that combines the speed of DataFusion with a rich user experience for local data analysis. It handles joins across different file formats, supports complex queries (CTEs, Window Functions), and requires zero configuration to get started.
The project is open source (MIT). I’d love to hear your feedback on the TUI/GUI approach!