.duckdb QA Fixtures Data Engineering & Columnar CC0 Public Domain · CI/CD Safe

Sample .duckdb (DuckDB) Test Files & Edge Cases

Deterministic DuckDB Analytical Database File fixtures engineered for automated unit tests, parser fuzzing, and upload validation pipelines. Pull directly in GitHub Actions with immutable SHA-256 verification.

minimalexpect: valid

minimal-v64.duckdb

Real single-table DuckDB database produced by duckdb.connect() — includes valid checksum preamble and DUCK magic.

↓ Download (524.0 KB)

SHA-256: 465f054e7e501c946c263070389322a8f1f96195ab9bb115a1e80d34401298f5

Exact: 536,576 bytes

curl -fsSL https://fileformat.co/fixtures/v1/duckdb/minimal-v64.duckdb -o minimal-v64.duckdb \
  && echo "465f054e7e501c946c263070389322a8f1f96195ab9bb115a1e80d34401298f5  minimal-v64.duckdb" | shasum -a 256 -c

realisticexpect: valid

analytics-store.duckdb

Real DuckDB database with two tables, primary keys, and a secondary index.

↓ Download (1.51 MB)

SHA-256: 92b98fd5e4954d171d464a36c6cfe175d15e12d09f8492382ed11458fdeb8278

Exact: 1,585,152 bytes

curl -fsSL https://fileformat.co/fixtures/v1/duckdb/analytics-store.duckdb -o analytics-store.duckdb \
  && echo "92b98fd5e4954d171d464a36c6cfe175d15e12d09f8492382ed11458fdeb8278  analytics-store.duckdb" | shasum -a 256 -c

edge-caseUnaligned 20B Truncationexpect: parser_error

truncated-header.duckdb

First 20 bytes of a real DuckDB file — duckdb.connect() must raise 'not a valid DuckDB database file'.

↓ Download (20 B)

SHA-256: b9fb1ef9dc5827bddb7c61b93433aea5cdbcb75d63941f72704906f6ddeb45b8

Exact: 20 bytes

curl -fsSL https://fileformat.co/fixtures/v1/duckdb/truncated-header.duckdb -o truncated-header.duckdb \
  && echo "b9fb1ef9dc5827bddb7c61b93433aea5cdbcb75d63941f72704906f6ddeb45b8  truncated-header.duckdb" | shasum -a 256 -c

Safe-by-Design Client-Side Synthesizer

In-Browser Edge-Case & Malformed Fixture Mutator

Zero Upload · Generated in RAM

Need negative test fixtures for parser fuzzing or upload gateway validation? Mutate minimal-v64.duckdb directly in your browser without hosting unsafe payloads on public URLs.

1. Base Input Source

Default Fixture: minimal-v64.duckdb

2. Select Mutation Operator

Tests graceful EOF / footer corruption handling without process panic or OOM.