Which platforms have the most public exploits?
SELECT platform, COUNT(*) AS exploits FROM demo.security.exploit_db GROUP BY platform ORDER BY exploits DESC, platform LIMIT 10
The Exploit Database's archive of public exploits and proof-of-concept code: what each targets, its type and platform, when it was published, whether it is verified, and the CVEs it covers.
Live from the table, no sign-in needed.
SELECT exploit_id, date_published, exploit_type, platform, verified, cve_ids FROM demo.security.exploit_db LIMIT 10
Run any of these here, or open it in Studio to change the SQL. Studio is free to start: 100 queries a day.
SELECT platform, COUNT(*) AS exploits FROM demo.security.exploit_db GROUP BY platform ORDER BY exploits DESC, platform LIMIT 10
SELECT exploit_id, date_published, platform, description FROM demo.security.exploit_db WHERE verified = TRUE ORDER BY date_published DESC, exploit_id DESC LIMIT 10
SELECT exploit_type, COUNT(*) AS exploits FROM demo.security.exploit_db GROUP BY exploit_type ORDER BY exploits DESC
| Column | Type |
|---|---|
| exploit_id | INT64 |
| file_path | VARCHAR |
| description | VARCHAR |
| date_published | DATE |
| author | VARCHAR |
| exploit_type | VARCHAR |
| platform | VARCHAR |
| port | INT64 |
| date_added | DATE |
| date_updated | DATE |
| verified | BOOL |
| cve_ids | VARCHAR |
| tags | VARCHAR |
| source_url | VARCHAR |