SQL Server | sqlcmd cli

An optional way to connect into SQL Server is using the sqlcmd client. It’s possible to create a interactive session or execute one-off commands.

Connection Configuration

Name	Type	Description
`SERVER_ADDRESS`	env-var	The Server Address of the SQL Server to connect into
`USER`	env-var	The user to connect in the SQL server
`PASS`	env-var	The password to connect in the SQL server
`DB`	env-var	The name of the database to connect into

Connection Command

plain text
sqlcmd -b -r -S$SERVER_ADDRESS -U$USER -P$PASS -d$DB

How to Use

Start an interactive session with sqlcmd client

plain text
hoop connect mssql

In the same connection, one-off process can be run as well

plain text
hoop exec mssql <<EOF
SELECT @@VERSION
GO
EOF

plain text
hoop exec mssql -f /tmp/myquery.sql
hoop exec mssql -i 'SELECT @@VERSION'
# pass arguments to sqlcmd
hoop exec mssql -- -s ";" -h -1 -W <<EOF
SELECT * FROM master.INFORMATION_SCHEMA.SCHEMATA
EOF

Be aware that allowing passing arguments grants capabilities to override flags defined in the connection. E.g.: hoop exec <conn> -- -Uoverrideuser