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

# Integrate MS SQL Tools

This guide walks you through configuring and authenticating the MS SQL tools in Airia, enabling your agents to interact with your Microsoft SQL Server database.

Airia provides the following MS SQL tools:

* **MS SQL Query Tool:** To execute queries against your MS SQL database.
* **MS SQL Metadata Retrieval Tool:** To retrieve schema metadata for your MS SQL database.

Both tools are required for comprehensive interaction with your MS SQL Database.

## Supported MS SQL Versions

Airia currently supports the following versions of MS SQL:

* Azure SQL Database
* Azure Synapse Analytics
* Azure SQL Managed Instance
* SQL Server 2022
* SQL Server 2019
* SQL Server 2017
* SQL Server 2016
* SQL Server 2014

## Prerequisites

To connect Airia to your MS SQL server, you will need the following details:

* **Hostname/Endpoint**
* **Port** (default: `1433`)
* **Database name**
* **Basic Credentials:**
  * **User name**
  * **Password**

> 💡 Note: These details can be retrieved from your MS SQL server. For example, if your server is hosted on Azure, connection details (such as the hostname) can often be found under the **Connection Strings** (specifically the ODBC tab) in the Azure portal. Your password will be server-specific.

<img src="https://mintcdn.com/airia/FyggIi3LbVMjFjoF/integrations/Images/mssql_account.png?fit=max&auto=format&n=FyggIi3LbVMjFjoF&q=85&s=357b02f782bd0f525922891fad80bd97" alt="Retrieve Ms. SQL connection details" width="1670" height="487" data-path="integrations/Images/mssql_account.png" />

## Add and Configure MS SQL Tools

Follow these steps to add and configure each MS SQL tool:

1. **Add an MS SQL Tool:**
   * Navigate to the **Tools** section in your Airia dashboard.
   * From the library, select the MS SQL tool you wish to add (e.g., **MS SQL Query Tool** or **MS SQL Metadata Retrieval Tool**).
2. **Provide Connection Details:**
   * On the tool configuration page, provide the following details:
     * **Hostname/Endpoint:** Your MS SQL server's hostname or IP address.
     * **Port:** The port number your MS SQL server is listening on (default `1433`).
     * **Database name:** The name of the database you want to connect to.
   * For **User name** and **Password**, set them as a **Basic authentication credential**.
3. **Save the Tool:**
   * Click **Save** to add the configured tool to your library.
4. **Repeat for Other Tool:**
   * Repeat steps 1-3 for the **MS SQL Metadata Retrieval Tool**, providing the same connection values.

## Next Steps

Now that your MS SQL tools are added, you can integrate them into an agent to query your MS SQL database.

* [Use MS SQL tools in an Agent](./using-database-tools-in-agents.mdx)

> ⚠️ Warning: Your MS SQL server must be accessible by Public IP. If you encounter connectivity issues, contact [support@airia.com](mailto:support@airia.com). We can provide you with the necessary IP addresses to whitelist on your firewall.