> ## Documentation Index
> Fetch the complete documentation index at: https://hoopdev-update-to-meta-tags.mintlify.site/llms.txt
> Use this file to discover all available pages before exploring further.

# MSSQL

Connecting to Microsoft SQL Server can be done natively using an IDE or any supported client library. Alternatively, you can use the [sqlcmd command line utility](https://learn.microsoft.com/en-us/sql/tools/sqlcmd/sqlcmd-utility) for one-off executions.

## Prerequisites

To get the most out of this guide, you will need to:

* Either [create an account in our managed instance](https://use.hoop.dev) or [deploy your own hoop.dev instance](/getting-started/installation/overview)
* You must be your account administrator to perform the following commands

## Features

The table below explains which features are available for this kind of connection.

* **Native** - This refers to when a database client connects through a specific protocol, such as an IDE or client libraries through `hoop connect <connection-name>`.
* **One Off -** This term refers to accessing this connection from hoop web panel.

| Feature                    | Native                | One Off               | Description                                                                                                             |
| -------------------------- | --------------------- | --------------------- | ----------------------------------------------------------------------------------------------------------------------- |
| TLS Termination Proxy      | <Icon icon="check" /> | <Icon icon="check" /> | The local proxy terminates the connection with TLS, enabling the connection with the remote server to be TLS encrypted. |
| Audit                      | <Icon icon="check" /> | <Icon icon="check" /> | The gateway store and audit the queries being issued by the client                                                      |
| Data Masking (Google DLP)  | <Icon icon="xmark" /> | <Icon icon="check" /> | A policy can be enabled to mask sensitive fields dynamically when performing queries in the database.                   |
| Data Masking (MS Presidio) | <Icon icon="xmark" /> | <Icon icon="check" /> | A policy can be enabled to mask sensitive fields dynamically when performing queries in the database.                   |
| Credentials Offload        | <Icon icon="check" /> | <Icon icon="check" /> | The user authenticates via SSO instead of using database credentials.                                                   |
| Interactive Access         | <Icon icon="check" /> | <Icon icon="check" /> | Interactive access is available when using an IDE or connecting via a terminal to perform analysis exploration.         |

## Configuration

| Name     | Type    | Required | Description                                                                                                                                                                                                            |
| -------- | ------- | -------- | ---------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------- |
| HOST     | env-var | yes      | The IP or Host of the SQL Server                                                                                                                                                                                       |
| PORT     | env-var | yes      | The port of the SQL server                                                                                                                                                                                             |
| USER     | env-var | yes      | The user with access to the instance                                                                                                                                                                                   |
| PASS     | env-var | yes      | The password with access to the instance                                                                                                                                                                               |
| DB       | env-var | yes      | The name of the database to connect (Required when using the connection via the command line).                                                                                                                         |
| INSECURE | env-var | no       | If the connection will ignore the chain of certificates presented by the server. (the connection will be subject to man-in-the-middle attacks if the network is not reliable. By default, this option is set to false) |

## Connection Setup

Create a new Database connection in hoop's web panel.

<Frame>
  <img src="https://mintlify.s3.us-west-1.amazonaws.com/hoopdev-update-to-meta-tags/images/quickstarts/create-database-connection-screenshot.png" alt="create tcp connection screenshot" />
</Frame>

## Connection Usage

### CLI

```bash
hoop connect <connection-name>

connection: mssql | session: 5531dc59-febc-4eee-af26-96e0e0de6769

---------------------mssql-credentials----------------------
      host=127.0.0.1 port=1444 user=noop password=noop
------------------------------------------------------------
ready to accept connections!
```

### Web panel

<Frame>
  <img src="https://mintlify.s3.us-west-1.amazonaws.com/hoopdev-update-to-meta-tags/images/quickstarts/client-pg.png" alt="create tcp connection screenshot" />
</Frame>