Apple Private Relay · SQL

SQL inserts to load Apple Private Relay CIDRs into a database table. 287,816 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 ('104.28.28.0/32', 'IPv4');
INSERT INTO `apple_private_relay_ips` (`ip_address`, `ip_type`) VALUES ('104.28.28.1/32', 'IPv4');
INSERT INTO `apple_private_relay_ips` (`ip_address`, `ip_type`) VALUES ('104.28.28.2/32', 'IPv4');
INSERT INTO `apple_private_relay_ips` (`ip_address`, `ip_type`) VALUES ('104.28.28.3/32', 'IPv4');
INSERT INTO `apple_private_relay_ips` (`ip_address`, `ip_type`) VALUES ('104.28.28.4/32', 'IPv4');
INSERT INTO `apple_private_relay_ips` (`ip_address`, `ip_type`) VALUES ('104.28.28.5/32', 'IPv4');
INSERT INTO `apple_private_relay_ips` (`ip_address`, `ip_type`) VALUES ('104.28.28.6/32', 'IPv4');
INSERT INTO `apple_private_relay_ips` (`ip_address`, `ip_type`) VALUES ('104.28.28.7/32', 'IPv4');
INSERT INTO `apple_private_relay_ips` (`ip_address`, `ip_type`) VALUES ('104.28.28.8/32', 'IPv4');
INSERT INTO `apple_private_relay_ips` (`ip_address`, `ip_type`) VALUES ('104.28.28.9/32', 'IPv4');
INSERT INTO `apple_private_relay_ips` (`ip_address`, `ip_type`) VALUES ('104.28.28.10/32', 'IPv4');
INSERT INTO `apple_private_relay_ips` (`ip_address`, `ip_type`) VALUES ('104.28.28.11/32', 'IPv4');
INSERT INTO `apple_private_relay_ips` (`ip_address`, `ip_type`) VALUES ('104.28.28.12/32', 'IPv4');
INSERT INTO `apple_private_relay_ips` (`ip_address`, `ip_type`) VALUES ('104.28.28.13/32', 'IPv4');
INSERT INTO `apple_private_relay_ips` (`ip_address`, `ip_type`) VALUES ('104.28.28.14/32', 'IPv4');
INSERT INTO `apple_private_relay_ips` (`ip_address`, `ip_type`) VALUES ('104.28.28.15/32', 'IPv4');
INSERT INTO `apple_private_relay_ips` (`ip_address`, `ip_type`) VALUES ('104.28.28.16/32', 'IPv4');
… (287799 more lines)