agentskillexchange DuckDB SQL Analytics Agent
Run analytical SQL queries on local files (CSV, Parquet, JSON) using the DuckDB in-process database engine. Enables fast OLAP-style analysis without a server, directly from flat files on disk.
Installation
Use the upstream install or setup path that matches your environment:
- For development, DuckDB requires CMake, Python 3 and a C++17 compliant compiler. In the root directory, run make to compile the sources. For development, use make debug to build a non-optimized de...
Requirements and caveats from upstream:
- DuckDB is available as a standalone CLI application and has clients for Python, [R](https://duckdb.org...
Basic usage or getting-started notes:
If you want to install DuckDB, please see our installation page for instructions.
Data Import
For CSV files and Parquet files, data import is as simple as referencing the file in the FROM clause:
Source: https://github.com/duckdb/duckdb
Extracted from upstream docs: https://raw.githubusercontent.com/duckdb/duckdb/HEAD/README.md