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

# Microsoft SQL Server

> A relational database management system developed by Microsoft, offering comprehensive data management and business intelligence capabilities.

<ConnectionTemplate
  config={{
"id": "mssql",
"name": "Microsoft SQL Server",
"description": "A relational database management system developed by Microsoft, offering comprehensive data management and business intelligence capabilities.",
"category": "databases",
"icon-name": "mssql",
"tags": [
"database",
"sql"
],
"features": {
"tlsTerminationProxy": {
  "native": true,
  "oneOff": true
},
"audit": {
  "native": true,
  "oneOff": true
},
"dataMaskingGoogleDLP": {
  "native": false,
  "oneOff": true
},
"dataMaskingMSPresidio": {
  "native": false,
  "oneOff": true
},
"guardrails": {
  "native": false,
  "oneOff": true
},
"credentialsOffload": {
  "native": true,
  "oneOff": true
},
"interactiveAccess": {
  "native": true,
  "oneOff": true
}
},
"overview": {
"description": "Connect to your SQL Server databases through Hoop.dev with enterprise-grade security, automated compliance logging, and real-time data protection. Execute T-SQL queries with advanced access controls and intelligent masking of sensitive business data."
},
"setupGuide": {
"accessMethods": {
  "webapp": true,
  "cli": true,
  "runbooks": true
}
},
"resourceConfiguration": {
"type": "database",
"subtype": "mssql",
"credentials": [
  {
    "name": "HOST",
    "type": "env-var",
    "required": true,
    "description": "The IP or Host of the SQL Server",
    "placeholder": "localhost"
  },
  {
    "name": "USER",
    "type": "env-var",
    "required": true,
    "description": "The user with access to the instance",
    "placeholder": "sa"
  },
  {
    "name": "PASS",
    "type": "env-var",
    "required": true,
    "description": "The password with access to the instance",
    "placeholder": "password"
  },
  {
    "name": "PORT",
    "type": "env-var",
    "required": true,
    "description": "The port of the SQL server",
    "placeholder": "1433"
  },
  {
    "name": "DB",
    "type": "env-var",
    "required": true,
    "description": "The name of the database to connect (Required when using the connection via the command line).",
    "placeholder": "mydb"
  },
  {
    "name": "INSECURE",
    "type": "env-var",
    "required": false,
    "description": "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.",
    "placeholder": "false"
  }
]
},
"documentationConfig": {
"path": "quickstart/databases/mssql"
}
}}
/>