When you run SQL-DK for the first time the template config file in ~/.sql-dk/config.xml will emerge.


The only thing you have to configure are database connections. Just add or uncomment section like one of these:



Aditional properties for JDBC driver of particular database can be configured by adding:

<property name="propertyName">propertyValue</property>

Or specified ad-hoc on command line:

$ sql-dk --db-property "propertyName" "propertyValue"

See also --db-property and --list-jdbc-properties in usage documentation.

Supported DBMS

SQL-DK supports any database system for which JDBC driver exists. This drivers (.jar files) must be on class path. Class path for PostgreSQL and MySQL drivers is preconfigured – just install recommended packages ( libpostgresql-jdbc-java libmysql-java ) and you should be able to connect.

You can also plug-in custom JDBC drivers for other DBMS. Just add an array variable into your ~/.sql-dk/



You can configure the default formatter:


Or define your own formatters:


Formatters can be parametrized in same way as databases:

<property name="propertyName">propertyValue</property>

E.g. to enable long value trimming in tabular formatter:

$ sql-dk --formatter-property "trim" "true"

SQL-DK, free software © 2013-2020 GlobalCode