Builder Config Editor

A comprehensive VS Code extension for configuration management, remote deployment, SSH/SFTP operations, database management, and query building for SQL and NoSQL databases.

Key Features

1. Configuration Editor

• Visual .config File Editor: Edit Builder CLI configuration files with a user-friendly interface
• Multi-Target Deployment: Define multiple deployment targets (production, staging, etc.)
• Real-time Validation: Instant feedback on configuration syntax and completeness
• SSH Host Management: Configure SSH connections inline with passwords or identity files

2. Build & Deploy Panel

• Unified Deployment Workflow:

  • Increment package versions automatically
  • Compile your project
  • Upload artifacts to remote servers
  • Execute post-deployment commands

• Docker Integration (New!):

  • Automatic OS detection
  • Runs on Linux natively, or automatically launches Ubuntu container on macOS/Windows
  • Auto-installs Docker if not present
  • Consistent, isolated build environment

• Advanced Progress Tracking:

  • 11-stage pipeline with visual indicators
  • Real-time step-by-step progress display
  • Duration tracking for each stage
  • Color-coded status badges (pending, in-progress, completed, error)
  • Animated pulse indicators for active operations

• Upload Queue Management:

  • Real-time SFTP file transfer progress
  • Parallel uploads with 5x concurrency
  • Per-file status tracking
  • Fallback tar.gz compression if individual files fail

• Package Synchronization: Bulk update and synchronize package versions across your project

3. Remote Panel (SSH & SFTP)

• SSH Terminal Integration: Open interactive SSH terminals directly from VS Code

• Remote File Explorer:

  • Browse remote server files and directories
  • Quick preview of file structure
  • Integrated terminal access per host

• SFTP File Upload:

  • Upload entire project directories with smart compression
  • Monitor transfer progress in real-time
  • Automatic directory creation on remote
  • Support for large files and complex directory structures

4. Database Manager & Query Builder

• Multi-Database Support:

  • PostgreSQL, MySQL/MariaDB
  • MongoDB, SQLite, Redis
  • SQL Server, Oracle

• Browser & Explorer:

  • List databases, tables, and collections
  • Navigate schema structure
  • View table statistics

• Query Builder:

  • Visual interface for building SQL and MongoDB queries
  • Column selection, ordering, filtering
  • Auto-generates native MQL and SQL syntax
  • Results displayed in embedded editor tab

• Data Grid:

  • Paginated data display
  • Inline cell editing (double-click to edit)
  • Search and filter capabilities
  • Export to CSV/JSON

• Full-Screen Editor:

  • Edit MongoDB JSON documents in full-screen modal
  • Real-time syntax validation
  • Instant save to database

5. Unified UI/UX

• Consistent Design System: All panels follow unified styling with smooth animations
• Progress Indicators:
  • Multi-stage progress bars with percentage tracking
  • Step-by-step execution flow
  • Status badges with animated indicators
  • Error reporting and duration tracking

Configuration Files

.config - Deployment Configuration

Located in your project root:

# Builder Deployment Configuration

SshHost production
BuildCommand npm run build
Shell bash

Host production
    HostName api.example.com
    Port 22
    User deploy
    IdentityFile ~/.ssh/deploy_key
    KexAlgorithms diffie-hellman-group14-sha1

Target web
    DistPath ./dist
    RemotePath /var/www/app
    EnvPath .env.production
    PreUploadCommand sudo systemctl stop app || true
    RestartCommand sudo systemctl start app

Target api
    DistPath ./api/dist
    RemotePath /srv/api
    EnvPath .env.api
    RestartCommand pm2 restart api

~/.ssh/dbconfig - Database Connections

Automatically saved in your SSH directory:

# Builder Database Configuration

Database dev-postgres
    Type postgres
    Host localhost
    Port 5432
    User postgres
    Password secret
    Database myapp_dev

Database prod-mysql
    Type mysql
    Host 192.168.1.100
    Port 3306
    User admin
    Password secure_password
    Database myapp_prod

Database dev-mongo
    Type mongodb
    Host localhost
    Port 27017
    Database myapp_dev

Commands

Getting Started

1. Create Configuration File

Create a .config file in your project root with deployment targets and SSH host details.

2. Configure Databases (Optional)

Run any database command to trigger connection setup, or manually create ~/.ssh/dbconfig.

3. Open Builder Panel

Press Cmd/Ctrl + Shift + P and search for "Builder" to find available commands.

4. Deploy

Click "Deploy" button and watch the real-time progress through all 11 stages of the deployment pipeline.

Features in Detail

Docker Support

When deploying from macOS or Windows:

• Extension automatically detects non-Linux OS
• Checks for Docker installation
• Auto-installs Docker if missing (via Homebrew on macOS, standard installer on Windows)
• Launches Ubuntu 22.04 container
• Runs entire build & deploy pipeline inside container
• All artifacts compiled in isolated environment
• Automatic cleanup after deployment

Progress Tracking

Each deployment goes through 11 tracked stages:

1. Detect Env - Analyze system environment
2. Check Docker - Verify Docker availability
3. Install Docker - Auto-install if needed
4. Setup Docker Image - Initialize container
5. Increment Version - Update package versions
6. Build Local/Docker - Compile project
7. Upload - Transfer files to server
8. Execute Remote - Run pre/post-upload commands
9. Restart - Restart services
10. Complete - Deployment finished

Each stage shows:

• ⏳ Pending, ⟳ In-progress, ✓ Completed, ✕ Error status
• Step counter (e.g., 5/11)
• Real-time messages and error details
• Execution duration

System Requirements

• VS Code 1.85+
• Node.js 18+ (for local builds)
• Docker (auto-installed if needed for non-Linux systems)
• SSH access to target servers
• Database client libraries (auto-loaded per database type)

Settings

Configure via VS Code settings (settings.json):

{
  "builder.autocompleteCommands": [
    "npm run dev",
    "npm test",
    "git status"
  ],
  "builder.macros": {
    "ins node": "curl -fsSL https://deb.nodesource.com/setup_lts.x | sudo -E bash - && sudo apt-get install -y nodejs",
    "ins docker": "curl -fsSL https://get.docker.com | sh",
    "ins nginx": "sudo apt-get update && sudo apt-get install -y nginx"
  }
}

License

MIT

Support

For issues, feature requests, or contributions, visit the GitHub repository.