:root{
  --bg:#F4F5FB; --surface:#FFFFFF; --ink:#11131A; --muted:#6B7088; --faint:#9AA0B5;
  --line:#ECEDF4; --line2:#E2E4F0;
  --accent:#5E5CE6; --accent2:#7C3AED; --accentSoft:#F0F0FE;
  --green:#22C55E; --amber:#F59E0B; --red:#EF4444;
  --radius:16px;
}
*{box-sizing:border-box;margin:0;padding:0}
body{font-family:'Inter',-apple-system,BlinkMacSystemFont,'Segoe UI',sans-serif;background:var(--bg);color:var(--ink);-webkit-font-smoothing:antialiased}
.app{display:flex;min-height:100vh}
a{color:var(--accent);text-decoration:none}
.hidden{display:none !important}

/* sidebar */
.side{width:248px;background:var(--surface);border-right:1px solid var(--line);padding:22px 16px;display:flex;flex-direction:column;gap:6px;position:sticky;top:0;height:100vh}
.brand{display:flex;align-items:center;gap:11px;padding:4px 6px 18px}
.logo{width:42px;height:42px;border-radius:12px;background:linear-gradient(135deg,var(--accent),var(--accent2));display:flex;align-items:center;justify-content:center;color:#fff;font-weight:900;font-size:20px;box-shadow:0 6px 16px rgba(94,92,230,.35)}
.brand b{font-size:15px;font-weight:800;letter-spacing:-.02em;line-height:1.1}
.brand span{display:block;font-size:11.5px;color:var(--faint);font-weight:500}
.nav{display:flex;flex-direction:column;gap:3px;margin-top:4px}
.nav button{display:flex;align-items:center;gap:11px;padding:10px 12px;border-radius:11px;color:var(--muted);background:none;border:none;font:inherit;text-align:left;cursor:pointer;font-size:14px;font-weight:600;transition:.15s;width:100%}
.nav button:hover{background:#F5F5FD;color:var(--ink)}
.nav button.on{background:var(--accentSoft);color:var(--accent)}
.side .foot{margin-top:auto;display:flex;align-items:center;gap:10px;padding:12px 8px;border-top:1px solid var(--line)}
.ava{width:32px;height:32px;border-radius:50%;background:#E7E7FB;color:var(--accent);display:flex;align-items:center;justify-content:center;font-weight:700;font-size:12.5px}
.foot .who b{font-size:13px;font-weight:600;display:block}
.foot .who span{font-size:11.5px;color:var(--faint)}
.foot button{margin-left:auto;background:none;border:none;color:var(--faint);cursor:pointer;font-size:12px;font-weight:600}
.foot button:hover{color:var(--red)}

/* main */
.main{flex:1;padding:28px 38px 60px;max-width:1180px}
.hero{background:linear-gradient(125deg,#4F46E5 0%,#7C3AED 55%,#9333EA 100%);border-radius:22px;padding:24px 28px;color:#fff;box-shadow:0 18px 44px rgba(79,70,229,.30);display:flex;align-items:center;justify-content:space-between;margin-bottom:24px}
.hero h1{font-size:23px;font-weight:900;letter-spacing:-.03em}
.hero p{opacity:.85;font-size:13.5px;margin-top:4px}
.hero .pill{background:rgba(255,255,255,.16);backdrop-filter:blur(6px);border:1px solid rgba(255,255,255,.22);padding:9px 16px;border-radius:12px;font-size:13px;font-weight:600;display:flex;gap:8px;align-items:center}
.dot{width:9px;height:9px;border-radius:50%;flex:none}
.dot.g{background:#6EE7A8;box-shadow:0 0 0 3px rgba(110,231,168,.25)}
.dot.r{background:#FCA5A5}

/* stat cards */
.stats{display:grid;grid-template-columns:repeat(auto-fit,minmax(130px,1fr));gap:14px;margin-bottom:24px}
.stat{background:var(--surface);border:1px solid var(--line);border-radius:14px;padding:16px 18px;box-shadow:0 3px 16px rgba(17,19,26,.05)}
.stat b{display:block;font-size:22px;font-weight:800;letter-spacing:-.02em}
.stat span{font-size:12px;color:var(--faint);font-weight:600}

/* search bar */
.searchbar{display:flex;gap:12px;margin-bottom:16px;flex-wrap:wrap}
.searchbar .grow{flex:1;min-width:240px;position:relative}
.inp,.sel{width:100%;height:46px;border:1.5px solid var(--line2);border-radius:12px;padding:0 14px;font-size:14px;font-family:inherit;color:var(--ink);background:#fff;transition:.15s}
.inp:focus,.sel:focus{outline:none;border-color:var(--accent);box-shadow:0 0 0 4px rgba(94,92,230,.13)}
.sel{appearance:none;background-image:url("data:image/svg+xml;utf8,<svg xmlns='http://www.w3.org/2000/svg' width='16' height='16' fill='none' stroke='%236B7088' stroke-width='2'><path d='M4 6l4 4 4-4'/></svg>");background-repeat:no-repeat;background-position:right 12px center;padding-right:34px;min-width:140px;width:auto}
.btn{height:46px;border:none;border-radius:12px;padding:0 22px;font-size:14px;font-weight:700;font-family:inherit;cursor:pointer;display:inline-flex;align-items:center;gap:8px}
.btn.primary{background:linear-gradient(135deg,var(--accent),var(--accent2));color:#fff;box-shadow:0 8px 20px rgba(94,92,230,.34)}
.btn.primary:hover{filter:brightness(1.05)}
.btn.ghost{background:#fff;border:1.5px solid var(--line2);color:var(--ink)}
.btn:disabled{opacity:.5;cursor:not-allowed}

/* tabs */
.tabs{display:inline-flex;gap:6px;background:#fff;border:1px solid var(--line2);padding:5px;border-radius:13px;margin-bottom:16px;flex-wrap:wrap}
.tabs button{border:none;background:none;font:inherit;font-size:13.5px;font-weight:600;color:var(--muted);padding:8px 16px;border-radius:9px;cursor:pointer}
.tabs button.on{background:var(--accentSoft);color:var(--accent)}

/* results table */
.card{background:var(--surface);border:1px solid var(--line);border-radius:var(--radius);box-shadow:0 3px 16px rgba(17,19,26,.05);overflow:hidden}
.meta{font-size:12.5px;color:var(--faint);margin:0 4px 10px;font-weight:600}
table{width:100%;border-collapse:collapse;font-size:13px}
thead th{text-align:left;padding:13px 16px;background:#FAFAFE;color:var(--muted);font-weight:700;font-size:11.5px;text-transform:uppercase;letter-spacing:.04em;border-bottom:1px solid var(--line);white-space:nowrap}
tbody td{padding:12px 16px;border-bottom:1px solid var(--line);color:var(--ink);vertical-align:top}
tbody tr{cursor:pointer;transition:.1s}
tbody tr:hover{background:#F8F8FE}
tbody tr:last-child td{border-bottom:none}
.tag{display:inline-block;padding:2px 9px;border-radius:20px;font-size:11.5px;font-weight:700}
.tag.g{background:rgba(34,197,94,.13);color:#15803D}
.tag.r{background:rgba(239,68,68,.13);color:#B91C1C}
.tag.n{background:#EEF0F7;color:var(--muted)}
.stars{color:var(--amber);font-weight:700}

/* detail drawer */
.drawer-bg{position:fixed;inset:0;background:rgba(17,19,26,.4);backdrop-filter:blur(2px);z-index:40}
.drawer{position:fixed;top:0;right:0;height:100vh;width:min(680px,94vw);background:var(--bg);box-shadow:-12px 0 40px rgba(17,19,26,.18);z-index:41;overflow-y:auto;padding:0 0 50px}
.drawer .dhead{position:sticky;top:0;background:linear-gradient(125deg,#4F46E5,#7C3AED);color:#fff;padding:22px 26px;display:flex;justify-content:space-between;align-items:flex-start}
.drawer .dhead h2{font-size:20px;font-weight:800;letter-spacing:-.02em}
.drawer .dhead p{opacity:.85;font-size:13px;margin-top:3px}
.drawer .x{background:rgba(255,255,255,.2);border:none;color:#fff;width:34px;height:34px;border-radius:9px;cursor:pointer;font-size:18px}
.dbody{padding:22px 26px}
.dsec{font-size:11px;font-weight:800;letter-spacing:.07em;text-transform:uppercase;color:var(--faint);margin:22px 2px 10px}
.kv{background:var(--surface);border:1px solid var(--line);border-radius:14px;padding:6px 18px}
.kv .r{display:flex;justify-content:space-between;gap:16px;padding:9px 0;border-bottom:1px solid var(--line);font-size:13.5px}
.kv .r:last-child{border-bottom:none}
.kv .r span{color:var(--muted)}
.kv .r b{font-weight:600;text-align:right}
.minilist{background:var(--surface);border:1px solid var(--line);border-radius:14px;overflow:hidden}
.minilist .mi{display:flex;justify-content:space-between;gap:12px;padding:11px 16px;border-bottom:1px solid var(--line);font-size:13px;cursor:pointer}
.minilist .mi:hover{background:#F8F8FE}
.minilist .mi:last-child{border-bottom:none}

/* AI panel */
.ai-wrap{display:flex;flex-direction:column;gap:16px}
.ai-intro{background:var(--surface);border:1px solid var(--line);border-radius:var(--radius);padding:20px 22px;box-shadow:0 3px 16px rgba(17,19,26,.05)}
.ai-intro h3{font-size:15px;margin-bottom:8px}
.ai-intro .ex{display:flex;flex-wrap:wrap;gap:8px;margin-top:12px}
.ai-intro .ex button{background:var(--accentSoft);border:none;color:var(--accent);font:inherit;font-size:12.5px;font-weight:600;padding:8px 13px;border-radius:10px;cursor:pointer;text-align:left}
.ai-intro .ex button:hover{filter:brightness(.97)}
.answer{background:var(--surface);border:1px solid var(--line);border-radius:var(--radius);padding:22px 24px;box-shadow:0 3px 16px rgba(17,19,26,.05)}
.answer .txt{font-size:14.5px;line-height:1.6;white-space:pre-wrap}
.answer .sql{margin-top:16px;background:#0F1117;color:#C9D1E3;border-radius:11px;padding:14px 16px;font-family:ui-monospace,SFMono-Regular,Menlo,monospace;font-size:12px;overflow-x:auto;white-space:pre-wrap}
.answer details{margin-top:12px}
.answer summary{cursor:pointer;font-size:12.5px;color:var(--faint);font-weight:600}
.banner{background:#FFF7ED;border:1px solid #FED7AA;color:#9A3412;border-radius:12px;padding:12px 16px;font-size:13px;margin-bottom:14px}

/* login */
.login-bg{position:fixed;inset:0;background:linear-gradient(135deg,#EEF0FB,#F6F0FF);display:flex;align-items:center;justify-content:center;z-index:100}
.login{background:#fff;border-radius:22px;box-shadow:0 30px 70px rgba(17,19,26,.18);padding:38px 36px;width:380px;max-width:92vw;text-align:center}
.login .logo{margin:0 auto 18px}
.login h1{font-size:21px;font-weight:900;letter-spacing:-.02em}
.login p{color:var(--faint);font-size:13px;margin:6px 0 22px}
.login input{width:100%;height:48px;border:1.5px solid var(--line2);border-radius:12px;padding:0 14px;font-size:15px;font-family:inherit;margin-bottom:14px}
.login input:focus{outline:none;border-color:var(--accent);box-shadow:0 0 0 4px rgba(94,92,230,.13)}
.login .btn{width:100%;justify-content:center}
.login .err{color:var(--red);font-size:13px;margin-bottom:12px;min-height:18px;font-weight:600}

.spinner{width:18px;height:18px;border:2.5px solid rgba(255,255,255,.4);border-top-color:#fff;border-radius:50%;animation:spin .7s linear infinite;display:inline-block}
.spinner.dark{border-color:rgba(94,92,230,.25);border-top-color:var(--accent)}
@keyframes spin{to{transform:rotate(360deg)}}
.center-load{display:flex;align-items:center;justify-content:center;gap:10px;padding:50px;color:var(--faint);font-size:14px;font-weight:600}

/* ---- v2 additions ---- */
.sec-label{font-size:11.5px;font-weight:800;letter-spacing:.08em;text-transform:uppercase;color:var(--faint);margin:26px 4px 14px}
.btn.sm{height:34px;padding:0 13px;font-size:12.5px;border-radius:9px}
.lab{font-size:12.5px;font-weight:600;color:var(--muted)}
.muted-note{font-size:12px;color:var(--faint);font-weight:600}
.card.pad{padding:20px 22px}

/* Ask Junior hero on home */
.ai-hero{background:linear-gradient(125deg,#4F46E5 0%,#7C3AED 55%,#9333EA 100%);border-radius:20px;padding:24px 26px;color:#fff;box-shadow:0 14px 36px rgba(79,70,229,.28);margin-bottom:18px}
.ai-hero h2{font-size:19px;font-weight:800;letter-spacing:-.02em}
.ai-hero p{opacity:.9;font-size:13.5px;margin:5px 0 16px}
.ai-hero .searchbar{margin-bottom:12px}
.ai-hero .inp{border:none}
.ai-hero .ex{display:flex;flex-wrap:wrap;gap:8px}
.ai-hero .ex button{background:rgba(255,255,255,.16);border:1px solid rgba(255,255,255,.25);color:#fff;font:inherit;font-size:12.5px;font-weight:600;padding:7px 12px;border-radius:9px;cursor:pointer}
.ai-hero .ex button:hover{background:rgba(255,255,255,.26)}

/* result head + exports */
.result-head{display:flex;align-items:center;justify-content:space-between;gap:12px;margin:2px 4px 10px;flex-wrap:wrap}
.exports{display:inline-flex;gap:8px}
.inp.filt{max-width:130px}

/* answer (ask) */
.answer{background:var(--surface);border:1px solid var(--line);border-radius:var(--radius);padding:20px 22px;box-shadow:0 3px 16px rgba(17,19,26,.05);margin-bottom:8px}
.answer .txt{font-size:14.5px;line-height:1.6;white-space:pre-wrap}
.answer .sql,.sql{margin-top:12px;background:#0F1117;color:#C9D1E3;border-radius:11px;padding:14px 16px;font-family:ui-monospace,Menlo,monospace;font-size:12px;overflow-x:auto;white-space:pre-wrap}
.answer details,details.q{margin-top:12px}
.answer summary{cursor:pointer;font-size:12.5px;color:var(--faint);font-weight:600}
.banner{background:#FFF7ED;border:1px solid #FED7AA;color:#9A3412;border-radius:12px;padding:12px 16px;font-size:13px}

/* detail page */
.dpage-head{margin:14px 2px 4px}
.dpage-head h1{font-size:24px;font-weight:900;letter-spacing:-.03em}
.dpage-head p{color:var(--faint);font-size:13.5px;margin-top:3px}
.dgrid{display:grid;grid-template-columns:1fr 1fr;gap:22px;margin-top:4px}
.dsec{font-size:11px;font-weight:800;letter-spacing:.07em;text-transform:uppercase;color:var(--faint);margin:20px 2px 10px}
.dsec.sec-row{display:flex;align-items:center;justify-content:space-between}
.kv{background:var(--surface);border:1px solid var(--line);border-radius:14px;padding:4px 18px}
.kv .r{display:flex;justify-content:space-between;gap:16px;padding:9px 0;border-bottom:1px solid var(--line);font-size:13.5px}
.kv .r:last-child{border-bottom:none}
.kv .r span{color:var(--muted)}
.kv .r b{font-weight:600;text-align:right}
.minilist{background:var(--surface);border:1px solid var(--line);border-radius:14px;overflow:hidden}
.minilist .mi{display:flex;justify-content:space-between;gap:12px;padding:11px 16px;border-bottom:1px solid var(--line);font-size:13px;cursor:pointer}
.minilist .mi:hover{background:#F8F8FE}
.minilist .mi:last-child{border-bottom:none}

/* analytics */
.charts-grid{display:grid;grid-template-columns:1fr 1fr;gap:18px}
.chart-card{background:var(--surface);border:1px solid var(--line);border-radius:16px;padding:18px 20px;box-shadow:0 3px 16px rgba(17,19,26,.05)}
.chart-card h3{font-size:14.5px;font-weight:700}
.chart-card p{font-size:12px;color:var(--faint);margin-top:2px}
.chart-card .cwrap{position:relative;height:240px;margin-top:12px}

/* query builder */
.qb-row{display:flex;align-items:center;gap:10px;flex-wrap:wrap;margin-bottom:14px}
.qb-actions{margin-top:16px;display:flex;gap:10px}
.cond{display:flex;gap:10px;margin-bottom:10px;flex-wrap:wrap}
.cond .cond-col{flex:2;min-width:160px}
.cond .cond-op{flex:1;min-width:110px}
.cond .cond-val{flex:2;min-width:140px}
textarea.code{height:120px;font-family:ui-monospace,Menlo,monospace;font-size:13px;padding:12px 14px;resize:vertical;width:100%}

/* ---- v3 additions ---- */
.freshness{margin-top:16px;background:var(--accentSoft);border:1px solid var(--line2);border-radius:12px;padding:11px 16px;font-size:12.5px;color:var(--muted);font-weight:500}
.foot-meta{font-size:11px;color:var(--faint);font-weight:600;padding:8px 8px 0;line-height:1.5}
.foot-meta b{color:var(--muted)}

/* vendor / tech-stack cards */
.vcard{background:var(--surface);border:1px solid var(--line);border-radius:14px;padding:16px 18px;margin-bottom:14px;box-shadow:0 3px 16px rgba(17,19,26,.05)}
.vcard-head{display:flex;align-items:center;justify-content:space-between;gap:12px;flex-wrap:wrap;margin-bottom:10px}
.vcard-head b{font-size:15px}
.portals{display:flex;flex-wrap:wrap;gap:7px}
.portal{display:inline-block;background:#F5F5FD;border:1px solid var(--line2);color:var(--accent);font-size:12px;font-weight:600;padding:5px 10px;border-radius:8px;text-decoration:none;max-width:240px;overflow:hidden;text-overflow:ellipsis;white-space:nowrap}
.portal:hover{background:var(--accentSoft)}
.tag.n{background:#EEF0F7;color:var(--muted)}

/* ---- v4 additions ---- */
/* traffic-light balls */
.ball{display:inline-block;width:11px;height:11px;border-radius:50%;vertical-align:middle;margin-right:2px}
.ball.g{background:var(--green);box-shadow:0 0 0 2px rgba(34,197,94,.18)}
.ball.r{background:var(--red);box-shadow:0 0 0 2px rgba(239,68,68,.18)}
.qcell{white-space:nowrap;font-size:12px}
.qline{display:flex;align-items:center;gap:4px;padding:1px 0}
.minilist-head{display:flex;justify-content:space-between;font-size:11px;font-weight:700;letter-spacing:.04em;text-transform:uppercase;color:var(--faint);padding:2px 4px 6px}
.chip{display:inline-block;background:#EEF0F7;color:var(--muted);font-size:11.5px;font-weight:700;padding:2px 8px;border-radius:20px;margin-right:4px}

/* sortable column headers */
thead th{cursor:pointer;user-select:none;position:relative}
thead th:hover{color:var(--accent)}
thead th[data-sort=asc]::after{content:" ▲";font-size:9px;color:var(--accent)}
thead th[data-sort=desc]::after{content:" ▼";font-size:9px;color:var(--accent)}

@media(max-width:900px){.charts-grid{grid-template-columns:1fr}.dgrid{grid-template-columns:1fr}}
@media(max-width:820px){.side{display:none}.main{padding:20px}}