How to Set Up DuckDB (Run SQL on a CSV With No Import Step)
dev.to
By Michael Nocito, data analyst · Published August 8, 2026 By the end of this page you will be running SQL directly against a CSV file on your machine, with no import step, no CREATE TABLE, and no schema written by hand. DuckDB reads the file where it lies, works out the column types itself, and gives you a normal SQL result. It takes one command to install and about a minute to prove. Here is what to actually do today. Run python -m pip install duckdb, then write a query with your CSV's filen