Apple Private Relay · SQL

SQL inserts to load Apple Private Relay CIDRs into a database table. 286,912 CIDRs, refreshed daily.
// apple_private_relay_ips.sql

DOWNLOAD ↓ ·
-- SQL script to create table `apple_private_relay_ips` and insert IP addresses

CREATE TABLE IF NOT EXISTS `apple_private_relay_ips` (
  `ip_address` VARCHAR(45) NOT NULL,
  `ip_type` VARCHAR(10) NOT NULL,
  PRIMARY KEY (`ip_address`)
);

INSERT INTO `apple_private_relay_ips` (`ip_address`, `ip_type`) VALUES ('172.224.226.0/27', 'IPv4');
INSERT INTO `apple_private_relay_ips` (`ip_address`, `ip_type`) VALUES ('172.224.226.32/31', 'IPv4');
INSERT INTO `apple_private_relay_ips` (`ip_address`, `ip_type`) VALUES ('172.224.226.34/31', 'IPv4');
INSERT INTO `apple_private_relay_ips` (`ip_address`, `ip_type`) VALUES ('172.224.226.36/31', 'IPv4');
INSERT INTO `apple_private_relay_ips` (`ip_address`, `ip_type`) VALUES ('172.224.226.38/31', 'IPv4');
INSERT INTO `apple_private_relay_ips` (`ip_address`, `ip_type`) VALUES ('172.224.226.40/31', 'IPv4');
INSERT INTO `apple_private_relay_ips` (`ip_address`, `ip_type`) VALUES ('172.224.226.42/31', 'IPv4');
INSERT INTO `apple_private_relay_ips` (`ip_address`, `ip_type`) VALUES ('172.224.226.44/31', 'IPv4');
INSERT INTO `apple_private_relay_ips` (`ip_address`, `ip_type`) VALUES ('172.224.226.46/31', 'IPv4');
INSERT INTO `apple_private_relay_ips` (`ip_address`, `ip_type`) VALUES ('172.224.226.48/31', 'IPv4');
INSERT INTO `apple_private_relay_ips` (`ip_address`, `ip_type`) VALUES ('172.224.226.50/31', 'IPv4');
INSERT INTO `apple_private_relay_ips` (`ip_address`, `ip_type`) VALUES ('172.224.226.52/31', 'IPv4');
INSERT INTO `apple_private_relay_ips` (`ip_address`, `ip_type`) VALUES ('172.224.226.54/31', 'IPv4');
INSERT INTO `apple_private_relay_ips` (`ip_address`, `ip_type`) VALUES ('172.224.226.56/31', 'IPv4');
INSERT INTO `apple_private_relay_ips` (`ip_address`, `ip_type`) VALUES ('172.224.226.58/31', 'IPv4');
INSERT INTO `apple_private_relay_ips` (`ip_address`, `ip_type`) VALUES ('172.224.226.60/31', 'IPv4');
INSERT INTO `apple_private_relay_ips` (`ip_address`, `ip_type`) VALUES ('172.224.226.62/31', 'IPv4');
… (286895 more lines)