Skip to content

DuckDB Analytics

AI Platform & Data DuckDB v1.5.6 Hardened AMI

DuckDB Analytics is an Ubuntu 24.04 AMI with the official DuckDB v1.5.6 command-line tool, ready to query local CSV and Parquet files. The matching httpfs and aws extensions are pre-installed, so you can also read your own S3 data through an instance IAM role when you choose to.

AMI release
0.1.1 (DuckDB v1.5.6)
Recommended
t3.medium
Storage
16 GiB+ encrypted gp3
Access
Session Manager, no inbound ports
Released
Oct 30, 2026
Delivery
Amazon Machine Image in your own AWS account

Pinned DuckDB v1.5.6 official linux/amd64 CLI with provenance receipts.

Local CSV and Parquet queries with pinned httpfs and aws extensions.

Bundled configuration, backup and day-2 operations documentation.

Quick start

Full guide →
  1. Subscribe and launch
  2. Connect as `ubuntu`
  3. Wait for first boot
  4. Run the walkthrough
  5. Run your own query

What is included

Component Details
Operating system Ubuntu 24.04 LTS, x86_64
DuckDB CLI v1.5.6, official linux/amd64 build, at /usr/local/bin/duckdb
Extensions httpfs and aws for v1.5.6, pinned under /opt/sushi/share/duckdb/extensions/
Query wrapper /opt/sushi/bin/duckdb-sql, runs one SQL file with the pinned extensions and memory limits
Sample data /opt/sushi/share/duckdb/examples/orders.csv
Walkthrough /opt/sushi/docs/demo.sh and the bundled guide /opt/sushi/docs/README.md
Provenance /opt/sushi/evidence/duckdb-provenance.json

DuckDB is a command-line tool here. It does not run a server, does not listen on any TCP port, and the image does not include Jupyter or a web UI.

Ports

Port Purpose Exposure
22/tcp SSH, optional Only if you use SSH instead of Session Manager. Restrict it to your administrator CIDR.

No other inbound port is needed.

  • t3.medium (2 vCPU, 4 GiB RAM) or larger. At least 4 GiB RAM.
  • At least 16 GiB encrypted gp3 root volume. Leave room for query spill files.
  • IMDSv2.

Billing

You pay an hourly software fee, shown on the AWS Marketplace listing, for each running instance. EC2, EBS and data transfer are billed separately by AWS. See the offer terms on the listing for any free trial or promotion.

Tutorial

Watch on YouTube.

Where to go next

Upstream project

DuckDB is published by the DuckDB Foundation under the MIT license. Software Sushi packages it and is not affiliated with or endorsed by the DuckDB project.