Lens through your data. Built with 
Tauri
Powerful, lightweight application that provides an interactive interface to run SQL queries on structured files, including Parquet, CSV, and JSON formats.
You can use Lens locally or directly access data stored in cloud services like Amazon AWS or Google GCP.
Lens simplifies data analysis by allowing you to query, transform, and visualize data without complex setup or external databases.
- 📁 Support for Multiple File Formats: Query data stored in Parquet, CSV, and JSON files.
- 🌥 Cloud Integration: Seamlessly connect to cloud storage services like AWS S3 or Google Cloud Storage to run SQL queries on remote datasets.
- 💻 Local Support: Run SQL queries on files located on your local machine.
- 🖊 SQL Interface: Use familiar SQL syntax to query and transform data.
- 📔 Query History: Save and replay previous SQL queries to streamline repetitive tasks.
- 👁 Data Visualization: View query results in tabular format
- 🔒 Privacy: No data is sent to any external service. Files are processed either locally or directly from your cloud provider.
- 💾 Export Results: Easily export query results to CSV, JSON, or other formats.
Lens is built with tauri using a Rust backend. To build lens from source, first clone the git repository:
git clone https://github.com/oktal/lens.gitThen, to install all the dependencies required for tauri, you can follow the official Prerequisites section of the Tauri' documentation
Use rustup to install Rust on your system. Also make sure to install Nodejs
Once you followed all the steps described in the previous section, build and start lens through npm:
npm install
npm run tauri dev- Monaco-based SQL editor
- Syntax highlighting
- Auto completion
- Integration with other database systems: MySQL, PostgreSQL, SQLite, DuckDB
- Charts
- Configuration options
- Expose DataFusion session configuration parameters in the UI
- Profile-based configuration
- Querybook as way to share queries between developers and users, like Jupyter Notebook
Lens is a free and open-source software but if you want to sponsor me, as a specialty coffee lover you can
This project is licensed under the MIT License. See the LICENSE file for more details.
