MS SQL MCP Server 1.1

@MCP-Mirror

Repository

Basic information

About MS SQL MCP Server 1.1

Mirror of

#mssql #database #ai-assistant

MS SQL MCP Server 1.1 config

No standard config provided

This server doesn't expose a parseable MCP config block in its README. See the repository for install instructions.

Repository

MS SQL MCP Server 1.1 tools

Tool list not available yet

This listing does not currently have a tool list to display. This does not mean the server has no tools; check its documentation for supported capabilities.

We auto-extract tools from the README. The maintainer can list them under a ## Tools heading to populate this section.

Overview

What is MS SQL MCP Server 1.1?

A bridge that lets AI assistants like Claude directly query and explore Microsoft SQL Server databases. It enables read-only SQL queries, table discovery, schema viewing, and natural-language-to-SQL generation without coding.

How to use MS SQL MCP Server 1.1?

Install Node.js (v14+), clone the repository, run npm install, copy .env.example to .env, edit database credentials, then start with npm start (stdio) or npm run start:sse (HTTP/SSE). Use the bundled client with npm run client for a menu-driven interface.

Key features of MS SQL MCP Server 1.1

Read-only SQL execution to protect data
Database table discovery and schema viewing
Natural language question‑to‑SQL generation
Pattern‑based table search and pagination support
Offline/local credential storage – no external service
Bundled interactive client with menu‑driven tools

Use cases of MS SQL MCP Server 1.1

Data analysts get AI‑assisted insights without sharing credentials
Developers explore database structure via natural conversation
Business analysts query data without SQL expertise
DBAs provide controlled AI access to database schemas
Build business intelligence reports (sales trends, customer segmentation)

Frequently asked questions

Is the server read‑only by default?

Yes, all queries are executed as read‑only to ensure data safety.

What transport protocols are supported?

The server supports stdio (default) and HTTP/SSE (start with `npm run start:sse`).

Where are database credentials stored?

Credentials are stored locally in the `.env` file and are never sent to external services.

What runtime is required?

Node.js version 14 or higher. Access to a Microsoft SQL Server database (on‑premises or Azure).

What tools does the server expose?

Key tools include `mcp_SQL_mcp_discover_database()`, `mcp_SQL_mcp_table_details()`, `mcp_SQL_mcp_execute_query()`, `mcp_SQL_mcp_discover_tables()`, and `mcp_SQL_mcp_get_query_results()`.

Comments

More Databases MCP servers

Multi Database MCP Server

FreePeak

A powerful multi-database server implementing the Model Context Protocol (MCP) to provide AI assistants with structured access to databases.

397

MongoDB MCP Server

mongodb-js

A Model Context Protocol server to connect to MongoDB databases and MongoDB Atlas Clusters.

1.1K

MCP DB Wizard

srmadscience

Oracle MCP server with no run-sql tool: It generates tools for each of the PL/SQL procedures, tables and approved SQL you choose. The server doesn't expose a SQL prompt, and can't reveal how it's connected to Oracle.

MySQL MCP Server

designcomputer

A Model Context Protocol (MCP) server that enables secure interaction with MySQL databases

1.3K

Xata MCP Server

The Xata MCP server lets AI assistants and agents interact with your Xata organizations, projects, and Postgres database branches.