duckdb is so nice coupled with claude code. It extensive file support and some very interesting decisions on local caching data (like from S3 or snowflake) makes it easy to slice and dice almost any kind of tabular data.
Claude code can write exploratory queries for you to give you a quick rundown on the shape of the data set, frequencies, missing values, etc etc (without having to load it into a more persistent data store or writing custom python scripts). I also find SQL snippets inherently more re-usable than custom python code.
You can also write a skill that CC can re-use if you're analyzing a lot of similar data sets with minor variance.
Can you expand upon it? You mean claude code use it to store its memory/state or it can do business queries using DuckDB.