> ## Documentation Index
> Fetch the complete documentation index at: https://docs.varios-ai.com/llms.txt
> Use this file to discover all available pages before exploring further.

# MSSQL

> The MSSQL connector enables connection to Microsoft SQL Server databases and the execution of SQL queries. With this connector, you can retrieve and analyze data from your SQL Server databases.

## Options

<ParamField body="host" type="string" required>
  The hostname or IP address of the MSSQL server.
</ParamField>

<ParamField body="port" type="string" required>
  The port of the MSSQL server.
</ParamField>

<ParamField body="username" type="string" required>
  The username for authentication.
</ParamField>

<ParamField body="password" type="string" required>
  The password for authentication.
</ParamField>

<ParamField body="database" type="string" required>
  The name of the database.
</ParamField>

<ParamField body="query" type="string" required>
  The SQL statement to be executed. Placeholders for parameters: ?1
  to ?10
</ParamField>

## Arguments

<ParamField body="argument1" type="string" required>
  Value for the first parameter in the SQL statement.
</ParamField>

<ParamField body="argument2" type="string">
  Value for the second parameter in the SQL statement.
</ParamField>

<ParamField body="argument3" type="string">
  Value for the third parameter in the SQL statement.
</ParamField>

<ParamField body="argument4" type="string">
  Value for the fourth parameter in the SQL statement.
</ParamField>

<ParamField body="argument5" type="string">
  Value for the fifth parameter in the SQL statement.
</ParamField>

<ParamField body="argument6" type="string">
  Value for the sixth parameter in the SQL statement.
</ParamField>

<ParamField body="argument7" type="string">
  Value for the seventh parameter in the SQL statement.
</ParamField>

<ParamField body="argument8" type="string">
  Value for the eighth parameter in the SQL statement.
</ParamField>

<ParamField body="argument9" type="string">
  Value for the ninth parameter in the SQL statement.
</ParamField>

<ParamField body="argument10" type="string">
  Value for the tenth parameter in the SQL statement.
</ParamField>

Example for the arguments:

```
argument1: Searchterm for XYZ
argument2: Start date. Format: `yyyy-mm-dd` / Example: `2025-04-01`
```