ZappyShell command line tools
Automate AWS, Azure, Redshift, and database export in one line.
ZappyShell is a collection of fast, compact CLI tools for the jobs that usually take too long: bulk export from relational sources, file sync with Amazon S3 and Azure Blob, and on-premises loads into Amazon Redshift.
- Fully functional 30-day trial
- Runs on your machine
- Command Line Builder UI included
Teams already running ZappySys
The CLI family
Four prompts. One download.
Pick the executable that matches the job. Each shell is documented, option-rich, and built to run from a scheduler, a script, or the Command Line Builder UI.
ZappyShell for DB · 4 commands
Export relational data without a round-trip through Excel.
Write JSON, XML, CSV, Excel, PDF, or HTML from SQL Server, Oracle, MySQL, and other ODBC / OLEDB / ADO.net sources. Split by row count, file size, or a group-by column. Nested JSON/XML via the layout editor.
C:\zappyshell> db.exe db export Customers -o c:\data\customers.json --gzip -y
# Simple mode, custom JSON / XML layout, or split by Country
- Four commands:
export,setauth,lsauth,loadauth - Multiple tables or a SQL query in one builder session
- Append, gzip, and pattern export (for example
CUS%)
ZappyShell for AWS · 20+ S3 commands
Treat Amazon S3 like a local folder, with threads and patterns.
Must-have utility for Amazon S3: 20+ commands with 100+ options. Most operations are multi-threaded and support pattern search, so you can sync a local machine with S3 without writing SDK code.
C:\zappyshell> aws.exe s3 put
C:\zappyshell> aws.exe s3 get
# Also ls, lsb, copy, move, ren, del, mkbkt, setacl…
- Upload, download, list, copy, move, rename, and delete objects or buckets
- List commands can export to JSON, XML, or CSV
- Standard adds
--sync,--thread,--struct, and files larger than 100MB
ZappyShell for Azure · 25+ Blob commands
The same operational vocabulary, mapped to Azure Blob Storage.
25+ commands with 100+ options. Multi-threaded operations, pattern search, and folder sync, including snapshots, SAS URLs, and server-side copy (even from a public S3 URL).
C:\zappyshell> azure.exe blob put
C:\zappyshell> azure.exe blob get
# snap · getsas · lscopy · killcopy · copy from a public URL
- Create containers, blobs, and folders; assign container permissions
- Snapshot blobs, monitor
lscopy, orkillcopya server-side job getsas(shared access signature URLs) is Standard edition
ZappyShell for Redshift · 3 commands
Move large on-premises extracts into Amazon Redshift in one command.
Import huge volumes from MySQL, Oracle, or SQL Server, or load local flat files, with optional gzip to speed the transfer. Archive, error reporting, and file splitting are part of the same flow. You can also export Redshift data to CSV, JSON, Excel, PDF, or HTML, and run SQL with sqlexec.
C:\zappyshell> aws.exe redshift import
# Also: aws.exe redshift export · aws.exe redshift sqlexec
- Three commands:
import,export,sqlexec - Load local flat files, including compressed
*.gz - Extract with a SQL query over ODBC, ADO.net, or OLEDB
The runbook
Four jobs teams actually schedule
If you can describe the task in one sentence, ZappyShell is built to run it in one command, then drop that line into Task Scheduler, SQL Agent, or any process host.
-
db.exe
Nightly database dump
Export one table, many tables, or a SQL query to JSON, CSV, XML, or Excel. Timestamp the file. Compress to gzip. Split by country so downstream tools get bite-sized files.
Outcome: files ready for the next system before morning.
export "customers|orders" -o c:\data\ --gzip -y
-
aws.exe
Keep a folder honest with Amazon S3
Upload, download, copy, move, and list with export to JSON, XML, or CSV. Standard adds
--sync(modified files only),--thread, and nested--struct.Outcome: cloud storage that matches the local tree.
put · get · ls · copy · move · del · mkbkt
-
azure.exe
Sync a folder with Azure Blob Storage
Twenty-five-plus commands for blobs and containers, including snapshots and server-side copy from a public URL. Standard generates SAS URLs with
getsas.Outcome: containers that stay in lockstep with ops.
put · get · ls · copy · snap · getsas
-
redshift
Land warehouse data in Amazon Redshift
Pull from a relational source with a SQL query, optionally gzip, then import. Archive, error reporting, and file splitting are included. The same family also
exports Redshift data and runs SQL withsqlexec.Outcome: warehouse tables filled in one pass.
aws.exe redshift import
Command Line Builder
Point-and-click the flags. Keep the one-liner.
You do not have to memorize 100+ options. The Builder walks source tables, target format, gzip / append / split, and custom JSON/XML layout, then emits the command you run in a script or scheduler.
- Point at the sourceODBC, OLEDB, or ADO.net. Tables, a SQL query, or a MAP file.
- Set the outputJSON, XML, CSV, Excel, PDF, or HTML. Gzip, append, split, nested layout.
- Copy and scheduleSame compact tools run the export, the S3 sync, or the Redshift load.
Command atlas
Jump to the help topic, not a 40-row table
Every name below is a real command from the current ZappyShell help. Gold chips are Standard-only.
Data export
Relational export to CSV, JSON, Excel, PDF, XML, and HTML. Standard unlocks splits beyond 25 files, files bigger than 100MB, and multi-threaded operations.
Azure Blob Storage
Upload/download, list, copy/move, snapshots, SAS, and server-side copy, including from a public URL or an S3 shared URL.
- get
- put
- ls
- lsc
- lscopy
- copy
- move
- ren
- del
- delcon
- info
- continfo
- mkcon
- mkfile
- mkfol
- setacl
- snap
- getsas
- killcopy
- setprop
- cd
- setauth
- loadauth
- lsauth
- setopt
getsas is Standard only. See all Azure commands.
Amazon S3 and Redshift
S3 storage commands plus Redshift import, export, and sqlexec. List commands can export to JSON, XML, or CSV.
Licenses
Perpetual licenses
ZappyShell is sold as a perpetual (lifetime) key, per machine. One year of support and upgrades is included. Standard Edition is all four tools; the other SKUs are single-product licenses. Annual SKUs on the purchase page are support renewal, not a new product subscription.
Standard Edition
$599
All 4 tools: DB, Azure, AWS S3, and Redshift
ZAPPYSHELL-STD
For Azure
$299
Azure Blob tools only
ZAPPYSHELL-AZURE
For AWS (S3, Redshift)
$499
AWS S3 and Redshift tools only
ZAPPYSHELL-AWS
For DB
$399
Database export tools only
ZAPPYSHELL-DB
In the ZappySys family
CLI when the job is a script. SSIS or ODBC when it is not.
Same self-hosted model. Different runtime. Pick the surface your team already lives in.
ZappyShell
Ops and automation from the command line: export, cloud sync, and Redshift load, without standing up an SSIS package.
You are on this page.
SSIS PowerPack
Drag-and-drop tasks and components inside SQL Server Integration Services when ETL already lives in Visual Studio.
ODBC PowerPack
Query REST APIs, files, and cloud sources from Power BI, Excel, SQL Server, and other ODBC clients.
FAQ
Straight answers before you install
Product
What is ZappyShell?
ZappyShell is a collection of fast, compact Windows command line tools that automate difficult or time-consuming tasks in one line: Amazon S3, Amazon Redshift, Azure Blob Storage, and relational export to JSON, XML, CSV, Excel, PDF, and HTML.
Do I have to type every option by hand?
No. The Command Line Builder UI configures connections, tables or SQL, output format, layout, gzip, append, and split options, then copies the generated command into a script or job.
Does my data pass through ZappySys servers?
No. ZappyShell is installed software you run locally against your databases and cloud accounts. Your data stays in your environment.
Trial & pricing
Is there a free edition and a trial?
Yes. A Free edition includes the core commands. A fully functional 30-day trial is available from the download page so you can evaluate Standard capabilities against a real folder, table, or bucket.
What do I get only on Standard?
Standard Edition is all four tools in one license: DB, Azure, AWS S3, and Redshift. The other SKUs sell one family at a time (Azure, DB, or AWS).
How is ZappyShell priced?
ZappyShell is sold as a perpetual license, per machine. Standard Edition ($599) includes all four tools: DB, Azure, AWS S3, and Redshift. Single-product SKUs are Azure $299, DB $399, and AWS (S3, Redshift) $499. Each includes one year of support and upgrades. Yearly SKUs on the purchase page are support renewal.
Cloud & warehouse
Can I sync only changed files to S3 or Azure?
Yes, with the --sync option. Combine with --thread for multi-threaded transfers and --struct to keep nested folders.
How do I load SQL Server, MySQL, or Oracle into Redshift?
Use ZappyShell for Redshift import. Extract with a SQL query over ODBC, ADO.net, or OLEDB, or load local (optionally gzipped) files in one command.
Can I copy from S3 to Azure?
Azure server-side copy can pull from any public URL into Azure Blob, including AWS S3 if you generate a shared URL for the S3 file.
Ready when the prompt is
Prove one hard job in 30 days: export, sync, or load.
Install the compact tools, generate a command in the builder, and run it against your own data. Support is available if you get stuck.
- Fully functional 30-day trialRun against your real SQL, S3, Azure, or Redshift job, not a demo key.
- Your data stays in your environmentLocal CLI. Credentials and execution stay under your control.
- Starting from $299Perpetual licenses. Standard is all 4 tools; Azure, DB, and AWS are single-product SKUs.
Talk to an expert
USA-based team, before and after you download
Support is by live chat and email. Reach the same company that builds SSIS PowerPack and ODBC PowerPack.