DbSchemaCLI
Free Universal SQL Command-Line Client

DbSchemaCLI command-line client can connect to multiple databases, run queries on multiple databases, transfer data, execute scheduled tasks, monitor databases, and send alert emails, execute SQL reports and send the results over ftp or email. DbSchema is used also to run the Floating License Server.

DbSchemaCLI is part of the standard installation kit, is free, and supports all databases supported by DbSchema.

Download

A Command-Line Client for All Databases

Run Floating License Server

DbSchema Floating License require a Floating License Server, which is running as a command in the DbSchemaCLI. This allows multiple users to share a single license. The number of active users must be equal or lower to the quantity specified in the floating license.
Read More

Connect to Multiple Databases

Use one client to connect to different databases, from different providers (PostgreSQL, MySql, SqlServer, Redshift, etc.). If the same table resides on multiple databases, you can query all of them at the same time. Also, you can monitor multiple databases with a single command (like CPU load, disk usage, locking, or replication).

Read More

Execute Java Groovy Scripts

Certain administrative tasks requires using script logic beside flat SQL queries. DbSchemaCLI can use Java Groovy scripts, an extension to the Java language. The scripts into the console or from a file.
Read More

Transfer Data Between Databases

Transfer the data from one database to another or from multiple databases to a target database. Transfer using chunked queries, parallel-processing and transactional chunks.
Read More

Schedule Database Scripts

Schedule SQL or Java Groovy scripts to run regularly, similar to linux crontab. When the scripts are failing, an email will be sent to the database administrators.
Read More

Deliver Data to End-User

DbSchemaCLI can execute scripts and save the result data to the file. These files can be delivered to end-users via FTP or as an email attachment.
Read More

Script Error Reporting

DbSchemaCLI can execute database reports and deliver data to end-users, like salespeople, managers, developers. If these scripts crash, for example, the database is down, or a table is missing, DbSchemaCLI sends an alert email to database administrators.
Read More

Monitor Databases

You can write Groovy scripts for monitoring databases, like disk usage, locking, CPU usage, number of connections, etc. These scripts can be registered as native DbSchemaCLI commands. Then you can connect to multiple databases (connect to a group) and execute them on all databases. This will help to monitor database clusters using a single command.
Read More

Keep Passwords Safe

DbSchemaCLI can make use of a separate file to save passwords.
Read More

Create New Connections From Exiting Connections

Database connections can be created by modifying existing connections. For example, you can add the suffix '.sby' to each connection, and set a rule to apply on the host or the port. Administrators are using this, for example, when they manage standby databases with a similar configuration as the primary databases.
Read More

Implement Custom Commands

As an example DbSchemaCLI can have disk usage scripts, which can be executed on multiple databases simultaneously. The scripts are Java Groovy scripts, saved to a separate file. The scripts have been registered as a DbSchemaCLI command. Similarly, DbSchemaCLI can implements scripts for measuring the CPU load, database locking, replication status.
Read More