dimedrol/sqlline repository overview

⁠Dockerized Sqlline v.1.9.0 with MSSQL JDBC driver v.8.2.2

This is Dockerized version of Sqlline commandline tool with built in MSSQL JDBC driver.

Sqlline⁠ is a command-line utility for running SQL statements against relational databases via JDBC connection.

This image consists of:

• Base image: adoptopenjdk/openjdk11:jdk-11.0.3_7-slim
• SQLLine version: 1.9.0
• JDBC driver version: 8.2.2.jre11

⁠Usage

Let's execute SQL queries from queries.sql file, located in the current directory:

docker run --rm  -v $(pwd):/r dimedrol/sqlline:latest -u "jdbc:sqlserver://mssqlserver.example.com:1433;databaseName=mydatabase" -n "mydbuser@mssqlserver" -p "billy26lifespan93Haas" -f /r/queries.sql

• /r path used just to make command shorter
• Sample command above was tested on Azure MSSQL database service, so actual database login looks like login@servername

dimedrol/sqlline:latest