// AWS / SQL
AWS · SQL

SQL inserts to load AWS CIDRs into a database table. 15,877 CIDRs, refreshed daily.
// aws_ips.sql

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

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

INSERT INTO `aws_ips` (`ip_address`, `ip_type`) VALUES ('3.4.12.4/32', 'IPv4');
INSERT INTO `aws_ips` (`ip_address`, `ip_type`) VALUES ('3.5.140.0/22', 'IPv4');
INSERT INTO `aws_ips` (`ip_address`, `ip_type`) VALUES ('15.190.244.0/22', 'IPv4');
INSERT INTO `aws_ips` (`ip_address`, `ip_type`) VALUES ('15.230.15.29/32', 'IPv4');
INSERT INTO `aws_ips` (`ip_address`, `ip_type`) VALUES ('15.230.15.76/31', 'IPv4');
INSERT INTO `aws_ips` (`ip_address`, `ip_type`) VALUES ('15.230.221.0/24', 'IPv4');
INSERT INTO `aws_ips` (`ip_address`, `ip_type`) VALUES ('15.248.168.0/21', 'IPv4');
INSERT INTO `aws_ips` (`ip_address`, `ip_type`) VALUES ('23.254.120.0/21', 'IPv4');
INSERT INTO `aws_ips` (`ip_address`, `ip_type`) VALUES ('35.180.0.0/16', 'IPv4');
INSERT INTO `aws_ips` (`ip_address`, `ip_type`) VALUES ('51.85.0.0/16', 'IPv4');
INSERT INTO `aws_ips` (`ip_address`, `ip_type`) VALUES ('52.93.153.170/32', 'IPv4');
INSERT INTO `aws_ips` (`ip_address`, `ip_type`) VALUES ('52.93.178.234/32', 'IPv4');
INSERT INTO `aws_ips` (`ip_address`, `ip_type`) VALUES ('52.93.244.0/24', 'IPv4');
INSERT INTO `aws_ips` (`ip_address`, `ip_type`) VALUES ('52.94.76.0/22', 'IPv4');
INSERT INTO `aws_ips` (`ip_address`, `ip_type`) VALUES ('52.95.36.0/22', 'IPv4');
INSERT INTO `aws_ips` (`ip_address`, `ip_type`) VALUES ('52.219.170.0/23', 'IPv4');
INSERT INTO `aws_ips` (`ip_address`, `ip_type`) VALUES ('69.107.10.200/29', 'IPv4');
… (15860 more lines)