javed132/euvdb_snapshot repository overview

psql -h <production-vm-ip> -U euvd_reader -d euvdb
# Password: euvd_readonly_2026

psql -h <production-vm-ip> -U euvd_reader -d euvdb -c "SELECT COUNT(*) FROM euvd_vulnerabilities;"

postgresql://euvd_reader:euvd_readonly_2026@<production-vm-ip>:5432/euvdb

import psycopg2

conn = psycopg2.connect(
    host="<production-vm-ip>",
    port=5432,
    dbname="euvdb",
    user="euvd_reader",
    password="euvd_readonly_2026"
)
cur = conn.cursor()
cur.execute("SELECT * FROM euvd_vulnerabilities WHERE 'CVE-2025-12345' = ANY(aliases)")
rows = cur.fetchall()

-- Look up a CVE
SELECT euvd_id, base_score, epss, description
FROM euvd_vulnerabilities WHERE 'CVE-2025-12345' = ANY(aliases);

-- Find vulnerabilities by product
SELECT euvd_id, base_score, aliases
FROM euvd_vulnerabilities WHERE products @> '[{"name": "OpenSSL"}]'::jsonb;

-- Find by vendor
SELECT euvd_id, base_score, aliases
FROM euvd_vulnerabilities WHERE 'Microsoft' = ANY(vendors);

-- Full-text search
SELECT euvd_id, base_score, description
FROM euvd_vulnerabilities
WHERE to_tsvector('english', description) @@ plainto_tsquery('english', 'remote code execution');