REPL Interactive Shell Basics

<h3 id="overview" class="position-relative d-flex align-items-center group"> Overview <button type="button" class="h-share btn btn-link p-0 text-decoration-none link-secondary opacity-50 hover-opacity-100 transition-all ms-1" data-share-target="overview" aria-haspopup="dialog" aria-label="Share link: Overview"> Share link </button> </h3><div id="headingShareModal" class="heading-share-modal" role="dialog" aria-modal="true" aria-labelledby="headingShareTitle" hidden> <div class="hsm-dialog" role="document"> <div class="hsm-header"> <h2 id="headingShareTitle" class="h6 mb-0 fw-bold">Share this section</h2> <button type="button" class="hsm-close" aria-label="Close"> </button> </div> <div class="hsm-body"> <label for="headingShareInput" class="form-label small text-muted mb-1 text-uppercase fw-bold" style="font-size: 0.7rem; letter-spacing: 0.5px;">Permalink</label> <div class="input-group mb-4 hsm-url-group"> <input id="headingShareInput" type="text" class="form-control font-monospace" readonly aria-readonly="true" style="font-size: 0.85rem;" /> <button class="btn btn-primary hsm-copy" type="button" aria-label="Copy" title="Copy"> </button> </div> <div class="small fw-bold mb-2 text-muted text-uppercase" style="font-size: 0.7rem; letter-spacing: 0.5px;">Share via</div> <div class="hsm-share-grid"> <a id="share-twitter" class="btn btn-outline-secondary w-100" target="_blank" rel="noopener noreferrer"> Twitter </a> <a id="share-linkedin" class="btn btn-outline-secondary w-100" target="_blank" rel="noopener noreferrer"> LinkedIn </a> <a id="share-facebook" class="btn btn-outline-secondary w-100" target="_blank" rel="noopener noreferrer"> Facebook </a> </div> </div> </div> </div> <style> .heading-share-modal { position: fixed; inset: 0; display: flex; justify-content: center; align-items: center; background: rgba(0, 0, 0, 0.6); z-index: 1050; padding: 1rem; backdrop-filter: blur(4px); -webkit-backdrop-filter: blur(4px); } .heading-share-modal[hidden] { display: none !important; } .hsm-dialog { max-width: 420px; width: 100%; background: var(--bs-body-bg, #fff); color: var(--bs-body-color, #212529); border: 1px solid var(--bs-border-color, rgba(0,0,0,0.1)); border-radius: 1rem; box-shadow: 0 25px 50px -12px rgba(0, 0, 0, 0.25); overflow: hidden; animation: hsm-fade-in 0.2s ease-out; } @keyframes hsm-fade-in { from { opacity: 0; transform: scale(0.95); } to { opacity: 1; transform: scale(1); } } [data-bs-theme="dark"] .hsm-dialog { background: #1e293b; border-color: rgba(255,255,255,0.1); color: #f8f9fa; } .hsm-header { display: flex; justify-content: space-between; align-items: center; padding: 1rem 1.5rem; border-bottom: 1px solid var(--bs-border-color, rgba(0,0,0,0.1)); background: rgba(0,0,0,0.02); } [data-bs-theme="dark"] .hsm-header { background: rgba(255,255,255,0.02); border-color: rgba(255,255,255,0.1); } .hsm-close { background: transparent; border: none; color: inherit; opacity: 0.5; padding: 0.25rem 0.5rem; border-radius: 0.25rem; font-size: 1.2rem; line-height: 1; transition: opacity 0.2s; } .hsm-close:hover { opacity: 1; } .hsm-body { padding: 1.5rem; } .hsm-url-group { display: flex !important; align-items: stretch; } .hsm-url-group .form-control { flex: 1; min-width: 0; margin: 0; background: var(--bs-secondary-bg, #f8f9fa); border-color: var(--bs-border-color, #dee2e6); border-top-right-radius: 0; border-bottom-right-radius: 0; height: 42px; } .hsm-url-group .btn { flex: 0 0 auto; margin: 0; margin-left: -1px; border-top-left-radius: 0; border-bottom-left-radius: 0; height: 42px; display: flex; align-items: center; justify-content: center; padding: 0 1.25rem; z-index: 2; } [data-bs-theme="dark"] .hsm-url-group .form-control { background: #0f172a; border-color: #334155; color: #e2e8f0; } .hsm-share-grid { display: flex; flex-direction: column; gap: 0.5rem; } .hsm-share-grid .btn { display: flex; align-items: center; justify-content: center; font-size: 0.9rem; padding: 0.6rem; border-color: var(--bs-border-color); width: 100%; } [data-bs-theme="dark"] .hsm-share-grid .btn { color: #e2e8f0; border-color: #475569; } [data-bs-theme="dark"] .hsm-share-grid .btn:hover { background: #334155; border-color: #cbd5e1; } </style> <script> (function(){ const modal = document.getElementById('headingShareModal'); if(!modal) return; const input = modal.querySelector('#headingShareInput'); const copyBtn = modal.querySelector('.hsm-copy'); const twitter = modal.querySelector('#share-twitter'); const linkedin = modal.querySelector('#share-linkedin'); const facebook = modal.querySelector('#share-facebook'); const closeBtn = modal.querySelector('.hsm-close'); let lastFocus=null; let trapBound=false; function buildUrl(id){ return window.location.origin + window.location.pathname + '#' + id; } function isOpen(){ return !modal.hasAttribute('hidden'); } function hydrate(id){ const url=buildUrl(id); input.value=url; const enc=encodeURIComponent(url); const text=encodeURIComponent(document.title); if(twitter) twitter.href=`https://twitter.com/intent/tweet?url=${enc}&text=${text}`; if(linkedin) linkedin.href=`https://www.linkedin.com/sharing/share-offsite/?url=${enc}`; if(facebook) facebook.href=`https://www.facebook.com/sharer/sharer.php?u=${enc}`; } function openModal(id){ lastFocus=document.activeElement; hydrate(id); if(!isOpen()){ modal.removeAttribute('hidden'); } requestAnimationFrame(()=>{ input.focus(); }); trapFocus(); } function closeModal(){ if(!isOpen()) return; modal.setAttribute('hidden',''); if(lastFocus && typeof lastFocus.focus==='function') lastFocus.focus(); } function copyCurrent(){ try{ navigator.clipboard.writeText(input.value).then(()=>feedback(true),()=>fallback()); } catch(e){ fallback(); } } function fallback(){ input.select(); try{ document.execCommand('copy'); feedback(true);}catch(e){ feedback(false);} } function feedback(ok){ if(!copyBtn) return; const icon=copyBtn.querySelector('i'); if(!icon) return; const prev=copyBtn.getAttribute('data-prev')||icon.className; if(!copyBtn.getAttribute('data-prev')) copyBtn.setAttribute('data-prev',prev); icon.className= ok ? 'fa-duotone fa-clipboard-check':'fa-duotone fa-circle-exclamation'; setTimeout(()=>{ icon.className=prev; },1800); } function handleShareClick(e){ e.preventDefault(); const btn=e.currentTarget; const id=btn.getAttribute('data-share-target'); if(id) openModal(id); } function bindShareButtons(){ document.querySelectorAll('.h-share').forEach(btn=>{ if(!btn.dataset.hShareBound){ btn.addEventListener('click', handleShareClick); btn.dataset.hShareBound='1'; } }); } bindShareButtons(); if(document.readyState==='loading'){ document.addEventListener('DOMContentLoaded', bindShareButtons); } else { requestAnimationFrame(bindShareButtons); } document.addEventListener('click', function(e){ const shareBtn=e.target.closest && e.target.closest('.h-share'); if(shareBtn && !shareBtn.dataset.hShareBound){ handleShareClick.call(shareBtn, e); } }, true); document.addEventListener('click', e=>{ if(e.target===modal) closeModal(); if(e.target.closest && e.target.closest('.hsm-close')){ e.preventDefault(); closeModal(); } if(copyBtn && (e.target===copyBtn || (e.target.closest && e.target.closest('.hsm-copy')))) { e.preventDefault(); copyCurrent(); } }); document.addEventListener('keydown', e=>{ if(e.key==='Escape' && isOpen()) closeModal(); }); function trapFocus(){ if(trapBound) return; trapBound=true; modal.addEventListener('keydown', f=>{ if(f.key==='Tab' && isOpen()){ const focusable=[...modal.querySelectorAll('a[href],button,input,textarea,select,[tabindex]:not([tabindex="-1"])')].filter(el=>!el.hasAttribute('disabled')); if(!focusable.length) return; const first=focusable[0]; const last=focusable[focusable.length-1]; if(f.shiftKey && document.activeElement===first){ f.preventDefault(); last.focus(); } else if(!f.shiftKey && document.activeElement===last){ f.preventDefault(); first.focus(); } } }); } if(closeBtn) closeBtn.addEventListener('click', e=>{ e.preventDefault(); closeModal(); }); })(); </script>The Geode REPL (Read-Eval-Print Loop) provides an interactive shell for query development, data exploration, and administration. This tutorial covers essential REPL features for productive database interaction. <h4 id="what-youll-learn" class="position-relative d-flex align-items-center group"> What You&rsquo;ll Learn <button type="button" class="h-share btn btn-link p-0 text-decoration-none link-secondary opacity-50 hover-opacity-100 transition-all ms-1" data-share-target="what-youll-learn" aria-haspopup="dialog" aria-label="Share link: What Youll Learn"> Share link </button> </h4><ul> <li>Starting and connecting to the REPL</li> <li>Executing GQL queries interactively</li> <li>Using meta commands for shell control</li> <li>Keyboard shortcuts for efficiency</li> <li>History navigation and search</li> <li>Output formatting options</li> </ul> <h3 id="getting-started" class="position-relative d-flex align-items-center group"> Getting Started <button type="button" class="h-share btn btn-link p-0 text-decoration-none link-secondary opacity-50 hover-opacity-100 transition-all ms-1" data-share-target="getting-started" aria-haspopup="dialog" aria-label="Share link: Getting Started"> Share link </button> </h3> <h4 id="starting-the-repl" class="position-relative d-flex align-items-center group"> Starting the REPL <button type="button" class="h-share btn btn-link p-0 text-decoration-none link-secondary opacity-50 hover-opacity-100 transition-all ms-1" data-share-target="starting-the-repl" aria-haspopup="dialog" aria-label="Share link: Starting the REPL"> Share link </button> </h4><div class="highlight"><pre tabindex="0" class="chroma"><code class="language-bash" data-lang="bash"># Start REPL connected to local server geode shell # Connect to remote server geode shell --host db.example.com --port 3141 # With authentication geode shell --user alice --password secretpass </code></pre></div>Welcome Screen: <div class="highlight"><pre tabindex="0" class="chroma"><code class="language-fallback" data-lang="fallback">Geode Interactive Shell v0.2.18 Connected to: localhost:3141 Type \help or \? for help, \quit to exit geode> </code></pre></div> <h4 id="first-query" class="position-relative d-flex align-items-center group"> First Query <button type="button" class="h-share btn btn-link p-0 text-decoration-none link-secondary opacity-50 hover-opacity-100 transition-all ms-1" data-share-target="first-query" aria-haspopup="dialog" aria-label="Share link: First Query"> Share link </button> </h4><div class="highlight"><pre tabindex="0" class="chroma"><code class="language-gql" data-lang="gql">geode> RETURN 1 AS number ┌────────┐ │ number │ ├────────┤ │ 1 │ └────────┘ 1 row in 0.002 seconds </code></pre></div>Features: <ul> <li>Automatic formatting (table layout)</li> <li>Execution time display</li> <li>Row count summary</li> </ul> <h3 id="meta-commands" class="position-relative d-flex align-items-center group"> Meta Commands <button type="button" class="h-share btn btn-link p-0 text-decoration-none link-secondary opacity-50 hover-opacity-100 transition-all ms-1" data-share-target="meta-commands" aria-haspopup="dialog" aria-label="Share link: Meta Commands"> Share link </button> </h3>Meta commands start with backslash (<code>\</code>) and control REPL behavior. <h4 id="essential-commands" class="position-relative d-flex align-items-center group"> Essential Commands <button type="button" class="h-share btn btn-link p-0 text-decoration-none link-secondary opacity-50 hover-opacity-100 transition-all ms-1" data-share-target="essential-commands" aria-haspopup="dialog" aria-label="Share link: Essential Commands"> Share link </button> </h4>Help: <div class="highlight"><pre tabindex="0" class="chroma"><code class="language-fallback" data-lang="fallback">geode> \help geode> \h geode> \? </code></pre></div>Quit: <div class="highlight"><pre tabindex="0" class="chroma"><code class="language-fallback" data-lang="fallback">geode> \quit geode> \q </code></pre></div>Clear Screen: <div class="highlight"><pre tabindex="0" class="chroma"><code class="language-fallback" data-lang="fallback">geode> \clear </code></pre></div>Echo Text: <div class="highlight"><pre tabindex="0" class="chroma"><code class="language-fallback" data-lang="fallback">geode> \echo Hello, Geode! Hello, Geode! </code></pre></div> <h4 id="connection-management" class="position-relative d-flex align-items-center group"> Connection Management <button type="button" class="h-share btn btn-link p-0 text-decoration-none link-secondary opacity-50 hover-opacity-100 transition-all ms-1" data-share-target="connection-management" aria-haspopup="dialog" aria-label="Share link: Connection Management"> Share link </button> </h4>Connect to Server: <div class="highlight"><pre tabindex="0" class="chroma"><code class="language-fallback" data-lang="fallback">geode> \connect db.example.com:3141 Connected to: db.example.com:3141 </code></pre></div>Disconnect: <div class="highlight"><pre tabindex="0" class="chroma"><code class="language-fallback" data-lang="fallback">geode> \disconnect Disconnected from server </code></pre></div>Connection Status: <div class="highlight"><pre tabindex="0" class="chroma"><code class="language-fallback" data-lang="fallback">geode> \status Connected: Yes Server: localhost:3141 User: alice Database: main </code></pre></div> <h4 id="transaction-commands" class="position-relative d-flex align-items-center group"> Transaction Commands <button type="button" class="h-share btn btn-link p-0 text-decoration-none link-secondary opacity-50 hover-opacity-100 transition-all ms-1" data-share-target="transaction-commands" aria-haspopup="dialog" aria-label="Share link: Transaction Commands"> Share link </button> </h4>Begin Transaction: <div class="highlight"><pre tabindex="0" class="chroma"><code class="language-fallback" data-lang="fallback">geode> \begin Transaction started </code></pre></div>Commit: <div class="highlight"><pre tabindex="0" class="chroma"><code class="language-fallback" data-lang="fallback">geode> \commit Transaction committed </code></pre></div>Rollback: <div class="highlight"><pre tabindex="0" class="chroma"><code class="language-fallback" data-lang="fallback">geode> \rollback Transaction rolled back </code></pre></div>Transaction Example: <div class="highlight"><pre tabindex="0" class="chroma"><code class="language-gql" data-lang="gql">geode> \begin geode> CREATE (n:Person {name: 'Alice'}) geode> CREATE (n:Person {name: 'Bob'}) geode> \commit 2 nodes created </code></pre></div> <h4 id="output-formatting" class="position-relative d-flex align-items-center group"> Output Formatting <button type="button" class="h-share btn btn-link p-0 text-decoration-none link-secondary opacity-50 hover-opacity-100 transition-all ms-1" data-share-target="output-formatting" aria-haspopup="dialog" aria-label="Share link: Output Formatting"> Share link </button> </h4>Table Format (default): <div class="highlight"><pre tabindex="0" class="chroma"><code class="language-fallback" data-lang="fallback">geode> \format table geode> MATCH (n:Person) RETURN n.name ┌───────┐ │ name │ ├───────┤ │ Alice │ │ Bob │ └───────┘ </code></pre></div>CSV Format: <div class="highlight"><pre tabindex="0" class="chroma"><code class="language-fallback" data-lang="fallback">geode> \format csv geode> MATCH (n:Person) RETURN n.name, n.age name,age Alice,30 Bob,28 </code></pre></div>JSON Format: <div class="highlight"><pre tabindex="0" class="chroma"><code class="language-fallback" data-lang="fallback">geode> \format json geode> MATCH (n:Person) RETURN n.name, n.age {"columns":["name","age"],"rows":[["Alice",30],["Bob",28]]} </code></pre></div> <h4 id="history-commands" class="position-relative d-flex align-items-center group"> History Commands <button type="button" class="h-share btn btn-link p-0 text-decoration-none link-secondary opacity-50 hover-opacity-100 transition-all ms-1" data-share-target="history-commands" aria-haspopup="dialog" aria-label="Share link: History Commands"> Share link </button> </h4>View History: <div class="highlight"><pre tabindex="0" class="chroma"><code class="language-fallback" data-lang="fallback">geode> \history 1 RETURN 1 2 MATCH (n:Person) RETURN n.name 3 CREATE (n:Person {name: 'Carol'}) geode> \history 5 # Shows last 5 entries </code></pre></div>Clear History: <div class="highlight"><pre tabindex="0" class="chroma"><code class="language-fallback" data-lang="fallback">geode> \history -c History cleared </code></pre></div> <h4 id="timing" class="position-relative d-flex align-items-center group"> Timing <button type="button" class="h-share btn btn-link p-0 text-decoration-none link-secondary opacity-50 hover-opacity-100 transition-all ms-1" data-share-target="timing" aria-haspopup="dialog" aria-label="Share link: Timing"> Share link </button> </h4>Enable Query Timing: <div class="highlight"><pre tabindex="0" class="chroma"><code class="language-fallback" data-lang="fallback">geode> \timing on Timing enabled geode> MATCH (n) RETURN count(n) ┌──────────┐ │ count(n) │ ├──────────┤ │ 1000 │ └──────────┘ 1 row in 0.042 seconds </code></pre></div>Disable Timing: <div class="highlight"><pre tabindex="0" class="chroma"><code class="language-fallback" data-lang="fallback">geode> \timing off Timing disabled </code></pre></div> <h4 id="configuration" class="position-relative d-flex align-items-center group"> Configuration <button type="button" class="h-share btn btn-link p-0 text-decoration-none link-secondary opacity-50 hover-opacity-100 transition-all ms-1" data-share-target="configuration" aria-haspopup="dialog" aria-label="Share link: Configuration"> Share link </button> </h4>Set Options: <div class="highlight"><pre tabindex="0" class="chroma"><code class="language-fallback" data-lang="fallback">geode> \set keymap vi Keymap set to: vi geode> \set keymap emacs Keymap set to: emacs </code></pre></div>View Settings: <div class="highlight"><pre tabindex="0" class="chroma"><code class="language-fallback" data-lang="fallback">geode> \set keymap: emacs format: table timing: on </code></pre></div> <h3 id="query-execution" class="position-relative d-flex align-items-center group"> Query Execution <button type="button" class="h-share btn btn-link p-0 text-decoration-none link-secondary opacity-50 hover-opacity-100 transition-all ms-1" data-share-target="query-execution" aria-haspopup="dialog" aria-label="Share link: Query Execution"> Share link </button> </h3> <h4 id="single-line-queries" class="position-relative d-flex align-items-center group"> Single-Line Queries <button type="button" class="h-share btn btn-link p-0 text-decoration-none link-secondary opacity-50 hover-opacity-100 transition-all ms-1" data-share-target="single-line-queries" aria-haspopup="dialog" aria-label="Share link: Single-Line Queries"> Share link </button> </h4>Press Enter to Execute: <div class="highlight"><pre tabindex="0" class="chroma"><code class="language-gql" data-lang="gql">geode> RETURN 1 + 1 ┌───┐ │ 2 │ └───┘ </code></pre></div> <h4 id="multi-line-queries" class="position-relative d-flex align-items-center group"> Multi-Line Queries <button type="button" class="h-share btn btn-link p-0 text-decoration-none link-secondary opacity-50 hover-opacity-100 transition-all ms-1" data-share-target="multi-line-queries" aria-haspopup="dialog" aria-label="Share link: Multi-Line Queries"> Share link </button> </h4>End with Semicolon: <div class="highlight"><pre tabindex="0" class="chroma"><code class="language-gql" data-lang="gql">geode> MATCH (p:Person) geode> WHERE p.age > 25 geode> RETURN p.name, p.age; ┌───────┬─────┐ │ name │ age │ ├───────┼─────┤ │ Alice │ 30 │ │ Bob │ 28 │ └───────┴─────┘ </code></pre></div>Indicators: <div class="highlight"><pre tabindex="0" class="chroma"><code class="language-fallback" data-lang="fallback">geode> # Ready for new command geode- # Continuation of multi-line query </code></pre></div> <h4 id="query-cancellation" class="position-relative d-flex align-items-center group"> Query Cancellation <button type="button" class="h-share btn btn-link p-0 text-decoration-none link-secondary opacity-50 hover-opacity-100 transition-all ms-1" data-share-target="query-cancellation" aria-haspopup="dialog" aria-label="Share link: Query Cancellation"> Share link </button> </h4>Press Ctrl+C: <div class="highlight"><pre tabindex="0" class="chroma"><code class="language-gql" data-lang="gql">geode> MATCH (n)-[r*1..10]->(m) geode- WHERE n.id = 1 geode- RETURN m ^C Query cancelled </code></pre></div> <h3 id="keyboard-shortcuts" class="position-relative d-flex align-items-center group"> Keyboard Shortcuts <button type="button" class="h-share btn btn-link p-0 text-decoration-none link-secondary opacity-50 hover-opacity-100 transition-all ms-1" data-share-target="keyboard-shortcuts" aria-haspopup="dialog" aria-label="Share link: Keyboard Shortcuts"> Share link </button> </h3> <h4 id="emacs-mode-default" class="position-relative d-flex align-items-center group"> Emacs Mode (Default) <button type="button" class="h-share btn btn-link p-0 text-decoration-none link-secondary opacity-50 hover-opacity-100 transition-all ms-1" data-share-target="emacs-mode-default" aria-haspopup="dialog" aria-label="Share link: Emacs Mode (Default)"> Share link </button> </h4>Navigation: <ul> <li><code>Ctrl+A</code>: Beginning of line</li> <li><code>Ctrl+E</code>: End of line</li> <li><code>Alt+F</code>: Forward one word</li> <li><code>Alt+B</code>: Backward one word</li> </ul> Editing: <ul> <li><code>Ctrl+K</code>: Kill to end of line</li> <li><code>Ctrl+U</code>: Kill to beginning of line</li> <li><code>Ctrl+W</code>: Kill word backward</li> <li><code>Ctrl+Y</code>: Yank (paste) from kill ring</li> </ul> History: <ul> <li><code>Ctrl+P</code>: Previous history entry</li> <li><code>Ctrl+N</code>: Next history entry</li> <li><code>Ctrl+R</code>: Reverse search history</li> <li><code>Ctrl+S</code>: Forward search history</li> </ul> Control: <ul> <li><code>Ctrl+L</code>: Clear screen</li> <li><code>Ctrl+C</code>: Cancel current input</li> <li><code>Ctrl+D</code>: Delete character or exit on empty line</li> </ul> <h4 id="vi-mode" class="position-relative d-flex align-items-center group"> Vi Mode <button type="button" class="h-share btn btn-link p-0 text-decoration-none link-secondary opacity-50 hover-opacity-100 transition-all ms-1" data-share-target="vi-mode" aria-haspopup="dialog" aria-label="Share link: Vi Mode"> Share link </button> </h4>Activate: <div class="highlight"><pre tabindex="0" class="chroma"><code class="language-fallback" data-lang="fallback">geode> \set keymap vi </code></pre></div>Command Mode: <ul> <li><code>ESC</code>: Enter command mode</li> <li><code>i</code>: Insert mode</li> <li><code>a</code>: Append mode</li> <li><code>A</code>: Append at end of line</li> </ul> Navigation (command mode): <ul> <li><code>h</code>: Left</li> <li><code>l</code>: Right</li> <li><code>w</code>: Forward word</li> <li><code>b</code>: Backward word</li> <li><code>0</code>: Beginning of line</li> <li><code>$</code>: End of line</li> </ul> Editing (command mode): <ul> <li><code>dd</code>: Delete line</li> <li><code>dw</code>: Delete word</li> <li><code>x</code>: Delete character</li> <li><code>p</code>: Paste</li> </ul> <h3 id="history-navigation" class="position-relative d-flex align-items-center group"> History Navigation <button type="button" class="h-share btn btn-link p-0 text-decoration-none link-secondary opacity-50 hover-opacity-100 transition-all ms-1" data-share-target="history-navigation" aria-haspopup="dialog" aria-label="Share link: History Navigation"> Share link </button> </h3> <h4 id="reverse-search" class="position-relative d-flex align-items-center group"> Reverse Search <button type="button" class="h-share btn btn-link p-0 text-decoration-none link-secondary opacity-50 hover-opacity-100 transition-all ms-1" data-share-target="reverse-search" aria-haspopup="dialog" aria-label="Share link: Reverse Search"> Share link </button> </h4>Press Ctrl+R: <div class="highlight"><pre tabindex="0" class="chroma"><code class="language-fallback" data-lang="fallback">(reverse-i-search)`cre': CREATE (n:Person {name: 'Alice'}) </code></pre></div>Type to Filter: <div class="highlight"><pre tabindex="0" class="chroma"><code class="language-fallback" data-lang="fallback">(reverse-i-search)`match': MATCH (n:Person) RETURN n.name </code></pre></div>Press Enter: Execute found command Press Ctrl+R Again: Next match <h4 id="history-file" class="position-relative d-flex align-items-center group"> History File <button type="button" class="h-share btn btn-link p-0 text-decoration-none link-secondary opacity-50 hover-opacity-100 transition-all ms-1" data-share-target="history-file" aria-haspopup="dialog" aria-label="Share link: History File"> Share link </button> </h4>Location: <ul> <li>Linux: <code>~/.local/share/geode/history</code></li> <li>macOS: <code>~/Library/Application Support/geode/history</code></li> <li>Windows: <code>%APPDATA%\geode\history</code></li> </ul> Custom Location: <div class="highlight"><pre tabindex="0" class="chroma"><code class="language-bash" data-lang="bash">export GEODE_HISTORY=/path/to/custom/history geode shell </code></pre></div> <h3 id="advanced-features" class="position-relative d-flex align-items-center group"> Advanced Features <button type="button" class="h-share btn btn-link p-0 text-decoration-none link-secondary opacity-50 hover-opacity-100 transition-all ms-1" data-share-target="advanced-features" aria-haspopup="dialog" aria-label="Share link: Advanced Features"> Share link </button> </h3> <h4 id="query-variables" class="position-relative d-flex align-items-center group"> Query Variables <button type="button" class="h-share btn btn-link p-0 text-decoration-none link-secondary opacity-50 hover-opacity-100 transition-all ms-1" data-share-target="query-variables" aria-haspopup="dialog" aria-label="Share link: Query Variables"> Share link </button> </h4>Set Variable: <div class="highlight"><pre tabindex="0" class="chroma"><code class="language-gql" data-lang="gql">geode> WITH 30 AS age_threshold geode- MATCH (p:Person) geode- WHERE p.age > age_threshold geode- RETURN p.name, p.age; </code></pre></div>Reuse in Multiple Queries: <div class="highlight"><pre tabindex="0" class="chroma"><code class="language-gql" data-lang="gql">geode> CREATE (n:Config {threshold: 30}) geode> MATCH (c:Config) geode- WITH c.threshold AS threshold geode- MATCH (p:Person) geode- WHERE p.age > threshold geode- RETURN p.name; </code></pre></div> <h4 id="pipeline-queries" class="position-relative d-flex align-items-center group"> Pipeline Queries <button type="button" class="h-share btn btn-link p-0 text-decoration-none link-secondary opacity-50 hover-opacity-100 transition-all ms-1" data-share-target="pipeline-queries" aria-haspopup="dialog" aria-label="Share link: Pipeline Queries"> Share link </button> </h4>WITH Clause Chaining: <div class="highlight"><pre tabindex="0" class="chroma"><code class="language-gql" data-lang="gql">geode> MATCH (u:User)-[:PLACED]->(o:Order) geode- WITH u, count(o) AS order_count geode- WHERE order_count > 5 geode- RETURN u.name, order_count geode- ORDER BY order_count DESC; </code></pre></div> <h4 id="parameterized-queries" class="position-relative d-flex align-items-center group"> Parameterized Queries <button type="button" class="h-share btn btn-link p-0 text-decoration-none link-secondary opacity-50 hover-opacity-100 transition-all ms-1" data-share-target="parameterized-queries" aria-haspopup="dialog" aria-label="Share link: Parameterized Queries"> Share link </button> </h4>Future Feature: <div class="highlight"><pre tabindex="0" class="chroma"><code class="language-gql" data-lang="gql">geode> :set min_age 30 geode> MATCH (p:Person) WHERE p.age > $min_age RETURN p.name; </code></pre></div> <h3 id="practical-examples" class="position-relative d-flex align-items-center group"> Practical Examples <button type="button" class="h-share btn btn-link p-0 text-decoration-none link-secondary opacity-50 hover-opacity-100 transition-all ms-1" data-share-target="practical-examples" aria-haspopup="dialog" aria-label="Share link: Practical Examples"> Share link </button> </h3> <h4 id="data-exploration" class="position-relative d-flex align-items-center group"> Data Exploration <button type="button" class="h-share btn btn-link p-0 text-decoration-none link-secondary opacity-50 hover-opacity-100 transition-all ms-1" data-share-target="data-exploration" aria-haspopup="dialog" aria-label="Share link: Data Exploration"> Share link </button> </h4>Count Nodes: <div class="highlight"><pre tabindex="0" class="chroma"><code class="language-gql" data-lang="gql">geode> MATCH (n) RETURN labels(n) AS label, count(n) AS count ┌────────┬───────┐ │ label │ count │ ├────────┼───────┤ │ Person │ 100 │ │ Order │ 500 │ └────────┴───────┘ </code></pre></div>Sample Data: <div class="highlight"><pre tabindex="0" class="chroma"><code class="language-gql" data-lang="gql">geode> MATCH (n:Person) RETURN n LIMIT 5 </code></pre></div>Schema Discovery: <div class="highlight"><pre tabindex="0" class="chroma"><code class="language-gql" data-lang="gql">geode> CALL db.schema.nodeLabels() ┌────────┐ │ label │ ├────────┤ │ Person │ │ Order │ │ Product│ └────────┘ </code></pre></div> <h4 id="database-administration" class="position-relative d-flex align-items-center group"> Database Administration <button type="button" class="h-share btn btn-link p-0 text-decoration-none link-secondary opacity-50 hover-opacity-100 transition-all ms-1" data-share-target="database-administration" aria-haspopup="dialog" aria-label="Share link: Database Administration"> Share link </button> </h4>Show Indexes: <div class="highlight"><pre tabindex="0" class="chroma"><code class="language-gql" data-lang="gql">geode> CALL db.indexes() ┌──────────────────┬──────────┬────────┐ │ name │ type │ labels │ ├──────────────────┼──────────┼────────┤ │ person_email_idx │ btree │ Person │ │ product_sku_idx │ unique │ Product│ └──────────────────┴──────────┴────────┘ </code></pre></div>Database Statistics: <div class="highlight"><pre tabindex="0" class="chroma"><code class="language-gql" data-lang="gql">geode> CALL db.stats() ┌──────────────┬────────┐ │ metric │ value │ ├──────────────┼────────┤ │ node_count │ 10000 │ │ edge_count │ 25000 │ │ storage_mb │ 450 │ └──────────────┴────────┘ </code></pre></div> <h4 id="development-workflow" class="position-relative d-flex align-items-center group"> Development Workflow <button type="button" class="h-share btn btn-link p-0 text-decoration-none link-secondary opacity-50 hover-opacity-100 transition-all ms-1" data-share-target="development-workflow" aria-haspopup="dialog" aria-label="Share link: Development Workflow"> Share link </button> </h4>1. Test Query: <div class="highlight"><pre tabindex="0" class="chroma"><code class="language-gql" data-lang="gql">geode> EXPLAIN MATCH (n:Person) WHERE n.age > 25 RETURN n.name # Review query plan </code></pre></div>2. Optimize: <div class="highlight"><pre tabindex="0" class="chroma"><code class="language-gql" data-lang="gql">geode> CREATE INDEX person_age_idx ON Person (age) Index created </code></pre></div>3. Verify: <div class="highlight"><pre tabindex="0" class="chroma"><code class="language-gql" data-lang="gql">geode> PROFILE MATCH (n:Person) WHERE n.age > 25 RETURN n.name # Check performance metrics </code></pre></div> <h3 id="troubleshooting" class="position-relative d-flex align-items-center group"> Troubleshooting <button type="button" class="h-share btn btn-link p-0 text-decoration-none link-secondary opacity-50 hover-opacity-100 transition-all ms-1" data-share-target="troubleshooting" aria-haspopup="dialog" aria-label="Share link: Troubleshooting"> Share link </button> </h3> <h4 id="common-issues" class="position-relative d-flex align-items-center group"> Common Issues <button type="button" class="h-share btn btn-link p-0 text-decoration-none link-secondary opacity-50 hover-opacity-100 transition-all ms-1" data-share-target="common-issues" aria-haspopup="dialog" aria-label="Share link: Common Issues"> Share link </button> </h4>Issue: “REPL error: FileNotFound” Solution: <div class="highlight"><pre tabindex="0" class="chroma"><code class="language-bash" data-lang="bash"># Create history directory mkdir -p ~/.local/share/geode # Linux mkdir -p ~/Library/Application\ Support/geode # macOS </code></pre></div><hr> Issue: Queries not executing Cause: Missing semicolon on multi-line query Solution: <div class="highlight"><pre tabindex="0" class="chroma"><code class="language-gql" data-lang="gql">geode> MATCH (n) geode- RETURN n; # Add semicolon </code></pre></div><hr> Issue: Connection lost during query Solution: <div class="highlight"><pre tabindex="0" class="chroma"><code class="language-fallback" data-lang="fallback">geode> \connect localhost:3141 geode> # Re-run query </code></pre></div><hr> Issue: Output too wide for terminal Solution: <div class="highlight"><pre tabindex="0" class="chroma"><code class="language-fallback" data-lang="fallback">geode> \format json # Or use SELECT to limit columns geode> MATCH (n) RETURN n.id, n.name # Fewer columns </code></pre></div> <h3 id="best-practices" class="position-relative d-flex align-items-center group"> Best Practices <button type="button" class="h-share btn btn-link p-0 text-decoration-none link-secondary opacity-50 hover-opacity-100 transition-all ms-1" data-share-target="best-practices" aria-haspopup="dialog" aria-label="Share link: Best Practices"> Share link </button> </h3> <h4 id="query-development" class="position-relative d-flex align-items-center group"> Query Development <button type="button" class="h-share btn btn-link p-0 text-decoration-none link-secondary opacity-50 hover-opacity-100 transition-all ms-1" data-share-target="query-development" aria-haspopup="dialog" aria-label="Share link: Query Development"> Share link </button> </h4><ol> <li> Start Simple: <div class="highlight"><pre tabindex="0" class="chroma"><code class="language-gql" data-lang="gql">geode> MATCH (n:Person) RETURN count(n) # Test filter geode> MATCH (n:Person) RETURN n LIMIT 1 # Inspect structure geode> MATCH (n:Person) WHERE n.age > 25 RETURN n # Full query </code></pre></div></li> <li> Use EXPLAIN: <div class="highlight"><pre tabindex="0" class="chroma"><code class="language-gql" data-lang="gql">geode> EXPLAIN MATCH (n:Person)-[:KNOWS]->(m) RETURN n, m # Verify query plan before executing </code></pre></div></li> <li> Limit Results: <div class="highlight"><pre tabindex="0" class="chroma"><code class="language-gql" data-lang="gql">geode> MATCH (n) RETURN n LIMIT 100 # Always limit during development </code></pre></div></li> </ol> <h4 id="history-management" class="position-relative d-flex align-items-center group"> History Management <button type="button" class="h-share btn btn-link p-0 text-decoration-none link-secondary opacity-50 hover-opacity-100 transition-all ms-1" data-share-target="history-management" aria-haspopup="dialog" aria-label="Share link: History Management"> Share link </button> </h4>Search History: <div class="highlight"><pre tabindex="0" class="chroma"><code class="language-fallback" data-lang="fallback"># Press Ctrl+R, type 'CREATE' # Find previous CREATE statements quickly </code></pre></div>Save Important Queries: <div class="highlight"><pre tabindex="0" class="chroma"><code class="language-bash" data-lang="bash"># Copy history to file cat ~/.local/share/geode/history | grep CREATE > important_queries.txt </code></pre></div> <h4 id="productivity-tips" class="position-relative d-flex align-items-center group"> Productivity Tips <button type="button" class="h-share btn btn-link p-0 text-decoration-none link-secondary opacity-50 hover-opacity-100 transition-all ms-1" data-share-target="productivity-tips" aria-haspopup="dialog" aria-label="Share link: Productivity Tips"> Share link </button> </h4>1. Use Aliases for Long Queries: <div class="highlight"><pre tabindex="0" class="chroma"><code class="language-bash" data-lang="bash"># Create shell alias alias gq='geode query --insecure' gq "MATCH (n:Person) RETURN count(n)" </code></pre></div>2. Format Output for Scripts: <div class="highlight"><pre tabindex="0" class="chroma"><code class="language-fallback" data-lang="fallback">geode> \format json geode> # Pipe to jq for processing </code></pre></div>3. Transaction Batching: <div class="highlight"><pre tabindex="0" class="chroma"><code class="language-gql" data-lang="gql">geode> \begin geode> # Multiple CREATE/UPDATE statements geode> \commit # Atomic batch operation </code></pre></div> <h3 id="references" class="position-relative d-flex align-items-center group"> References <button type="button" class="h-share btn btn-link p-0 text-decoration-none link-secondary opacity-50 hover-opacity-100 transition-all ms-1" data-share-target="references" aria-haspopup="dialog" aria-label="Share link: References"> Share link </button> </h3> <h4 id="documentation" class="position-relative d-flex align-items-center group"> Documentation <button type="button" class="h-share btn btn-link p-0 text-decoration-none link-secondary opacity-50 hover-opacity-100 transition-all ms-1" data-share-target="documentation" aria-haspopup="dialog" aria-label="Share link: Documentation"> Share link </button> </h4><ul> <li>REPL Usage: <code>docs/REPL_USAGE.md</code></li> <li>Advanced Features: <code>docs/development/REPL_ADVANCED_FEATURES.md</code></li> <li>Client Libraries: <code>docs/client-libraries/</code></li> </ul> <h4 id="configuration-1" class="position-relative d-flex align-items-center group"> Configuration <button type="button" class="h-share btn btn-link p-0 text-decoration-none link-secondary opacity-50 hover-opacity-100 transition-all ms-1" data-share-target="configuration-1" aria-haspopup="dialog" aria-label="Share link: Configuration"> Share link </button> </h4><ul> <li>History File: Platform-specific</li> <li>Settings: Stored in session (not persisted)</li> <li>Customization: Environment variables</li> </ul> <h3 id="next-steps" class="position-relative d-flex align-items-center group"> Next Steps <button type="button" class="h-share btn btn-link p-0 text-decoration-none link-secondary opacity-50 hover-opacity-100 transition-all ms-1" data-share-target="next-steps" aria-haspopup="dialog" aria-label="Share link: Next Steps"> Share link </button> </h3>For Beginners: <ul> <li><a href="/docs/gql/guide/" >GQL Guide</a> - Query language fundamentals</li> <li><a href="/docs/model/data-model-and-types/" >Data Model</a> - Graph concepts</li> <li><a href="/guides/installation/" >Getting Started</a> - Installation guide</li> </ul> For Developers: <ul> <li><a href="/docs/development/repl-advanced/" >Advanced REPL Features</a> - Scripting, automation</li> <li><a href="/docs/guides/testing-strategies/" >Testing Strategies</a> - Query testing</li> <li><a href="/docs/client-libraries/go-client/" >Client Libraries</a> - Programmatic access</li> </ul> For Administrators: <ul> <li><a href="/docs/configuration/server-configuration/" >Server Configuration</a> - REPL server settings</li> <li><a href="/docs/ops/observability/" >Monitoring</a> - Query monitoring</li> <li><a href="/docs/security/overview/" >Security</a> - Authentication setup</li> </ul> <hr> Document Version: 1.0 Last Updated: January 24, 2026 Status: Production Ready Platform Support: Linux, macOS, Windows Shell Modes: Emacs (default), Vi