dSql: Free Universal Command Line Client

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

dSql can manage and query multiple databases at the same time, transfer the data between databases, deliver result files, automate tasks, and easily 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 types (PostgreSQL, MySql, SqlServer, Redshift, etc. ). You may use this when you have the same table distributed over multiple databases. For monitoring reasons (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 a 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 maybe sometimes 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. These 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 that can query or modify the data in the database. These scripts can be executed regularly on a scheduled base, similar to cronscript. The scripts can upload result files to FTP servers or send them via email. If the script will fail an email will be sent to the DbAdmins, informing about the error.

Read More

Script Error Reporting

Database administrators run periodically reports which deliver data to end-users, like salespeople, managers, developers. These scripts can be set to run on a schedule. It may happen that one of the scripts crashes, 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 that save result data to file. The files can be delivered to end-users via FTP or as an email attachment.

Read More

Monitor Database Clusters

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

Read More

Keep Passwords Safe

Postgres users are used to saving 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 us to easily 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-bit 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-bit 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-bit installer with build-in OpenJDK 12. No requirements.

For advanced users we provide a Zip Package with Java.

Checksums are here. Change-log can be found here.