🔧 Client Utility Tools
Client Util App
v1.3.10
Essential utility tools for developers and system administrators
Multi-language support with English and Korean UI | UTF-8 CSV encoding
Client Util App
$ client-util --help
Client Util App v1.3.10
Usage: client-util [command] [options]
Commands: db-test, telnet, sql-exec
$ node app.js --lang=en
Key Features
Essential utility features for development and operations
Database Connection & Permission Check
Enhanced database connection testing with improved logging and error handling
- Multi-database support (MSSQL, MySQL, MariaDB, PostgreSQL, Oracle)
- Enhanced log output with database-specific separators
- Detailed error message capture for SELECT/INSERT/DELETE operations
- Unified file management with smart filtering
- Safe permission testing using actual tables
Server Telnet Check
Diagnose network issues by checking remote server port connection status
- Port connectivity testing
- Configurable timeout settings
- Multiple port simultaneous checking
- Connection log recording
v1.3.10 CSV-to-DB Improvements
CSV-to-DB functionality improvements
- Removed conservative identity heuristic
- MSSQL: Computed columns are detected and excluded
- Robust header mapping
v1.3.9 New Non-Interactive CLI Feature Added
New Non-Interactive CLI Feature Added
- Directly execute with the --mode flag without a menu item
- Modes: db, telnet, sql, csv, config
- Supports both Node environments and deployment EXEs
v1.3.8 Improved CSV-based batch query execution
Naming conventions and convenience improvements for CSV-based batch query execution
- File naming convention changes: request/'s SQL_ → SQL2CSV_ prefix
- Result path variable: Added support for ${DB_NAME} (selected DB key)
- Menu label and file search logic changes: Only SQL2CSV_*.csv are displayed in the list
- Directory name unification: request_resources → request
v1.3.7 CSV Query Result Output Improvements (NEW)
Enhanced newline handling for procedure definitions and multi-line text in CSV format
- Replaces all newlines with spaces for single-line storage
- Quotes values only when they contain commas/quotes in CSV files
- Procedure definitions now save cleanly in a single line
- Easy to read in Excel or text editors
- Better CSV standard compliance
v1.3.6+ CSV-based Batch Query Execution
Execute multiple SQL queries from a CSV file in batch with security features
- Execute multiple queries from
SQL2CSV_*.csvfiles inrequest/ - Date/time variables in file paths: ${DATE:yyyyMMddHHmmss}
- Result path variable:
${DB_NAME}supported (selected DB key) - Automatic directory creation for output files
- Query validation: Only SELECT and safe system procedures allowed
- Blocked: INSERT, UPDATE, DELETE, DROP, TRUNCATE, ALTER, CREATE
v1.3.4 Multi-language Support
Full English and Korean UI support with language selection
- Language selection via --lang parameter (en/kr)
- Dual launcher scripts: run.bat (English) / 실행하기.bat (Korean)
- Over 60 translated messages for seamless experience
- UTF-8 CSV encoding required for proper Korean character display
- Automatic version reading from package.json
Database SQL Execution
Execute parameterized SQL queries with multiple conditions and save CSV results
- Multi-condition execution with CSV/JSON parameter files
- Automatic DB selection with #DATABASE directive
- Structured CSV result file generation
- Clear separation of results by condition
- Automatic recording of execution time and metadata
Technical Specifications
Detailed technical information about Client Util App
Development Environment
Language
Node.js
Runtime
v16.0+
Package Manager
npm/yarn
CLI Framework
Commander.js
Database
Supported DBs
MSSQL, MySQL, MariaDB, PostgreSQL, Oracle
Permission Check
SELECT, INSERT, DELETE
Error Capture
Up to 500 chars
Log Output
DB-specific separators
Network
Protocol
TCP/IP
Timeout
Configurable
Retry
Automatic
Logging
File/Console
Performance
Memory Usage
~50MB
Response Time
<1sec
Concurrent Connections
10
Platform
Cross-platform
Usage Examples
Explore various ways to use Client Util App
Windows Batch
# Double-click launcher file or run from command prompt
# English UI:
run.bat
# Korean UI (한국어):
실행하기.bat
# Or specify language directly:
node app.js --lang=en
node app.js --lang=kr
# After execution, select menu:
========================================
Node.js Integrated Utility Tool
========================================
📋 Main Menu
1. Database Connection and Permission Check
2. Server Telnet Connection Check
3. Database SQL Execution
4. Configuration Management
5. Run All Checks (Batch Processing)
6. Exit
Select option (1-6): 1
# Select CSV file:
📁 Available CSV files:
1. DB_sample.csv
2. server_sample.csv
Select CSV file to use (1-2): 1
# Runs automatically and saves results to results/ folder
CLI
# Basic connection test
client-util db-test --server localhost --database master
# With detailed options
client-util db-test \
--server 192.168.1.100 \
--port 1433 \
--database MyDatabase \
--username sa \
--timeout 30
# Using connection string
client-util db-test \
--connection-string "Server=localhost;Database=master;Trusted_Connection=true;"
CLI
# Single port check
client-util telnet --host localhost --port 1433
# Multiple port check
client-util telnet \
--host 192.168.1.100 \
--ports 80,443,1433,3306 \
--timeout 5000
# Save results to file
client-util telnet \
--host example.com \
--port 80 \
--output telnet-result.log
CLI
# Execute query directly
client-util sql-exec \
--server localhost \
--database MyDatabase \
--query "SELECT TOP 10 * FROM Users"
# Execute query from file
client-util sql-exec \
--server localhost \
--database MyDatabase \
--file queries.sql
# Output results to CSV
client-util sql-exec \
--server localhost \
--database MyDatabase \
--query "SELECT * FROM Products" \
--format csv \
--output products.csvDocumentation
Detailed documentation for using Client Util App
Changelog
Version history and feature updates - Latest: v1.3.10
- v1.3.10: Non-interactive CLI improvements (errors/exit codes), CSV batch path/logging enhancements, small fixes
- v1.3.9: Added non-interactive CLI via
--mode(db/telnet/sql/csv/config), manuals updated - v1.3.8: Switched to SQL2CSV prefix, added ${DB_NAME} variable, message refactor
- v1.3.4: Multi-language support (English/Korean), UTF-8 CSV encoding, dual launchers
- v1.3.3: Fixed release package path resolution bug
- v1.3.0: SQL Executor improvements, CSV result files, MariaDB support, JSON parameters
- v1.2.0: Enhanced logging, detailed error capture, streamlined file management
- v1.1.0: Safe permission checking, actual table testing
- v1.0.0: Initial release with core features
Contact Us
Feel free to contact us with any questions about Client Util App
Contact Information
Email
happysoftinfodesk@gmail.com
happysoftinfodesk@gmail.com
Website
happysoft2018.com
happysoft2018.com