Operations, limitations, and architectural overview (v2.0.0).
Video Tutorials
Core Workflow: Connect & Execute
Watch how to add a server, select databases from the tree, and run a package of scripts in order.
Safely Test with Dry-Run
See how Dry-Run simulates execution using transaction rollbacks to prevent accidental changes.
Parallel vs Sequential
Compare the massive time savings when executing the same script using the Parallel Engine.
The Core Concept
SQLSkrypter is built on a simple yet powerful idea: define your server fleet once, and execute across everything in seconds.
Connect & Discover: Add servers with credentials. One click fetches all databases from all selected nodes.
Safety First: The database discovery query is restricted to a simple SELECT to prevent accidental sabotage during exploration.
Fleet Management
Manage hundreds of databases across different stages efficiently.
Environments: Categorize servers into environments (PROD, DEV, STAGING) for better visual control and safety.
Tree Sessions: Save your current tree state (checked databases) to a file. Load it instantly without re-querying the servers.
Execution & Monitoring
Real-time visual feedback for every operation across your fleet.
Visual Status: Databases turn GREEN on success and RED on error. Status counters show precisely how many scripts succeeded per node.
Interactive Timeline: Every connection and execution is logged with timing. Filter and export your results to CSV/TXT files.
Performance & Logic
Optimized for speed and complex SQL batches.
Parallel Execution: Run up to 8 concurrent threads for massive time gains, or stay Sequential for strict dependency control.
Advanced Support: Full support for 'GO' batches and PRO Dry-Run simulations to test scripts without making permanent changes.
Enterprise-Grade Security
Your credentials and server lists never leave your machine.
Local Encryption: All sensitive configuration data is protected using AES-256 and Windows DPAPI.
Portable Configs: Export your setup to an encrypted file with a custom password (PBKDF2) for safe transfer between workstations.
Note: SQLSkrypter is a 'Fast Runner' focused on orchestration. It does not display data output (SELECT results), focusing on execution status and performance.