Three synchronized artifact formats compiled from every snapshot
Every database subscription includes binary MMDB for sub-microsecond application lookups, Apache Parquet for vectorized warehouse joins, and gzipped CSV for relational bulk loading.
Compatible with standard MMDB readers in every language
Our compiler outputs strict MMDB binary format v2.0 files containing a unified IPv4 and IPv6 search tree and a deduplicated data section. Open the file with mmap and share it across worker processes with zero serialization overhead.
- Works out of the box with standard MMDB readers in C, NGINX, Envoy, Python, Node.js, Rust, Go, and Java.
- Nested dictionary structure matches our REST API JSON response (geo, network, connection, security, security_extensions).
import maxmind from 'maxmind';
const reader = await maxmind.open('/var/lib/ipscope/ipscope-complete.mmdb');
const record = reader.get('198.51.100.7');
console.log(record?.geo?.country_code, record?.security?.is_vpn);Vectorized columnar scans in analytical SQL engines and relational databases
For SIEM log backfills, data warehouse enrichment, and SQL analytics, nested fields are flattened into typed columns with cidr, ip_version, start_ip, and end_ip keys.
- Parquet files are ZSTD-compressed and row-group sorted by IP family and network start address for fast predicate pushdown.
- CSV.gz files follow strict UTF-8 RFC 4180 formatting for one-line relational COPY ingestion.
SELECT
country_code,
COUNT(*) AS vpn_prefixes,
COUNT(DISTINCT asn) AS distinct_asns
FROM read_parquet('ipscope-complete.parquet')
WHERE is_vpn = true
GROUP BY country_code
ORDER BY vpn_prefixes DESC
LIMIT 10;Artifact format comparison
All three formats are included at no extra cost on every database subscription.
| Format | File Extension | Compression | Primary Use Case | Typical Query Speed |
|---|---|---|---|---|
| Open MMDB v2.0 | .mmdb | Binary pointer deduplication | Real-time backend APIs, edge workers, reverse proxies | < 1 µs per IP via mmap |
| Apache Parquet | .parquet | ZSTD columnar | Columnar SQL engines & analytical data warehouses | Millions of rows/sec scan |
| Comma-Separated Values | .csv.gz | Gzip (RFC 1952) | Relational database COPY & custom ETL scripts | Sequential stream import |
Start with 30K free lookups a month.
No card, no trial clock. Upgrade when your traffic does, or download the database when you would rather keep it in-house.