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.

DbSchemaCLI can be used with all databases used by DbSchema, including MySql, MariaDB, Sqlite, Snowflake, Redshift, Oracle, PostgreSQL, SqlServer, Db2, Google Big Query and Cloud Spanner, Informix, Hive, Salesforce, Firebird and more.

DbSchemaCLI is part of the DbSchema installation kit.

Supports all databases

Download

DbSchemaCLI is part of the DbSchema installation kit. After install DbSchema, start the executable DbSchemaCLI.

Download DbSchema

One Command-Line Client for All Databases

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

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

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

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

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