SQL
InsurChain Studio
Interactive Query Environment • ClickHouse & PostgreSQL engine
Database Tables
v2.4 (Live)
protocols
• protocol_id (VARCHAR)
• name (VARCHAR)
• chain_id (INT)
• active_reserves_usd (NUMERIC)
solvency_snapshots
• snapshot_timestamp (TIMESTAMP)
• capital_adequacy_ratio (FLOAT)
• var_995_usd (NUMERIC)
• mcr_margin (FLOAT)
claims_payouts
• incident_tx_hash (VARCHAR)
• trigger_type (VARCHAR)
• payout_amount_usd (NUMERIC)
• settlement_seconds (INT)
query_editor.sql
InsurChain Serverless ClickHouse
Execution Results
Executed in 38ms • 6 records
| protocol_name | chain_id | active_reserves_usd | capital_adequacy_ratio | var_995_usd | solvency_percent |
|---|---|---|---|---|---|
| Nexus Mutual | 1 (Ethereum) | $284,520,000 | 2.45 | $116,130,000 | 245.0% |
| InsurAce Protocol | 42161 (Arbitrum) | $42,180,000 | 1.94 | $21,740,000 | 194.0% |
| OpenCover | 8453 (Base) | $31,450,000 | 1.82 | $17,280,000 | 182.0% |
| Neptune Mutual | 1 (Ethereum) | $26,900,000 | 2.10 | $12,800,000 | 210.0% |
| Etherisc DIP | 100 (Gnosis) | $14,350,000 | 1.71 | $8,390,000 | 171.0% |
| Cozy Finance | 42161 (Arbitrum) | $9,820,000 | 1.63 | $6,020,000 | 163.0% |