ZappyShell - Command line tools Amazon Redshift, S3, Azure

ZappyShell is a collection of fast and compact command line tools to automate most difficult or time consuming tasks in one line. ZappyShell contains following command line tools at this moment.

DownloadFree 30 days trial

Help FileOnline

BuyStarting from $199

ZappyShell Overview

ZappyShell contains following command line applications

Command line	Description
ZappyShell for DB	Commands to export data from relational source. You can export data in JSON, XML, CSV, Excel, PDF.	Read More
ZappyShell for Redshift	Commands to import on-premises data to Amazon Redshift. You can import huge amount of data to Redshift from any relational database such as MySQL, Oracle, SQL Server in just one line.	Read More
ZappyShell for AWS	Must have command line utility to interact with Amazon S3 Storage. 20+ commands with 100+ options to adjust your need. Most of operations are multi-threaded with pattern search support. Easily sync files between local machine and Amazon S3.	Read More
ZappyShell for Azure	Must have command line utility to interact with Azure Blob Storage. 25+ commands with 100+ options to adjust your need. Most of operations are multi-threaded with pattern search support. Easily sync files between local machine and Azure Storage.	Read More

Screenshots

Export multiple tables to JSON / CSV / XML / Excel File (Simple Mode ) – Command line builder UI

Command Line Builder – Export Data to JSON, XML, CSV, Excel from multiple SQL Tables (ODBC, OLEDB, ADO.net Connection)

Command Line Builder for JSON, XML, CSV, Excel – Target Options (Append, Compress to GZip)

Command Line Builder – Additional Options for Export JSON, XML, CSV, Excel File

Generate Complex JSON / XML using Custom Layout – Command line builder UI

Using Custom Layout for Complex JSON / XML Output

Layout Editor to define Structure of JSON / XML Output

Exported JSON File Output – Generated from ZappyShell db.exe command line (Using Custom Layout File)

Export and Split Files By Row Count / Size – Command line builder UI

Split CSV, JSON, XML, Excel Data into Multiple files (Split by Rowe Count or Size)

ZappyShell Command line tools for Amazon S3

Command line tools for Amazon S3

Upload local files to Amazon S3 from command line

ZappyShell Command line tools for Amazon Redshift

Redshift Data Load – Amazon Redshift Import Command line tools (COPY, S3, AWS Redshift)

Export table or query output to JSON files (automatically split into multiple files)

Export SQL Server Table to JSON files (split automatically using group by column)

Export table or query output to Excel files (automatically split into multiple files)

Export SQL Server Table to Excel files (split automatically using group by column)

DB Shell – Command Line tools for Data export to JSON, CSV, Excel, PDF and HTML

Feature	FREE Edition	Standard Edition
Commands for Data Export [4 commands] Click here to see all commands
Premium support (Phone call, Web meeting)
Advanced options (not available in FREE version): Support for splitting data in more than 25 files Support for files bigger than 100MB Support for multi threaded operations
Data Export commands: export (export relational data to CSV, JSON, Excel, PDF, HTML) setauth (set authentication) lsauth (list saved credentials) loadauth (load saved credentials in current context)

Azure Shell – Command Line Tools (CLI) for Microsoft Azure Cloud Services

Feature	FREE Edition	Standard Edition
Commands for Azure Blob Storage [25 commands] Click here to see all commands
Premium support (Phone call, Web meeting)
Advanced options (not available in FREE version): Upload/Download only modified files (–sync option) Multi threaded operations (–thread option) Transfer entire folder structure (including nested folders/files) (–struct option) Support for files bigger than 100MB
Upload/Download commands: get (download blobs to local machine) put (upload files to azure container)
List commands (with export to json,xml,csv options): ls (List azure storage blobs, including snapshots) lsb (List azure storage containers) lscopy (List copy status of objects being copied using server side copy feature, filter by specific copy status)
Copy/Move/Rename objects: copy (copy azure blobs between containers/folders or accounts) move (move azure blobs between containers/folders or accounts) ren (rename azure blobs)
Delete commands for blobs/containers: del (delete blob(s), blob snapshot(s)) delcon (delete azure storage container(s) including underlying blobs)
Show information commands for blobs/containers (with export to json,xml,csv options): info (detailed information about azure blob(s)) continfo (detailed information about azure blob container(s))
Make/Create commands for blobs/containers: mkcon (create new container in azure storage account) mkfile (create new block/page blob with user defined content. For page blob you may set initial size) mkfol (create new folder)
Grant permission commands: setacl (assign/reset permission for azure blob container)
Snapshot commands: snap (create new snapshot of specified blob(s))
Shared access signature URL commands: getsas (generate shared access signature url(s) for specified blob(s))
Server side copy commands: copy (copy between azure storage accounts or same account different containers/folders) copy (copy from any public url to azure storage account, you can copy from AWS S3 to Azure too if you generate shared url for S3 file) lscopy (list server side copy operation and monitor progress and failures) killcopy (terminate server side copy job(s) by file name)
Misc commands: setprop (set properties for specified blob(s) such as content-type, content-encoding, expiration, metadata) cd (change current cloud directory) setauth (set credential for storage account, makes it easy for you to refer it by short later.) loadauth (load storage account credentials) lsauth (list all saved credential entries)

Aws Shell – Command Line Tools (CLI) for Amazon AWS

Feature	FREE Edition	Standard Edition
Premium support (Phone call, Web meeting)
Advanced options (not available in FREE version): Upload/Download only modified files (–sync option) Multi threaded operations (–thread option) Transfer entire folder structure (including nested folders/files) (–struct option) Support for files bigger than 100MB
Commands for AWS Redshift [1 command] Click here to see all commands
Import data to redshift: import (imports data to AWS Redshift database from any source) Load local flat files to Redshift in one single command (option to compress data files to .gz to speed up transfer) Load data from any data source (ODBC,ADO.net or OLEDB) using sql query to extract data Import compressed data files (.gz) to redshift Archive files, error reporting, file splitting, many other features….
Commands for AWS S3 Storage[25 commands] Click here to see all commands
Upload/Download commands: get (download s3 files to local machine) put (upload files to aws bucket)
List commands (with export to json,xml,csv options): ls (List aws s3 storage files) lsb (List aws s3 buckets)
Copy/Move/Rename objects: copy (copy aws s3 files between buckets/folders) move (move aws s3 files between buckets/folders) ren (rename aws s3 files)
Delete commands for s3 files/buckets: del (delete s3 file(s)) delbkt (delete aws s3 bucket(s))
Show information commands for s3 files/buckets (with export to json,xml,csv options): info (detailed information about aws s3 file(s), such as metadata, permissions, logging information etc.) infobkt (detailed information about aws s3 bucket)
Make/Create commands for s3 file/bucket: mkbkt (create new bucket in aws storage account) mkfile (create new block/page s3 with user defined content. For page s3 you may set initial size) mkfol (create new folder)
Grant permission commands: setacl (assign/reset canned permission and user grants for aws s3 bucket(s) or file(s))
Misc commands: setprop (set properties for specified s3 file(s) such as content-type, content-encoding, expiration, metadata) cd (change current cloud directory) setauth (set credential for storage account, makes it easy for you to refer it by short later.) loadauth (load storage account credentials) lsauth (list all saved credential entries)