// GITHUB / SQL
GitHub · SQL

SQL inserts to load GitHub CIDRs into a database table. 7,377 CIDRs, refreshed daily.
// github_ips.sql

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

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

INSERT INTO `github_ips` (`ip_address`, `ip_type`) VALUES ('4.148.0.0/16', 'IPv4');
INSERT INTO `github_ips` (`ip_address`, `ip_type`) VALUES ('4.149.0.0/18', 'IPv4');
INSERT INTO `github_ips` (`ip_address`, `ip_type`) VALUES ('4.149.64.0/19', 'IPv4');
INSERT INTO `github_ips` (`ip_address`, `ip_type`) VALUES ('4.149.96.0/19', 'IPv4');
INSERT INTO `github_ips` (`ip_address`, `ip_type`) VALUES ('4.149.128.0/17', 'IPv4');
INSERT INTO `github_ips` (`ip_address`, `ip_type`) VALUES ('4.150.0.0/18', 'IPv4');
INSERT INTO `github_ips` (`ip_address`, `ip_type`) VALUES ('4.150.64.0/18', 'IPv4');
INSERT INTO `github_ips` (`ip_address`, `ip_type`) VALUES ('4.150.128.0/18', 'IPv4');
INSERT INTO `github_ips` (`ip_address`, `ip_type`) VALUES ('4.150.192.0/19', 'IPv4');
INSERT INTO `github_ips` (`ip_address`, `ip_type`) VALUES ('4.150.224.0/19', 'IPv4');
INSERT INTO `github_ips` (`ip_address`, `ip_type`) VALUES ('4.151.0.0/16', 'IPv4');
INSERT INTO `github_ips` (`ip_address`, `ip_type`) VALUES ('4.152.0.0/15', 'IPv4');
INSERT INTO `github_ips` (`ip_address`, `ip_type`) VALUES ('4.154.0.0/15', 'IPv4');
INSERT INTO `github_ips` (`ip_address`, `ip_type`) VALUES ('4.156.0.0/15', 'IPv4');
INSERT INTO `github_ips` (`ip_address`, `ip_type`) VALUES ('4.172.0.0/15', 'IPv4');
INSERT INTO `github_ips` (`ip_address`, `ip_type`) VALUES ('4.174.0.0/16', 'IPv4');
INSERT INTO `github_ips` (`ip_address`, `ip_type`) VALUES ('4.175.0.0/16', 'IPv4');
… (7360 more lines)