MS SQL MCP Server 1.1

What is MS SQL MCP Server 1.1?

MS SQL MCP Server 1.1 is a bridge that lets AI assistants like Claude directly query and explore Microsoft SQL Server databases. It requires no coding experience and executes read-only SQL queries by default to keep data safe.

How to use MS SQL MCP Server 1.1?

Install Node.js (version 14+), clone the repository, run npm install, copy .env.example to .env, and configure database credentials (DB_USER, DB_PASSWORD, DB_SERVER, DB_DATABASE, PORT, HOST, TRANSPORT, SERVER_URL, DEBUG, QUERY_RESULTS_PATH). Start with npm start (stdio transport) or npm run start:sse (HTTP/SSE transport). Use the bundled interactive client via npm run client.

Key features of MS SQL MCP Server 1.1

• Discover tables and their structures (columns, data types)
• Execute read-only SQL queries safely
• Generate SQL queries from natural language requests
• Supports offset/fetch and cursor-based pagination
• Query results saved as JSON files locally
• Operates via stdio or HTTP/SSE transport

Use cases of MS SQL MCP Server 1.1

• Sales performance analysis: monthly trends and top products by region
• Customer segmentation by purchase frequency and order value
• Database schema optimization and data quality auditing
• API exploration: analyze schema to design endpoints
• Natural language database interrogation for non-technical users