MSSQL FAQs

Question 1

What connection string formats are supported by MSSQL-MCP?

Accepted Answer

The tool supports standard ADO.NET-style connection strings (e.g., `Server=host,port;Database=db;User Id=...`) as well as the `sqlserver://` URL format for specifying connections.

Question 2

Can MSSQL-MCP be used as a standalone tool or only with MCP servers?

Accepted Answer

MSSQL-MCP works both as an MCP (Model Context Protocol) server for integration with AI assistants (like Claude) and as a robust, standalone CLI (Command Line Interface) tool. You can execute all its functions directly from your terminal.

Question 3

What is MSSQL-MCP and what is its primary purpose?

Accepted Answer

MSSQL-MCP is a powerful tool designed to connect to Microsoft SQL Server databases. Its primary purpose is to auto-discover connection strings directly from .NET `appsettings.json` files, enabling seamless querying and exploration without manual configuration, especially useful for AI assistants and developers.

Question 4

How does MSSQL-MCP handle connection string discovery?

Accepted Answer

MSSQL-MCP automatically scans `appsettings.json` and `appsettings.*.json` files within a specified directory (or current directory) to find connection strings. It supports discovery from both standard `ConnectionStrings` sections and top-level keys like `umbracoDbDSN`.

Question 5

What database operations can I perform with MSSQL-MCP?

Accepted Answer

You can perform four main operations: `discover` connections, `query` the database with custom SQL, `list tables` within a connected database, and `describe schema` for specific tables, showing columns, types, and keys.

MSSQL

MSSQL

Key Features

Use Cases

Key Features

Use Cases