Ducklit - query files in Streamlit with DuckDB

Hello!

I wanted to share my app that combines two excellent libraries - Streamlit and DuckDB.

This app lets you upload CSV and JSON and write SQL to query them. When you upload files in the side bar, it automatically loads them into DuckDB tables, which you can then interact with via the code editor. Any valid SQL that works with DuckDB can be run here. Also the DuckDB database is created in-memory, so no data is persisted.

Try the app here: https://ducklit.streamlit.app/
GitHub repo: GitHub - MarkyMan4/ducklit: A Streamlit app to upload files and query with DuckDB

6 Likes

This is a really great combination of duckdb & streamlit
can this be extended to files in AWS S3 without downloading the file ?