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 textsqlcmd -b -r -S$SERVER_ADDRESS -U$USER -P$PASS -d$DB
How to Use
Start an interactive session with sqlcmd client
plain texthoop connect mssql
In the same connection, one-off process can be run as well
plain texthoop exec mssql <<EOF SELECT @@VERSION GO EOF
plain texthoop 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