Open Source 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'.

dbf is an easy-to-use command line tool to show and convert the content of dBASE III, IV, and 5.0 files. It reads dBASE databases and prints the content to the screen or converts it to comma-separated (*.csv) files which can be opened in Excel, Calc.

Small command line tool to directly execute SQL statements against any OleDB database. Can also execute a sql batch file. Handy for automation purposes e.g. for MS Access databases.

This tool provides User Interface for command-line tool SqlMetal which can generate code and mapping for the LINQ to SQL component of the .NET Framework.

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.

Z-SQL is a package-oriented SQL language designed for Microsoft SQL Server. Full language specification is provided. The compiler translates Z-SQL to SQL Server's native T-SQL. A command line tool, zsql, that superseeds osql is also included.

DataBaseMerge is a command line tool, that merges database structures.

PgWorksheet is a simple GUI frontend to PostgreSQL for executing SQL queries and psql commands without using the psql command line tool. Please see the project home page for bug reports, forums and installation instructions.

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.