dSql: Free Universal Command Line Client

  • Do you work with multiple different databases in the same time (MySql, Postgres, SqlServer...)?
  • Would you like to manage multiple databases with a single client?

dSql can manage and query multiple databases in the same time, transfer the data between databases, deliver result files, automate tasks and easy monitor disk usage or replication status over database clusters.

Download dSql dSql Documentation
dSql Universal Database Command Line Client

SQL Client for Database Clusters

Execute Queries on Multiple Databases

Connect and execute queries on multiple databases simultaneously. Databases can be from different type (PostgreSql, MySql, SqlServer, Redshift, etc. ). You may use this when you have the same table distributed over multiple databases. For monitoring reasons (like disk usage, CPU load) you may also connect and execute one query over multiple databases.

Read More

Transfer Data Between Databases

dSql can transfer data between different databases. You can transfer data from table to table, from a query to table or from multiple databases to one database. The transfer is fast thanks to using multiple threads.

Read More

Python or Groovy Scripts

SQL scripts may be sometime not enough. You may want to place more logic in your script. Therefore you can create more complex scripts that combine the power of SQL and Python or Groovy language. Scripts can be copied directly in the command line or saved to a file and then executed.

Read More

Implement custom commands

dSql supports Python or Groovy Scripts. This scripts can accept parameters. You can register any of the scripts as dSql native commands. Like this you can have database specific command line commands for 'disk usage', 'replication status', 'traffic overview', etc.

Read More

Schedule Database Scripts

dSql can execute Groovy or Python scripts which can query or modify the data in the database. This scripts can be executed regularly on a scheduled base, similar with cronscript. The scripts can upload result files to ftp servers or send them via email. If the script fails an email will be sent to the DbAdmins, informing about the error.

Read More

Script Error Reporting

Database administrators runs periodically reports which delivers data to end-users, like sales people, managers, developers. This scripts can be set to run on a schedule. It may happen that one of the scripts crashes, as for example the database is down or a table is missing. In this case dSql can be instructed to send an email to database administrators and inform about the script crash.

Read More

Deliver Data to End-User

dSql can execute queries on one or multiple databases. It can also execute Python or Groovy scripts which saves result data to file. The files can be delivered to end-users via ftp or as email attachment.

Read More

Monitor Database Clusters

You can write Python or Groovy scripts which does monitor different database aspects, like disk usage, locking, CPU usage, number of connections, etc. This scripts can be register as native dSql commands. Then you can connect to multiple databases (connect to a group) and let this scrips run on all databases. This will reduce the administrative effort to manage a cluster of databases.

Read More

Keep Passwords Save

Postgres users are used to save passwords in a dedicated .pgpass file. dSql can make use of the .pgpass convention and read the passwords from the .pgpass file.

Read More

Easy Manage Database Replicas

Database admin usually creates a standby database replica for each production database. We had clients managing over 40+ production databases, each with a standby replica. dSql allows to easy add suffixes to database connections, and for example prod1 to have a prod1.sby connection where the host naming is changed using a given rule.

Read More

Download dSql

64 bits installer with build-in openJDK 12. No requirements.

Installer

Alternative ZIP Package (not for SqlServer databases).

Checksoums are here. Changelog can be found here.

64 bits installer with build-in openJDK 12. No requirements.
Ubuntu users can download the installer and execute chmod +x dsql.sh and ./dsql.sh in terminal.

Installer for all Linux/Unix systems with Java Installer for all Linux/Unix systems WITHOUT Java

Debian Package WITHOUT Java RPM Package with Java GZIP Package WITHOUT Java.

Checksums are here. Changelog can be found here.

64 bits installer with build-in openJDK 12. No requirements.

For advanced users we provide a Zip Package with Java.

Checksoums are here. Changelog can be found here.