Skip to content
HL VaultsHL VaultsHL Vaults

SQL Analyzer

The SQL Analyzer gives you direct read access to your database. Run any query, explore the schema, and inspect results — all in your browser.

★ Pro The SQL Analyzer is a Pro-only feature.

sql analyzer herosql analyzer hero
The SQL Analyzer page showing the full layout: schema explorer on the left, query editor in the center, and results panel at the bottom.

Schema explorer

Section titled “Schema explorer”

The collapsible sidebar lists every table and view in your local database:

Table Contents
vault_info Vault metadata (name, leader, TVL, APR, PnL history)
vault_details Vault state (portfolio, leverage, margins, drawdown)
vault_asset_positions Open positions per vault
vault_fills Trade fills (time, coin, price, size, side, PnL)
vault_ledger_updates Deposit/withdrawal events
vault_user_info Per-user vault data (equity, PnL, lockup)
user_vault_equities User equity balances
vault_signals Computed quantitative signals
vault_ai_analyses LLM analysis results
vault_ai_threads AI chat threads
vault_ai_messages AI chat messages
vault_master_view Master vault listing (view)
wallet_leaderboard_view Leaderboard computation (view)
vault_fills_aggregated_view Aggregated fills (view)

Click any table to see its column names and types. This is a read-only view — only SELECT queries are allowed.

sql analyzer schemasql analyzer schema
The schema explorer expanded showing table and view names. Click on a table to show its columns in the detail panel.

Query editor

Section titled “Query editor”

Write SQL in the editor with:

  • Line numbers for easy reference
  • Syntax highlighting for SQL keywords
  • Format Keywords button to clean up SQL formatting
  • Clear to reset the editor

Running queries: Press Ctrl+Enter or click “Run” to execute. Results appear in the panel below. Multiple statements separated by semicolons produce multi-tab results.

sql analyzer editorsql analyzer editor
The query editor with a SELECT query written. Show the Run button, Format Keywords, and Clear buttons in the toolbar.

Results panel

Section titled “Results panel”

Query results display in a sortable table. Each result tab corresponds to a statement in a multi-statement query.

Cell Viewer — Click any cell to open a popup for inspecting large values (JSON, long text).

sql analyzer resultssql analyzer results
The results panel showing query output with multiple result tabs. Highlight the cell viewer popup for a large value.

Query history

Section titled “Query history”

Your last 25 queries are saved automatically. Browse history to re-run or reference previous queries. History persists in your browser’s local storage.

sql analyzer historysql analyzer history
The history panel showing recent queries with timestamps. Click a history item to load it into the editor.

Example queries

Section titled “Example queries”
-- Top 10 vaults by TVL
SELECT vault_name, tvl, apr, leader_performance
FROM vault_master_view
ORDER BY tvl DESC
LIMIT 10;
-- My vaults with performance grades
SELECT vault_name, equity, user_pnl, lp, dp
FROM vault_master_view
WHERE user_address = 'your_wallet_here';
-- Recently filled trades above $10K
SELECT vf.time, vf.coin, vf.side, vf.price, vf.closed_pnl, vi.vault_name
FROM vault_fills vf
JOIN vault_info vi ON vf.vault_id = vi.vault_id
WHERE vf.closed_pnl > 10000
ORDER BY vf.time DESC;
Section titled “Related”