Developer Tools

SQL CLI, Desktop GUI & VS Code Extension

Professional development experience with a native Tauri-powered desktop application, deep VS Code integration, and an interactive SQL CLI that connects to your running Delta Forge instance. Query, explore, and manage Delta Lake tables from your preferred environment.

Tauri-powered native desktop app
VS Code extension with IntelliSense
CLI connects to your Delta Forge instance
Delta Forge Desktop SELECT customer_id, SUM (amount) FROM orders GROUP BY 1 id total rows C001 4,892 47 C002 12,350 128 C003 987 12 VS Code Extension DELTA FORGE schemas/ public orders users analytics events SELECT * FROM orders WHERE s status ship_date subtotal VARCHAR DATE DECIMAL Delta Forge REST API SSE Streaming Arrow IPC Delta Forge Tools GUI, VS Code Ext CLI, REST API BI & Analytics Tableau, Power BI Grafana, Superset

Interactive SQL CLI

A production-grade terminal for Delta Forge — powered by Reedline

Rich Editing Experience

  • SQL syntax highlighting as you type
  • Tab completion for keywords and objects
  • Multi-line editing with smart validation
  • Persistent history with Ctrl+R search
  • Built-in slash commands: /tables, /inspect, /plan

TUI Setup Wizard

  • Full-screen Ratatui login on first run
  • Interactive node picker with status indicators
  • Graceful fallback for headless/CI environments
  • Profile-based config (~/.deltaforge/config.toml)
  • Environment variable overrides for automation

Three Output Modes

  • Table — Unicode-bordered, column-aligned, styled NULLs
  • JSON — Structured output for programmatic consumption
  • Compact — Borderless for constrained terminals
  • Streaming Arrow IPC for large result sets
  • Full type fidelity from engine to terminal

Script Execution & Safety

  • SQL file execution with -D key=value variable substitution
  • Piped input from stdin for CI/CD pipelines
  • Profile-based configuration for multiple environments
  • Safety prompts for DROP, TRUNCATE, DELETE
  • Bypassable with --force for automation
# Connect to a Delta Forge node
delta-forge-cli --profile production

# Execute a script with variables
delta-forge-cli run migrate.sql -D env=prod -D date=2024-01-15

# One-shot query with JSON output
delta-forge-cli --format json query SELECT count(*) FROM sales.orders

Delta Forge Desktop

Native cross-platform application built with Tauri + React

🖥️

Native Performance

Built with Tauri for minimal resource usage. Native backend with React frontend delivers native speed.

🌍

Cross-Platform

Runs on Windows, macOS, and Linux with native look and feel on each platform.

🔒

Secure by Design

Credentials stored in OS keychain. No data leaves your machine without explicit action.

📦

Self-Contained

Single executable with embedded runtime. Sets up everything it needs on first run.

🧩

Visual Flattener

Visual flattener for JSON, XML, EDI, HL7, FHIR, Protobuf. Configure nested-to-flat mapping with an interactive tree.

Advanced Query Editor

Professional SQL editing with intelligent assistance

Syntax Highlighting

  • Full SQL syntax support
  • PL/pgSQL procedure highlighting
  • Keyword recognition
  • String and comment detection
  • Custom theme support

Auto-Completion

  • Schema-aware table completion
  • Column name suggestions
  • Function signature hints
  • Keyword completion
  • Alias resolution

Error Detection

  • Real-time syntax validation
  • Type checking hints
  • Missing column warnings
  • Ambiguous reference detection
  • Quick-fix suggestions

Productivity Features

  • Multi-cursor editing
  • Code folding
  • Query history
  • Saved snippets
  • Format on save

Results Viewer

Explore and analyze query results efficiently

Data Grid

  • Virtual scrolling for millions of rows
  • Column sorting and filtering
  • Resizable columns
  • Type-aware formatting
  • NULL value highlighting
  • Copy cell/row/selection

Data Preview

  • JSON/XML pretty printing
  • Binary hex view
  • Image preview (BLOB)
  • Geometry visualization
  • Array expansion
  • Struct navigation

Export Options

  • CSV with encoding options
  • JSON (records or array)
  • Excel (XLSX)
  • Parquet
  • SQL INSERT statements
  • Clipboard (TSV)

Statistics Panel

  • Row count and timing
  • Column statistics
  • Value distribution
  • Query plan viewer
  • Execution metrics
  • I/O statistics

Schema Browser

Navigate your data catalog with ease

Object Tree

📁 production
📂 analytics
📊 daily_metrics
📊 user_sessions
👁️ active_users_view
📂 sales
📊 orders
📊 products
📊 customers
📂 staging

Object Details

  • Columns - Names, types, nullability, comments
  • Partitions - Partition columns and values
  • Statistics - Row count, size, last modified
  • Properties - Table properties and metadata
  • History - Transaction log entries
  • Samples - Quick data preview

VS Code Extension

Deep integration with your favorite code editor

SQL Language Features

✓ Syntax highlighting for SQL, PL/pgSQL
✓ IntelliSense with schema awareness
✓ Go to definition for tables and views
✓ Hover documentation for functions
✓ Signature help for function calls
✓ Code actions and quick fixes

Execution Features

✓ Run query under cursor (Ctrl+Enter)
✓ Run selection or entire file
✓ Results in side panel or new tab
✓ Query execution history
✓ Multiple connection management
✓ Parameter prompts for prepared statements

Explorer Integration

✓ Database explorer in sidebar
✓ Browse catalogs, schemas, tables
✓ View column details and DDL
✓ Drag-and-drop table references
✓ Generate SELECT from table
✓ Copy qualified table names

Keyboard-First Design

Efficient workflows with comprehensive shortcuts

Query Execution

Ctrl+Enter Execute query
Ctrl+Shift+Enter Execute selection
Ctrl+. Cancel execution
F5 Refresh results

Navigation

Ctrl+1 Focus editor
Ctrl+2 Focus results
Ctrl+B Toggle schema browser
Ctrl+P Quick open

Editing

Ctrl+Space Trigger completion
Ctrl+Shift+F Format SQL
Ctrl+/ Toggle comment
Ctrl+D Duplicate line

Results

Ctrl+C Copy cell/selection
Ctrl+Shift+C Copy with headers
Ctrl+E Export results
↑/↓ Navigate rows

Connection Management

Manage multiple environments and connections

Connection Profiles

  • Named connection configurations
  • Environment grouping (dev, staging, prod)
  • Quick connection switching
  • Import/export profiles
  • Color-coded connections

Authentication

  • Username/password storage in keychain
  • SSO/SAML browser flow
  • API token authentication
  • Client certificate auth
  • Kerberos support

Connection Options

  • SSL/TLS configuration
  • Connection timeout settings
  • Query timeout defaults
  • Result set limits
  • Auto-reconnect behavior

Connection Status

  • Active connection indicator
  • Connection health monitoring
  • Session information display
  • Query queue status
  • Auto-disconnect on idle

Query Plan Visualization

Understand and optimize your queries

Visual Plan Tree

Interactive tree visualization of query execution plan with operator details.

  • Expand/collapse operators
  • Row estimates vs actuals
  • Cost highlighting
  • Bottleneck detection

Operator Details

Detailed information for each plan operator.

  • Input/output schemas
  • Filter expressions
  • Join conditions
  • Partition pruning info

Execution Metrics

Runtime statistics for performance analysis.

  • Time per operator
  • Rows processed
  • Memory usage
  • I/O statistics

Optimization Hints

Actionable suggestions for query improvement.

  • Missing index suggestions
  • Partition pruning opportunities
  • Statistics staleness warnings
  • Rewrite recommendations

Supercharge your development workflow

Professional tools for professional data engineers.

Download Desktop App Install VS Code Extension