mmdbinspect - look up records for one or more IPs/networks in one or more .mmdb databases
mmdbinspect -db <path/to/your.mmdb> <IP|network>
db Path to a MMDB file. Can be specified multiple times.
<IP|network> An IP address, or network in CIDR notation. Can be
specified multiple times.Any IPs specified will be treated as their single-host network counterparts (e.g. 1.2.3.4 => 1.2.3.4/32).
mmdbinspect will look up each IP/network in each database specified. For each IP/network looked up in a database, the program will select all records for networks which are contained within the looked up IP/network. If no records for contained networks are found in the datafile, the program will select the record that is contained by the looked up IP/network. If no such records are found, none are selected.
The program outputs the selected records as a JSON array, with each item in the array corresponding to a single IP/network being looked up in a single DB. The Database and Lookup keys are added to each item to help correlate which set of records resulted from looking up which IP/network in which database.
This software is in beta. No guarantees are made, including relating to interface stability. Comments or suggestions for improvements are welcome on our GitHub issue tracker.
Release binaries have been made available for several popular platforms. Simply download the binary for your platform and run it.
Download and extract the appropriate tarball for your system. You will end up with a directory named something like mmdbinspect_0.0.0_linux_amd64 depending on the version and architecture.
Copy mmdbinspect to where you want it to live. To install it into /usr/local/bin/mmdbinspect, run the equivalent of sudo cp mmdbinspect_0.0.0_linux_amd64/mmdbinspect /usr/local/bin.
(N.B. You can also use the tarball.)
Download the appropriate .deb for your system.
Run dpkg -i path/to/mmdbinspect_0.0.0_linux_amd64.deb (replacing the version number and architecture as necessary). You will need to be root. For Ubuntu you can prefix the command with sudo. This will install mmdbinspect to /usr/bin/mmdbinspect.
(N.B. You can also use the tarball.)
Run rpm -i path/to/mmdbinspect_0.0.0_linux_amd64.rpm (replacing the version number and architecture as necessary). You will need to be root. This will install mmdbinspect to /usr/bin/mmdbinspect.
This is the same as installing on Linux via the tarball, except choose a tarball with "darwin" in the name.
Download and extract the appropriate zip for your system. You will end up with a directory named something like mmdbinspect_0.0.0_windows_amd64 depending on the version and architecture.
Copy mmdbinspect.exe to where you want it to live.
We aim always to support the current and penultimate major releases of the Go compiler. You can get it at the Go website.
The easiest way is via go install:
$ go install github.com/maxmind/mmdbinspect/cmd/mmdbinspect@latestThis installs mmdbinspect to $GOPATH/bin/mmdbinspect.
A simple lookup (one IP/network, one DB)
$ mmdbinspect -db GeoIP2-Country.mmdb 152.216.7.110
[
{
"Database": "GeoIP2-Country.mmdb",
"Records": [
{
"Network": "152.216.7.110/12",
"Record": {
"continent": {
"code": "NA",
"geoname_id": 6255149,
"names": {
"de": "Nordamerika",
"en": "North America",
"es": "Norteamérica",
"fr": "Amérique du Nord",
"ja": "北アメリカ",
"pt-BR": "América do Norte",
"ru": "Северная Америка",
"zh-CN": "北美洲"
}
},
"country": {
"geoname_id": 6252001,
"iso_code": "US",
"names": {
"de": "USA",
"en": "United States",
"es": "Estados Unidos",
"fr": "États-Unis",
"ja": "アメリカ合衆国",
"pt-BR": "Estados Unidos",
"ru": "США",
"zh-CN": "美国"
}
},
"registered_country": {
"geoname_id": 6252001,
"iso_code": "US",
"names": {
"de": "USA",
"en": "United States",
"es": "Estados Unidos",
"fr": "États-Unis",
"ja": "アメリカ合衆国",
"pt-BR": "Estados Unidos",
"ru": "США",
"zh-CN": "美国"
}
}
}
}
],
"Lookup": "152.216.7.110"
}
]Look up one IP/network in multiple databases
$ mmdbinspect -db GeoIP2-Country.mmdb -db GeoIP2-City.mmdb 152.216.7.110
[
{
"Database": "GeoIP2-Country.mmdb",
"Records": [
{
"Network": "152.216.7.110/12",
"Record": {
"continent": {
"code": "NA",
"geoname_id": 6255149,
"names": {
"de": "Nordamerika",
"en": "North America",
"es": "Norteamérica",
"fr": "Amérique du Nord",
"ja": "北アメリカ",
"pt-BR": "América do Norte",
"ru": "Северная Америка",
"zh-CN": "北美洲"
}
},
"country": {
"geoname_id": 6252001,
"iso_code": "US",
"names": {
"de": "USA",
"en": "United States",
"es": "Estados Unidos",
"fr": "États-Unis",
"ja": "アメリカ合衆国",
"pt-BR": "Estados Unidos",
"ru": "США",
"zh-CN": "美国"
}
},
"registered_country": {
"geoname_id": 6252001,
"iso_code": "US",
"names": {
"de": "USA",
"en": "United States",
"es": "Estados Unidos",
"fr": "États-Unis",
"ja": "アメリカ合衆国",
"pt-BR": "Estados Unidos",
"ru": "США",
"zh-CN": "美国"
}
}
}
}
],
"Lookup": "152.216.7.110"
},
{
"Database": "GeoIP2-City.mmdb",
"Records": [
{
"Network": "152.216.7.110/14",
"Record": {
"continent": {
"code": "NA",
"geoname_id": 6255149,
"names": {
"de": "Nordamerika",
"en": "North America",
"es": "Norteamérica",
"fr": "Amérique du Nord",
"ja": "北アメリカ",
"pt-BR": "América do Norte",
"ru": "Северная Америка",
"zh-CN": "北美洲"
}
},
"country": {
"geoname_id": 6252001,
"iso_code": "US",
"names": {
"de": "USA",
"en": "United States",
"es": "Estados Unidos",
"fr": "États-Unis",
"ja": "アメリカ合衆国",
"pt-BR": "Estados Unidos",
"ru": "США",
"zh-CN": "美国"
}
},
"location": {
"accuracy_radius": 1000,
"latitude": 37.751,
"longitude": -97.822,
"time_zone": "America/Chicago"
},
"registered_country": {
"geoname_id": 6252001,
"iso_code": "US",
"names": {
"de": "USA",
"en": "United States",
"es": "Estados Unidos",
"fr": "États-Unis",
"ja": "アメリカ合衆国",
"pt-BR": "Estados Unidos",
"ru": "США",
"zh-CN": "美国"
}
}
}
}
],
"Lookup": "152.216.7.110"
}
]Look up multiple IPs/networks in a single database
$ mmdbinspect -db GeoIP2-Connection-Type.mmdb 152.216.7.110/20 2001:0:98d8::/64
[
{
"Database": "GeoIP2-Connection-Type.mmdb",
"Records": [
{
"Network": "152.216.0.0/13",
"Record": {
"connection_type": "Corporate"
}
}
],
"Lookup": "152.216.7.110/20"
},
{
"Database": "GeoIP2-Connection-Type.mmdb",
"Records": [
{
"Network": "2001:0:98d8::/45",
"Record": {
"connection_type": "Corporate"
}
}
],
"Lookup": "2001:0:98d8::/64"
}
]Look up multiple IPs/networks in multiple databases
$ mmdbinspect -db GeoIP2-DensityIncome.mmdb -db GeoIP2-User-Count.mmdb 152.216.7.32/27 2610:30::/64
[
{
"Database": "GeoIP2-DensityIncome.mmdb",
"Records": [
{
"Network": "152.216.7.32/21",
"Record": {
"average_income": 26483,
"population_density": 1265
}
}
],
"Lookup": "152.216.7.32/27"
},
{
"Database": "GeoIP2-DensityIncome.mmdb",
"Records": [
{
"Network": "2610:30::/38",
"Record": {
"average_income": 30369,
"population_density": 934
}
}
],
"Lookup": "2610:30::/64"
},
{
"Database": "GeoIP2-User-Count.mmdb",
"Records": [
{
"Network": "152.216.7.32/27",
"Record": {
"ipv4_24": 6,
"ipv4_32": 0
}
}
],
"Lookup": "152.216.7.32/27"
},
{
"Database": "GeoIP2-User-Count.mmdb",
"Records": [
{
"Network": "2610:30::/27",
"Record": {
"ipv6_32": 0,
"ipv6_48": 0,
"ipv6_64": 0
}
}
],
"Lookup": "2610:30::/64"
}
]Look up a file of IPs/networks using the xargs utility
$ cat list.txt
152.216.7.32/27
2610:30::/64
$ cat list.txt | xargs mmdbinspect -db GeoIP2-ISP.mmdb
[
{
"Database": "/usr/local/share/GeoIP/GeoIP2-ISP.mmdb",
"Records": [
{
"Network": "152.216.7.32/20",
"Record": {
"autonomous_system_number": 30313,
"autonomous_system_organization": "IRS",
"isp": "Internal Revenue Service",
"organization": "Internal Revenue Service"
}
}
],
"Lookup": "152.216.7.32/27"
},
{
"Database": "/usr/local/share/GeoIP/GeoIP2-ISP.mmdb",
"Records": [
{
"Network": "2610:30::/32",
"Record": {
"autonomous_system_number": 30313,
"autonomous_system_organization": "IRS",
"isp": "Internal Revenue Service",
"organization": "Internal Revenue Service"
}
}
],
"Lookup": "2610:30::/64"
}
]Tame the output with the jq utility
Print out the isp field from each result found:
$ mmdbinspect -db GeoIP2-ISP.mmdb 152.216.7.32/27 | jq -r '.[].Records[].Record.isp'
Internal Revenue ServicePrint out the isp field from each result found in a specific format using string addition:
$ mmdbinspect -db GeoIP2-ISP.mmdb 152.216.7.32/27 | jq -r '.[].Records[].Record | "isp=" + .isp'
isp=Internal Revenue ServicePrint out the city and country names from each record using string addition:
$ mmdbinspect -db GeoIP2-City.mmdb 2610:30::/64 | jq -r '.[].Records[].Record | .city.names.en + ", " + .country.names.en'
Martinsburg, United StatesPrint out the city and country names from each record using array construction and join:
$ mmdbinspect -db GeoIP2-City.mmdb 2610:30::/64 | jq -r '.[].Records[].Record | [.city.names.en, .country.names.en] | join(", ")'
Martinsburg, United StatesGet the AS number for an IP:
$ mmdbinspect -db GeoLite2-ASN.mmdb 152.216.7.49 | jq -r '.[].Records[].Record.autonomous_system_number'
30313When asking jq to print a path it can't find, it'll print null:
$ mmdbinspect -db GeoIP2-City.mmdb 152.216.7.49 | jq -r '.[].invalid.path'
nullWhen asking jq to concatenate or join a path it can't find, it'll leave it blank:
$ mmdbinspect -db GeoIP2-City.mmdb 152.216.7.49 | jq -r '.[].Records[].Record | .city.names.en + ", " + .country.names.en'
, United States
$ mmdbinspect -db GeoIP2-City.mmdb 152.216.7.49 | jq -r '.[].Records[].Record | [.city.names.en, .country.names.en] | join(", ")'
, United StatesPlease report bugs by filing an issue with our GitHub issue tracker at https://github.com/maxmind/mmdbinspect/issues.
This software is Copyright (c) 2019 - 2021 by MaxMind, Inc.
This is free software, licensed under the Apache License, Version 2.0 or the MIT License, at your option.