Mullvad VPN · SQL

SQL inserts to load Mullvad VPN CIDRs into a database table. 1,140 CIDRs, refreshed daily.
// mullvad_ips.sql

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

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

INSERT INTO `mullvad_ips` (`ip_address`, `ip_type`) VALUES ('23.144.160.67/32', 'IPv4');
INSERT INTO `mullvad_ips` (`ip_address`, `ip_type`) VALUES ('23.144.160.86/32', 'IPv4');
INSERT INTO `mullvad_ips` (`ip_address`, `ip_type`) VALUES ('23.144.160.106/32', 'IPv4');
INSERT INTO `mullvad_ips` (`ip_address`, `ip_type`) VALUES ('23.159.216.3/32', 'IPv4');
INSERT INTO `mullvad_ips` (`ip_address`, `ip_type`) VALUES ('23.159.216.127/32', 'IPv4');
INSERT INTO `mullvad_ips` (`ip_address`, `ip_type`) VALUES ('23.160.24.3/32', 'IPv4');
INSERT INTO `mullvad_ips` (`ip_address`, `ip_type`) VALUES ('23.160.24.127/32', 'IPv4');
INSERT INTO `mullvad_ips` (`ip_address`, `ip_type`) VALUES ('23.162.8.3/32', 'IPv4');
INSERT INTO `mullvad_ips` (`ip_address`, `ip_type`) VALUES ('23.162.8.67/32', 'IPv4');
INSERT INTO `mullvad_ips` (`ip_address`, `ip_type`) VALUES ('23.162.8.130/32', 'IPv4');
INSERT INTO `mullvad_ips` (`ip_address`, `ip_type`) VALUES ('23.162.40.3/32', 'IPv4');
INSERT INTO `mullvad_ips` (`ip_address`, `ip_type`) VALUES ('23.162.40.127/32', 'IPv4');
INSERT INTO `mullvad_ips` (`ip_address`, `ip_type`) VALUES ('23.168.216.3/32', 'IPv4');
INSERT INTO `mullvad_ips` (`ip_address`, `ip_type`) VALUES ('23.168.216.127/32', 'IPv4');
INSERT INTO `mullvad_ips` (`ip_address`, `ip_type`) VALUES ('23.234.68.2/32', 'IPv4');
INSERT INTO `mullvad_ips` (`ip_address`, `ip_type`) VALUES ('23.234.68.127/32', 'IPv4');
INSERT INTO `mullvad_ips` (`ip_address`, `ip_type`) VALUES ('23.234.69.2/32', 'IPv4');
… (1123 more lines)