duckdb -c "SELECT * FROM read_csv_auto('data.csv');"
Query a CSV file directly
read_csv_auto infers column types and reads the file without importing it — DuckDB's signature move for quick analytics. Works with Parquet via read_parquet. Related: COPY for exports.
Looking for more? Search all 7,657 commands — works offline, in English or Spanish, and fixes typos.