🔧 Client Utility Tools
Client Util App
v1.3.3
Essential utility tools for developers and system administrators
Enhanced stability and portability with fixed path resolution
Client Util App
$ client-util --help
Client Util App v1.3.3
Usage: client-util [command] [options]
Commands: db-test, telnet, sql-exec
$ client-util db-test --server localhost
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.3 Critical Bug Fix
Improved stability with release package path resolution fix
- Fixed release package path resolution bug
- Changed from process.cwd() to path.dirname(process.execPath)
- Executable works correctly regardless of execution location
- Properly recognizes config/, request_resources/, results/, log/ directories
- Enhanced portability and stability
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 run.bat file or run from command prompt
run.bat
# Or run the executable directly
client-util-app.exe
# 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.3
- 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