Colvert: A DuckDB frontend using Monaco editor

[julien-duponchelle]

Hello,

I wanted to share with you a small project I worked on. In my day-to-day life, I often need to manipulate large CSV files, and DuckDB is very good for that. But I wanted to get a smother experience with graphic support, very fast feedback loops and a good SQL editor.

So using the Monaco editor I wrote this Python UX:

The result is refreshed as you type.

With support of Plotly graph:

And even a toy AI integration:

You can see a demo here:
https://youtu.be/Y62QNmr2J3k

In order to make my deployment more easy I have repackage the Monaco editor as a Python Package: https://github.com/julien-duponchelle/rocher

It's amazing how easy it was to have an SQL editor that I can embed in my application.

https://github.com/julien-duponchelle/colvert/