colvert 0.3.0

colvert is a Frontend for DuckDB a fast and lightweight in-memory database designed for analytical queries. It's design to be a simple and easy to use tool for data analysis and visualization.

Colvert

---

Table of Contents

• Colvert
  • Charts
    • Line
    • Pie
    • Maps
  • Installation
  • Usage
  • Documentation
  • License
  • FAQ
    • What does Colvert mean?

THIS PROJECT IS IN EARLY DEVELOPMENT

colvert is a tool for fast data exploration and visualization. Running on your machine you can explore large datasets using SQL an visualize them. AI generation of SQL queries is also supported.

colvert is a Frontend for DuckDB a fast and lightweight in-memory database designed for analytical queries. It's design to be a simple and easy to use tool for data analysis and visualization.

It's a web frontend running on top of DuckDB. It's support SQL queries and visualization using Plotly. Even if it's a web frontend it's designed to be used locally on your machine like a Jupyter notebook.

It's support loading data from CSV, Parquet, JSON files and directly from Hugging Face.

Using LiteLLM for AI support allow usage of multiple models like OpenAI, Anthropic, Mistral and more.

Charts

Line

Pie

Maps

Installation

We recommend installing colvert using pipx or uvx:

pipx install colvert

Pipx is a tool to install Python applications in isolated environments. It's a great way to install Python applications without cluttering your system Python environment.

Usage

colvert  open samples/test.csv 

This will detect the type of the file and open it in a new browser tab.

See the video below to see the tool in action:

Documentation

Once colvert is installed, you can access the documentation from the web interface. You can also access the documentation in the documentation folder.

License

colvert is distributed under the terms of the Apache 2.0 license.

FAQ

What does Colvert mean?

Colvert is the french name for the Mallard Duck. It's a reference to DuckDB the database engine used by Colvert and the fact the author is French and born in the region of France where Mallard Duck are important.

https://en.wikipedia.org/wiki/Mallard