WITH law_summary AS ( SELECT count() FILTER (WHERE status = 'enacted') AS law_count_enacted, COALESCE( jsonb_agg( jsonb_build_object( 'code', code, 'article_number', article_number, 'name', name, 'version', version, 'kb_path', kb_path ) ORDER BY enacted_at DESC NULLS LAST, code ) FILTER (WHERE status = 'enacted'), '[]'::jsonb ) AS reference_laws FROM normative_registry ), dot_summary AS ( SELECT count() AS dot_count_total, count() FILTER (WHERE status = 'active') AS dot_count_active FROM dot_tools ), dot_domain_base AS ( SELECT COALESCE(domain, 'unknown') AS domain, name, description FROM dot_tools WHERE status = 'active' ), dot_domain_samples AS ( SELECT domain, string_agg(name, ', ' ORDER BY name) AS sample_dots FROM ( SELECT domain, name, row_number() OVER (PARTITION BY domain ORDER BY name) AS rn FROM (SELECT DISTINCT domain, name FROM dot_domain_base) d ) ranked WHERE rn <= 5 GROUP BY domain ), dot_domain_summaries AS ( SELECT domain, string_agg(description, '; ' ORDER BY description) AS domain_summary FROM ( SELECT DISTINCT domain, description FROM dot_domain_base WHERE description IS NOT NULL AND description <> '' ) d GROUP BY domain ), dot_domain_raw AS ( SELECT b.domain, count() AS dot_count, s.sample_dots, su.domain_summary FROM dot_domain_base b LEFT JOIN dot_domain_samples s ON s.domain = b.domain LEFT JOIN dot_domain_summaries su ON su.domain = b.domain GROUP BY b.domain, s.sample_dots, su.domain_summary ), dot_domain AS ( SELECT COALESCE( jsonb_agg( jsonb_build_object( 'domain', domain, 'dot_count', dot_count, 'sample_dots', sample_dots, 'domain_summary', domain_summary ) ORDER BY dot_count DESC, domain ), '[]'::jsonb ) AS dot_domain_counts FROM dot_domain_raw ), roadmap_phase AS ( SELECT COALESCE( (SELECT value FROM dot_config WHERE key = 'current_roadmap_phase'), '' ) AS current_roadmap_phase ), entity_summary AS ( SELECT count() AS entity_count_total, count(DISTINCT species_code) AS species_count_live FROM birth_registry ), issue_rollup AS ( SELECT severity, status, count() AS issue_count FROM system_issues GROUP BY severity, status ), issue_summary AS ( SELECT COALESCE( sum(issue_count) FILTER (WHERE lower(severity) = 'critical' AND status = 'open'), 0 )::bigint AS critical_open_count, COALESCE( jsonb_agg( jsonb_build_object('severity', severity, 'status', status, 'issue_count', issue_count) ORDER BY severity, status ), '[]'::jsonb ) AS issue_counts FROM issue_rollup ), db_summary AS ( SELECT count() AS db_count_total, jsonb_agg( jsonb_build_object( 'db_name', datname, 'size_bytes', pg_database_size(datname), 'size_pretty', pg_size_pretty(pg_database_size(datname)), 'role_label', CASE datname WHEN 'directus' THEN 'warehouse' WHEN 'incomex_metadata' THEN 'brain-store' WHEN 'workflow' THEN 'engine' WHEN 'postgres' THEN 'cluster-admin' ELSE 'other' END, 'legal_gateway', CASE datname WHEN 'directus' THEN 'Directus REST + DOT + fn_' WHEN 'incomex_metadata' THEN 'Agent Data FastAPI' WHEN 'workflow' THEN 'future workflow engine' WHEN 'postgres' THEN 'cluster admin only' ELSE 'review' END ) ORDER BY datname ) AS databases FROM pg_database WHERE datistemplate = false ) SELECT l.law_count_enacted, l.reference_laws, d.dot_count_total, d.dot_count_active, dd.dot_domain_counts, rp.current_roadmap_phase, e.entity_count_total, e.species_count_live, i.critical_open_count, i.issue_counts, db.db_count_total, db.databases FROM law_summary l CROSS JOIN dot_summary d CROSS JOIN dot_domain dd CROSS JOIN roadmap_phase rp CROSS JOIN entity_summary e CROSS JOIN issue_summary i CROSS JOIN db_summary db