logo

Microsoft SQL Server

SQL commands targeting a SQL Server database instance.
Type: sql-server

Configuration

Name
Required
Description
MSSQL_CONNECTION_URI
yes
The server name which will be used to connect to the SQL instance, format: [protocol:]server[instance_name][,port]
MSSQL_USER
yes
The database username
MSSQL_PASS
yes
The database password
MSSQL_DB
yes
The name of the database instance
FIELD_SEPARATOR
no
Defaults to table output, using other character will suppress spaces

Examples

Connection URI:
  • MSSQL_CONNECTION_URI=tcp:192.168.10.110,1490
  • MSSQL_CONNECTION_URI=192.168.10.110 - defaults to tcp and port 1433