To cut a short story even shorter, in the end I selected Digital Ocean's NetBox IP address management (IPAM) and data center infrastructure management (DCIM) tool. It uses PostgreSQL as it's backing database, which in my mind, was a significant deciding factor for me as it has built in field types to support both IPv4 and IPv6 style ip addresses and CIDRs. MySQL/MariaDB does not have that capability natively. Performing subnet/supernet queries in PostgreSQL is a great way to look for address and subnets easily and efficiently without resorting to third party libraries.
For the longer version of the story, here are some other IPAM tools I encountered in my travels:
- RackTables: a datacenter asset management system seeming to rely on MySQL. But it does seem to be more detail oriented to identifying and locating gear in racks.
- Netdot: NETwork Documentation Tool, a Perl based tool which, as a strength, can perform network scans with CDP/LLDP, switch forwarding tables, and router tables to build it's relationship database. I think it can use either MySQL or PostgreSQL. But I'm not sure if it is maintained much, because as of this date, the last release was 2014/08/12. There is a repository with some updates as of 2016/06/16.
- HaCi is an IP Address / Network Administration Tool with IPv6 support. This seems to be strictly an IP Address manager, with the last indicated revision of 2015/03/04.
- OpenNetAdmin provides a database managed inventory of an IP network. Unique to this product is a command line interface. Also unique, is the ability for tracking DNS records. It does have contexts to allow over-lapping addresses (a multi-tenant situation). But it seems to be oriented more towards MySQL. The features page lists other abilities. It looks featureful, however, the last git commit is listed as 2016/03/16.
- Not quite related, but here for the fact I encountered it: NetHead -- IP Allocation Tool is based on the original RIPE registry software.
- Wikiwand has a larger table oriented listing of IP Address Management tools, both commercial as well as open source, with an indication of databases solutions supported.
- nipap is a "sleek, intuitive and powerful IP address management system built to handle large amounts of IP addresses". Written in Python, using PostgreSQL for a data store, and supports IPv6. So a CLI is not unique thing, as nipap has one as well. VRF management is included.
- phpipam is one of the first IPAM solutions I heard about, but was one of the later ones to build in IPv6 capability. It has matured considerably, and is actively maintained.
- NOC Project is interesting as it knows about QinQ style networks. But it doesn't look like it is currently maintained.
- GestiĆ³IP is another address manager, but it doesn't seem to have recent activity either. And no special feature which stands out.
- NetMagis supports IPv4 and IPv6, generates DNS zone files, has an LDAP privilege system, can generate network maps, and has some sort of traffic map capability. The most recent github commit is about five months ago.