Daxon

The Unified Modern Data Intelligence Platform & BI Studio for VS Code

Daxon transforms Visual Studio Code into a complete, enterprise-grade data workspace. Query SQL databases, explore cloud data warehouses, analyze local file datasets, map relational ER diagrams, design table schemas visually, build live Power BI-style dashboards, profile statistical distributions, run automated data quality pipelines, and export to Jupyter Notebooks — all directly inside your editor without switching between external tools.

⚡ Why Daxon?

Modern data engineering and analytics often require juggling half a dozen disjointed applications: a database GUI (DBeaver/DataGrip), a BI tool (Power BI/Tableau/Metabase), a notebook environment (Jupyter), data quality frameworks (Great Expectations/dbt), and terminal scripts.

Daxon eliminates context switching by embedding an end-to-end data intelligence lifecycle natively inside VS Code:

┌─────────────────────────────────────────────────────────────────────────────────┐
│                                   DAXON                                         │
│                                                                                 │
│   🔌 CONNECT        ⚡ QUERY            🕸️ MODEL          📊 VISUALIZE          │
│   Postgres, MySQL,   Multi-Tab SQL,     Interactive ER,   Live Dashboards,      │
│   SQLite, DuckDB,    Cursor Execution,  Visual Table      Power BI Templates,   │
│   Cloud Warehouses,  Query Optimizer,   Designer, Metric  KPI Cards, Charts,    │
│   Parquet, CSV, XLSX Safety Guards      Semantic Layers   Real-Time Refresh     │
│                                                                                 │
│   📈 PROFILE        🧪 VALIDATE         🌳 AUTOMATE       🐍 EXPORT             │
│   Distributions,     Automated Rules,   Lineage DAG,      Jupyter (.ipynb),     │
│   Outlier Detection, Quality Reports,   Topological Run,  Pandas / Polars,      │
│   Histograms, Stats  Anomaly Traps      Pipeline Monitor  Excel, HTML Reports   │
└─────────────────────────────────────────────────────────────────────────────────┘

✨ Core Capabilities

1. 🔌 Universal Connectivity & Cloud Warehouses

Connect seamlessly to relational databases, analytical file formats, and cloud warehouses:

• Relational Databases: PostgreSQL, MySQL, MariaDB, SQLite (in-memory WASM & native file).
• Embedded Analytics: DuckDB, Parquet, CSV, JSON, and Excel (.xlsx, .xls).
• Cloud Warehouses: ClickHouse, Snowflake, Google BigQuery, and Amazon Redshift.
• Local Data Drag & Drop: Drag .sqlite, .parquet, .csv, or .json files directly from your desktop into the connection modal, or use the native OS file/folder browser with instant schema discovery.

2. ⚡ Intelligent SQL Workbench

A high-performance query editor designed specifically for developers and analysts:

• Ultra-Clean Single-Row Command Bar: Compact, distraction-free toolbar with integrated database switching, connection status, and one-click actions.
• Multi-Tab Workspaces: Open multiple concurrent query sessions with independent database targets and per-tab execution contexts.
• Selection & Cursor-Line Execution: Highlight any SQL block to execute just that selection, or press Cmd+Enter / Ctrl+Enter to run the statement under the cursor without deselecting code.
• Smart Query Advisor: Real-time heuristic linting that flags Cartesian products (CROSS JOIN), unindexed wildcard filters (LIKE '%...'), missing LIMIT clauses, and inefficient subqueries.
• Destructive Query Safeguards: Automatic confirmation dialogues before executing high-risk statements (DROP, TRUNCATE, unfiltered DELETE, UPDATE).
• Visual EXPLAIN Plan: Inspect visual query execution plans and cost bottlenecks with full dialect support.

3. 🕸️ Interactive Relational ER Diagram Canvas

Understand complex schemas instantly with an interactive entity-relationship map:

• Automatic PK/FK Discovery: Automatically parses foreign key constraints and primary keys.
• Smart Implicit Inferences: Intelligently identifies relationships from naming conventions (e.g., user_id $\leftrightarrow$ users.id, customer_id $\leftrightarrow$ customers.id).
• Dynamic Physics & Layout Engines: Choose between Force-Directed (Physics), Hierarchical (DAG), and Compact Grid layouts.
• Pan & Zoom Infinite Canvas: Draggable table cards, column datatype badges (🔑 PK, 🔗 FK), and hover-activated relationship glow.
• One-Click Mermaid Export: Export the active schema diagram to standard Mermaid ER code or vector SVG for documentation.

4. 🛠️ Visual Table Designer

Design and alter schemas without writing manual DDL:

• No-Code Schema Builder: Add, edit, reorder, or drop columns, configure primary keys, autoincrement, unique constraints, and foreign key references.
• Index Management: Create B-Tree, Unique, and Composite indexes with interactive column selection.
• Multi-Dialect DDL Generator: Generates clean, production-ready SQL for PostgreSQL, MySQL, SQLite, DuckDB, and Cloud Warehouses in real time.

5. 📊 Power BI-Style BI Studio & Dashboard Templates

Build interactive visual analytics without leaving VS Code:

• Rich Visualization Types: Bar (Vertical & Horizontal), Multi-Series Line, Area, Doughnut, Pie, Radar, Polar Area, KPI Metric Cards, and Target Progress Gauges.
• Pre-Built Business Templates:
  • Executive Sales & Revenue: Gross revenue, average order value, monthly revenue trends, category breakdown.
  • Product & Inventory Analytics: Stock levels, unit pricing distributions, reorder alerts, profit margin gauges.
  • Financial Performance: Cash flow, revenue vs. cost analysis, expense breakdown, net margin.
  • User Engagement & Growth: Daily/Monthly active users, churn rates, conversion funnels, device distribution.
• Live Real-Time Monitoring: Set automated background refresh cadences (5s, 10s, 30s, 1m, 5m) with live pulsing indicators for operational monitoring.

6. 📈 Automated Statistical Data Profiler

Get instant deep-dive diagnostics on any dataset or query result:

• Column-Level Descriptive Statistics: Distinct counts, nullability %, min, max, mean, median, standard deviation, and quartile ranges.
• Outlier & Anomaly Detection: Built-in Tukey Interquartile Range (IQR) outlier scoring.
• Distribution Histograms: Visual bucketed frequency charts for numerical and temporal attributes.

7. 🧪 Data Quality & Validation Engine

Catch silent data regressions and schema drift before they hit production:

• Automated Rule Suite: Execute out-of-the-box assertions including not_null, unique, range_between, accepted_values, and custom_sql.
• Quality Scorecard: Comprehensive pass/fail audit reports with severity ratings and offending row counts.

8. 🌳 Data Lineage & DAG Pipeline Runner

• Lineage Dependency Graph: Visual upstream and downstream dependency traversal across tables, views, models, and transformations.
• Topological DAG Runner: Automatically sequence and execute multi-step transformation pipelines with cycle detection.

9. 🐍 Python, Jupyter Notebook & Multi-Format Export Bridge

Export query results and datasets into any analytical workflow:

• Jupyter Notebooks (.ipynb): Generates modular .ipynb files containing markdown headers, database drivers, automated pandas extraction, summary statistics (df.describe()), and Matplotlib starter charts — opens natively in VS Code.
• Python Scripts (.py): Generates optimized Pandas or Polars scripts with built-in connection handling.
• Spreadsheets & Reports: Export directly to Excel (.xlsx), CSV (.csv), JSON (.json), or standalone interactive HTML analytical reports.

10. ⚡ Instant Database Service Manager

• Sub-50ms Non-Blocking Socket Probes: Rapid status identification across PostgreSQL (5432), MySQL (3306), Redis (6379), and custom ports without freezing the editor.
• One-Click Service Control: Start, stop, or restart local database services directly from the toolbar or connection manager.

🚀 Quick Start Guide

Step 1: Install & Open Daxon

1. Install Daxon from the VS Code Marketplace or load the .vsix.
2. Click the Daxon icon in the VS Code Activity Bar (left sidebar).

Step 2: Connect to a Data Source

• Local Files: In the Connections view, click + New Connection, choose SQLite, DuckDB, or Analytical File, and drag & drop your .sqlite, .parquet, or .csv file onto the drop zone.
• Databases: Choose PostgreSQL or MySQL, enter your credentials, and click Connect.
• Quick Playground: Click ⚡ :memory: or 📊 Sample E-Commerce DB for an instant pre-loaded playground.

Step 3: Write & Execute SQL

1. Click New SQL Workbench from the explorer toolbar.
2. Type your SQL query.
3. Press Cmd+Enter (macOS) or Ctrl+Enter (Windows/Linux) to run.

Step 4: Visualize & Export

• Export to Jupyter: In the SQL Workbench toolbar, select Notebook (.ipynb) from the export dropdown and click ⬇ Export.
• Generate ER Diagram: Click 🕸️ ER Diagram in the toolbar to inspect table relationships.
• Create Dashboard: Right-click any table in the sidebar and choose Create Dashboard from Template....

🔌 Supported Connectors & Engines

⌨️ Command Reference & Shortcuts

⚙️ Extension Settings

Configure Daxon via VS Code Settings (Cmd+, or Ctrl+, $\rightarrow$ search Daxon):

{
  // Maximum number of rows returned in a single query result set
  "dataIntelligence.maxQueryRows": 10000,

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

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

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

🔒 Security, Privacy & Local-First Philosophy

• 100% Local Processing: All queries, data profiling calculations, and visual rendering happen entirely on your machine.
• Zero Telemetry: Daxon does not collect, track, or transmit your queries, schemas, or data to external servers.
• Hardware-Grade Credential Storage: Database passwords and API tokens are never saved in plain text. They are encrypted using VS Code's native SecretStorage backed by the operating system keychain (macOS Keychain, Windows Credential Manager, Linux Secret Service).

📄 License & Publisher

• Publisher: Lofty Tech Labs
• License: MIT License — free for personal and commercial use.