Skip to main content
In the chDB and DuckDB databases, you can easily query local files with SQL. You can query CSV, JSON, Parquet & more. Drag-and-drop a file into the SQL query editor, and run queries on the file right away. This is great for quick ad-hoc queries. If you don’t want to write queries by hand, consider to instead attach the file as a source (currently possible with chDB connections only). This allows you to use the AI Assistant and the data explorer UI for your file.
When you drag-and-drop a file into an empty query editor, the editor will be populated with a default query to select from your file: Alternatively, if the editor is not empty, only the file’s identifier will be inserted at the cursor position:

​
Learn More

To learn more on how to query files with chDB/ClickHouse, or with DuckDB: