DuckDB

DuckDB’s CLI has colorful output with box-drawing tables. The quickest way to use it is with the built-in profile:

extensions:
  term:
    profile: duckdb

This sets shell: duckdb, prompt: "D", and ps2: ">". You may want to add -no-init to skip loading ~/.duckdbrc:

extensions:
  term:
    profile: duckdb
    shell-args: ["-no-init"]

Basic Queries

Creating Tables

Aggregation

Built-in Functions