MSSQL Connector FAQs

Question 1

What authentication methods are supported for SQL Server connections?

Accepted Answer

The MSSQL Connector supports authentication via traditional SQL Server credentials (username and password) or Azure Active Directory (Azure AD) using OpenID Connect (OIDC) for enhanced security and integration with cloud environments.

Question 2

Can AI agents perform write operations using this connector?

Accepted Answer

Yes, if the 'READONLY' environment variable is set to 'false'. When enabled, the connector provides tools for inserting, updating, creating, and dropping tables, as well as executing stored procedures, all with built-in security validations.

Question 3

What is the MSSQL Connector?

Accepted Answer

The MSSQL Connector is an MCP server that enables AI agents to securely interact with Microsoft SQL Server databases using natural language, enhanced by a business-context metadata layer.

Question 4

How does the MSSQL Connector ensure data security?

Accepted Answer

It provides secure SQL query validation (SELECT-only by default), blocks destructive patterns, uses parameterized inputs, offers a dedicated read-only mode, and supports flexible authentication via SQL Server credentials or Azure AD (OIDC).

Question 5

What is the 'business context layer' and why is it important?

Accepted Answer

The business context layer maps cryptic, legacy database naming conventions (e.g., 'STD0123' to 'Student') to human-readable terms. This allows AI agents to accurately translate natural language requests into correct SQL queries, even with complex, older schemas.

MSSQL Connector

MSSQL Connector

Key Features

Use Cases

Key Features

Use Cases