DBeaver // Universal Database Studio & SQL Client

🦫

DBeaver Universal Database Studio PRO CE

Sovereign SQL Client, Database Administration & ER Navigator

● CONNECTED: [email protected]:5432/ignition_db Mission Control HUD →

Quick Snippets:

💾 Export SCADA CSV 💾 Export Cyber CSV

Ready to execute query. 0 ms

📋 scada_telemetry_log (5,001 Rows)

🔑 id: integer (PK)

• timestamp: timestamptz

• gateway: varchar(64)

• voltage: numeric(8,2)

• current: numeric(8,2)

• power_kw: numeric(8,2)

• rpm: integer

• temp_c: numeric(6,2)

• oee_pct: numeric(5,2)

• status: varchar(32)

🛡️ cyber_security_intel (909 Rows)

🔑 id: integer (PK)

• alert_id: varchar(64) (UNIQUE)

• title: text

• category: varchar(64)

• severity: varchar(16)

• source: varchar(64)

• cve_ids: text[]

• affected_nodes: text[]

• purdue_level: varchar(16)

• published_at: timestamptz

🚨 scada_alarms (2 Rows)

🔑 id: integer (PK)

• alarm_name: varchar(64)

• severity: varchar(16)

• active: boolean

• triggered_at: timestamptz

💾 cluster_storage_metrics (1 Row)

🔑 id: integer (PK)

• pool_name: varchar(64)

• total_gb: numeric(10,2)

• used_gb: numeric(10,2)

• free_gb: numeric(10,2)