Daxon

Advanced Database Intelligence, Visual Analytics & Workflow Automation Platform for VS Code

Intelligent SQL Studio with multi-tab Monaco editor, cursor execution (Cmd+Enter), performance advisor, and in-cell inline editing.

⚡ Overview

Daxon by LoftyTech Labs transforms Visual Studio Code into a unified, production-grade database development and data intelligence workspace.

Query SQL databases, edit records inline, build multi-chart visual dashboards, monitor live database activity, automate visual DAG workflows, transfer data across sources with persistent checkpoints, and secure RAG vector indexes against poisoning — all natively inside your editor without switching between external tools.

┌────────────────────────────────────────────────────────────────────────────────────────┐
│                                   DAXON 2.0 PLATFORM                                   │
│                                                                                        │
│   🔌 CONNECT             ⚡ SQL & INLINE EDIT     📊 VISUAL ANALYTICS    🛰️ MONITOR    │
│   PostgreSQL, MySQL,     Multi-Tab Monaco Editor, Multi-Chart Canvas,   Live Sessions, │
│   SQLite, CSV Delimited, Double-Click In-Cell,    In-Memory Aggregator, Lock Detection,│
│   Excel Workbooks        Safe Parameterized SQL   PNG/CSV/Excel/HTML    Kill/Cancel    │
│                                                                                        │
│   🔀 DAXON FLOW          🔄 DATA TRANSFER         🛡️ RAG SENTINEL       🕸️ SCHEMAS     │
│   Visual DAG Builder,    Cross-Source Migration,  Vector KB Explorer,   Interactive ER,│
│   Filter/Aggregate/Test, Checkpointed Sync,       Chunk Inspector,      Table Designer,│
│   Topological Runner     Auto Table Provisioning  Fail-Closed Firewall  Data Profiler  │
└────────────────────────────────────────────────────────────────────────────────────────┘

📸 Key Features

1. Multi-Chart Visual Analytics & BI Studio

Construct interactive visual dashboards directly from query results or database tables with a responsive multi-chart canvas and zero-latency in-memory aggregation.

• Side-by-Side Multi-Chart Canvas: Add, arrange, and view multiple charts simultaneously on a single canvas.
• Rich Visualization Types: Vertical Bar, Horizontal Bar, Multi-Series Line, Area, Donut, Pie, Radar, Polar Area, KPI Cards, and Target Gauges.
• In-Memory Analytical Engine: Slice, dice, group, filter, and aggregate datasets instantly without repeated round-trips to the database.
• Multi-Layout Modes: Seamlessly toggle between Grid, Stacked, and Focus views.
• Exporting Options: Download visual charts and datasets as PNG Image, CSV File, Excel Spreadsheet, JSON, or standalone Interactive HTML Reports.

2. Universal Database & File Connectivity (Strict 5-Source Allowlist)

Connect to relational databases and analytical file formats through a clean, unified dialog with encrypted credential storage, SSL/TLS verification, and read-only connection safeguards.

Daxon strictly enforces a centralized 5-source allowlist:

3. Intelligent SQL Studio & In-Cell Data Grid with Inline Editing

⚡ Execution Shortcuts

• Cmd+Enter / Ctrl+Enter: Run Till ; / Selected Block — executes only the statement under the cursor.
• Alt+Enter / Option+Enter: Run Current Line — executes the single active line.
• Cmd+Shift+Enter / Ctrl+Shift+Enter: Run All — executes the entire query buffer.
• Split Run dropdown button in the command bar for one-click mouse execution.

✏️ In-Cell Data Grid with Inline Editing

• Double-Click Any Cell: Instantly activates an inline editor with numeric, boolean, or text typing and a NULL toggle.
• Enter to Commit / Esc to Cancel: Confirms changes with visual indicators (● and gold border highlights).
• Tab & Shift+Tab Navigation: Move directly between cells while editing.
• Pending Changes Action Bar:
  • ✏️ N modified cell(s) change counter badge.
  • 💾 Save Changes: Generates safe, parameterized UPDATE ... WHERE ... statements matching primary keys with optimistic concurrency verification.
  • 📄 Preview SQL: Inspect the exact generated DML before applying.
  • ↩ Discard: Reverts rows back to original query results.
  • 📊 Open in Full Data Grid: Launch the dataset directly into the dedicated Data Grid panel with column statistics and rollback history.

🛠️ Complete Platform Capabilities

🛰️ Database Activity Monitor

• Live Session Diagnostics: Real-time snapshot of active client sessions, executing queries, host addresses, and execution durations.
• Lock Detection & Blocking PIDs: Identifies deadlocks and displays waiting vs. blocking process IDs.
• Safe Query Cancellation: Terminate long-running queries (Cancel) or kill unmanaged sessions (Kill) with safe confirmation safeguards.
• Engine-Aware Diagnostics: Deep telemetry for PostgreSQL and MySQL, and honest embedded status reporting for SQLite.

🔀 Daxon Flow: Visual DAG Workflow Builder

• Drag-and-Drop Node Architecture: Chain SQL Source Queries, Column Filters, Aggregations, Data Validations, and Target Destinations.
• Validation Rules & Halts: Enforce quality gates (not_null, range_between, row_count > 0); halts execution if rules fail.
• Topological DAG Runner: Detects circular dependencies and executes multi-step transformation pipelines in topological order.
• Persistent Flow Management: Save, run, inspect, and duplicate automated visual workflows.

🔄 Cross-Source Data Transfer Engine

• Any-to-Any Migration: Move data between PostgreSQL, MySQL, SQLite, CSV, and Excel seamlessly.
• Column Mapping & Type Casting: Rename columns, apply inline transformations, and cast data types during transfer.
• Conflict Policies: Configurable fail, skip duplicates, replace (truncate/delete before insert), or append.
• Persistent Checkpoints: Auto-resumes interrupted bulk migrations without data corruption.

🛡️ Daxon RAG Studio & Sentinel Security

• Knowledge Base Explorer: Inspect vector collections, indexed chunks, token counts, embeddings, and document provenance.
• Retrieval Query Lab: Test semantic and hybrid retrieval with similarity scores and ranking duration.
• Sentinel Security Firewall: Prevent untrusted, adversarial, or manipulated documents from entering RAG indexes.
• Poisoning Prevention: Detects Prompt Injections, Control Token Smuggling (<|im_start|>, [INST]), Sybil Flooding, Duplicate Shingles, and Metadata Anomalies with Fail-Closed quarantine and approval workflows.

🕸️ Interactive Relational ER Diagrams

• Automatic PK/FK Mapping: Automatically detects primary and foreign keys and draws interactive relational connectors.
• Implicit Relationship Detection: Discovers relationships from standard naming patterns (customer_id $\leftrightarrow$ customers.id).
• Interactive Physics Engine: Draggable table nodes, hover highlights, and zoomable infinite canvas.

🛠️ Visual Table Designer

• No-Code Schema Management: Add, modify, reorder, or delete columns with intuitive GUI controls.
• Constraint Configuration: Configure Primary Keys, Autoincrement, Not Null, Unique, and Foreign Key constraints.
• Multi-Dialect DDL Generator: Generates clean, production-ready DDL for PostgreSQL, MySQL, and SQLite.

📈 Statistical Data Profiler & Quality Test Suite

• Column-Level Statistics: Null %, distinct counts, min, max, mean, median, standard deviation, and quartiles.
• Outlier Detection: Automated Tukey IQR outlier detection.
• Data Quality Assertions: Run automated test suites to catch schema drift and regressions.

⌨️ Keyboard Shortcuts

🚀 Quickstart Guide

1. Install Extension: Install Daxon from the VS Code Marketplace or via VSIX:

   code --install-extension daxon-2.0.0.vsix
   

2. Open SQL Workbench:
   • Press Cmd+Shift+P (or Ctrl+Shift+P) and type Daxon: New SQL Workbench.
   • Alternatively, click the Daxon icon in the VS Code Activity Bar.
3. Connect a Data Source:
   • Click + Connect in the workbench header.
   • Select your database (PostgreSQL, MySQL, SQLite) or choose a CSV/Excel file.
4. Execute & Edit:
   • Type your query (e.g., SELECT * FROM customers;) and press Cmd+Enter.
   • Double-click any cell in the results grid to edit inline!
   • Click 💾 Save Changes to apply the updates to your database.
5. Visualize:
   • Click 📊 Open in Visual Analytics or use the Tools menu to view multi-chart visualizations.

⚙️ Extension Settings

Configure Daxon preferences via Settings (Cmd+, $\rightarrow$ search Daxon):

{
  // Maximum rows returned per query execution
  "dataIntelligence.maxQueryRows": 10000,

  // Cache duration in seconds for analytical queries
  "dataIntelligence.cacheTTLSeconds": 300,

  // Require explicit confirmation before DROP, TRUNCATE, or unfiltered DELETE/UPDATE
  "dataIntelligence.enableDestructiveQueryConfirmation": true,

  // Default export format for query results (csv, json, xlsx, html)
  "dataIntelligence.defaultExportFormat": "csv"
}

🔒 Security, Privacy & Local-First Philosophy

• 100% Local Execution: All query execution, data profiling, visual rendering, and transformations run locally on your system.
• Zero Telemetry: Daxon does not collect, track, or transmit your database credentials, queries, or records to external servers.
• Hardware-Grade Credential Storage: Passwords and connection secrets are encrypted using VS Code's native SecretStorage backed by the OS Keychain (macOS Keychain, Windows Credential Manager, Linux Secret Service).
• Password Redaction: Sensitive credentials and passwords in connection strings are automatically scrubbed from logs, explain plans, and monitor traces.

📄 License & Publisher

• Publisher: Lofty Tech Labs
• Repository: github.com/loftytechlabss/daxon
• License: MIT License — free for personal, team, and commercial use.