// GPTBOT / SQL
GPTBot · SQL

SQL inserts to load GPTBot CIDRs into a database table. 322 CIDRs, refreshed daily.
// gptbot_ips.sql

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

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

INSERT INTO `gptbot_ips` (`ip_address`, `ip_type`) VALUES ('4.151.71.176/28', 'IPv4');
INSERT INTO `gptbot_ips` (`ip_address`, `ip_type`) VALUES ('4.151.119.48/28', 'IPv4');
INSERT INTO `gptbot_ips` (`ip_address`, `ip_type`) VALUES ('4.151.241.240/28', 'IPv4');
INSERT INTO `gptbot_ips` (`ip_address`, `ip_type`) VALUES ('4.189.118.208/28', 'IPv4');
INSERT INTO `gptbot_ips` (`ip_address`, `ip_type`) VALUES ('4.189.119.48/28', 'IPv4');
INSERT INTO `gptbot_ips` (`ip_address`, `ip_type`) VALUES ('4.196.118.112/28', 'IPv4');
INSERT INTO `gptbot_ips` (`ip_address`, `ip_type`) VALUES ('4.197.19.176/28', 'IPv4');
INSERT INTO `gptbot_ips` (`ip_address`, `ip_type`) VALUES ('4.197.22.112/28', 'IPv4');
INSERT INTO `gptbot_ips` (`ip_address`, `ip_type`) VALUES ('4.197.64.0/28', 'IPv4');
INSERT INTO `gptbot_ips` (`ip_address`, `ip_type`) VALUES ('4.197.64.16/28', 'IPv4');
INSERT INTO `gptbot_ips` (`ip_address`, `ip_type`) VALUES ('4.197.64.48/28', 'IPv4');
INSERT INTO `gptbot_ips` (`ip_address`, `ip_type`) VALUES ('4.197.64.64/28', 'IPv4');
INSERT INTO `gptbot_ips` (`ip_address`, `ip_type`) VALUES ('4.197.115.112/28', 'IPv4');
INSERT INTO `gptbot_ips` (`ip_address`, `ip_type`) VALUES ('4.198.72.16/28', 'IPv4');
INSERT INTO `gptbot_ips` (`ip_address`, `ip_type`) VALUES ('4.201.232.64/28', 'IPv4');
INSERT INTO `gptbot_ips` (`ip_address`, `ip_type`) VALUES ('4.205.128.176/28', 'IPv4');
INSERT INTO `gptbot_ips` (`ip_address`, `ip_type`) VALUES ('4.226.226.32/28', 'IPv4');
… (305 more lines)