Skip to main content

Microsoft SQL Server

SQL commands targeting a SQL Server database instance.

Type: mssql

Configuration#

NameRequiredDescription
MSSQL_CONNECTION_URIyesThe server name which will be used to connect to the SQL instance, format: [protocol:]server[instance_name][,port]
MSSQL_USERyesThe database username
MSSQL_PASSyesThe database password
MSSQL_DByesThe name of the database instance
FIELD_SEPARATORnoDefaults 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