Open Source Java Command Line Tools

jdbc2csv is a small command-line tool written in JAVA and can be used on all platforms, for which JRE 8 or higher is available. To connect to a specific DBMS the tool uses its JDBC driver. The result of the executed 'select' query is displayed in CSV format ( different standards are supported ). When there is an error the tool stops with exit code 1 and the error message is output on stderr. jdbc2csv is created with a main purpose to be used in shell-scripts. Relatively easy to configurate, this tool is suitable for queries ‘select’, ‘update’ and ‘delete’. I think that is not suitable for a large number of requests, like 'insert'.

CRGREP searches for matching text in databases, various document formats, archives and other difficult to access resources. A command line tool for name and content text matching in database tables, plain files, MS Office documents, PDF, archives, MP3 audio, image meta-data, scanned documents, maven dependencies and web resources. CRGREP will search resources within resources of any arbitrary combination or depth, so text within a document within a zip archive, and so on. Here you will find binary downloads and discussion (https://sourceforge.net/p/crgrep/discussion/) . The actual development and issue tracking can be found here: https://bitbucket.org/cryanfuse/crgrep

Jisql is a Java based utility to provide a command line interactive session with a SQL server. It can connect to any database with a JDBC driver.

Jdbsee CLI supports running SQL queries from command line in batch or interactive mode. Database connection settings and related credentials can be persisted for later reuse. The JDBC drivers can be automatically downloaded from maven central repo or loaded from local jars. For more info see https://github.com/davidecavestro/jdbsee/blob/master/docs/index.adoc.

Java command line tool for calculating the complexity of a database model using the Small Worlds Data Transformation Measure.

A command line tool to generate report output from JasperReports report definition files (.jrxml files) such as those generated by iReport, by running them against a live database. Output PDF/HTML is written to disk and can optionally be emailed.