NetFlow v5/v9, IPFIX and sFlow datagrams in SQL — probe export version, decode the header as a STRUCT, triage well-formedness, pure Rust no libnetflow
Maintainer(s):
alitrack
Compatibility Matrix
This table covers all DuckDB releases that have not reached end-of-life, including LTS releases, and shows the 2 most recent patch releases of each. Older patch releases are not listed, but the extension may be available for them as well.
| Platform | 1.4.4 | 1.4.5 | 1.5.5 | 1.5.6 | 2.0.0 |
|---|---|---|---|---|---|
| Linux AMD64 | |||||
| Linux ARM64 | |||||
| macOS AMD64 | |||||
| macOS ARM64 | |||||
| Windows AMD64 | |||||
| Windows ARM64 | |||||
| WebAssembly |
Installing and Loading
INSTALL netflow FROM community;
LOAD netflow;
Example
INSTALL netflow FROM community;
LOAD netflow;
-- A NetFlow v5 datagram (header + records) as a BLOB
SELECT netflow_version(from_hex('00050001000000000000000000000007'));
SELECT netflow_header(from_hex('00050001000000000000000000000007'));
SELECT (netflow_well_formed(from_hex('00050001000000000000000000000007'))).ok;
About netflow
netflow — flow exports in SQL
Decoder compiled in, pure Rust (no pdq, no libnetflow, no Suricata).
The datagram is a BLOB column; header fields come back as a STRUCT you can
filter, join and aggregate on.
| Function | Returns | Notes |
|---|---|---|
netflow_version(payload) |
VARCHAR |
'5' / '9' / '10' / 'sflow5', NULL when unrecognized |
netflow_header(payload) |
STRUCT | Decoded export header (version, count, sys_uptime, export_time, sequence, obs_domain) |
netflow_well_formed(payload) |
STRUCT |
ok / kind / error triage |
→ GitHub
Added Functions
| function_name | function_type | description | comment | examples |
|---|---|---|---|---|
| netflow_header | scalar | NULL | NULL | |
| netflow_version | scalar | NULL | NULL | |
| netflow_well_formed | scalar | NULL | NULL |
Overloaded Functions
This extension does not add any function overloads.
Added Types
This extension does not add any types.
Added Settings
| name | description | input_type | scope | aliases | typed_value |
|---|---|---|---|---|---|
| temp_directory | Set the directory to which temporary files are written. | VARCHAR | GLOBAL | [] | post.db.tmp |
© 2026 DuckDB Foundation, Amsterdam NL