Search Shortcut cmd + k | ctrl + k

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
DuckDB Home Code of Conduct Trademark Use Blog