Advertise
MCP.so
Sign In

MS SQL MCP Server 1.1

@dperussina

Repository

Basic information

Category

Databases

License

GPL-3.0

Transports

stdio

Author

dperussina

Submitted by

Danny P

About MS SQL MCP Server 1.1

MCP server for MS SQL Server

#mssql#sql-server#database-query

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?

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

Frequently asked questions

1

Can MS SQL MCP Server 1.1 modify my database?

No. All queries are read-only by default, ensuring data safety.

2

What are the runtime requirements?

Node.js version 14 or higher and access to a Microsoft SQL Server database (on-premises or Azure).

3

How do I change the transport mode?

Edit the `.env` file: set `TRANSPORT=stdio` for local use or `TRANSPORT=sse` for network access, then start with `npm start` or `npm run start:sse` respectively.

4

Where are query results stored?

Results of executed queries are saved as JSON files in the directory specified by the `QUERY_RESULTS_PATH` environment variable.

5

Does the server support pagination?

Yes. It supports both offset/fetch (`OFFSET ... ROWS FETCH NEXT ... ROWS ONLY`) and cursor-based pagination (`WHERE ID > last_id ORDER BY ID`).

Comments

More Databases MCP servers

MongoDB MCP Server

mongodb-js

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

1.1K

Lawstronaut

Lawstronaut-FZCO

Access millions of official legal and regulatory source documents from 155+ jurisdictions via MCP. Lawstronaut supports AI agents with structured legal research, legal data, laws, regulations, cases, guidance, official s

Redis

modelcontextprotocol

Model Context Protocol Servers

88.2K

Expired Domains MCP | Karma.Domains

karma-domains

Connect Karma.Domains to ChatGPT, Claude, Cursor, VS Code, or another MCP client — and find a domain in plain language. The same auctions, expired, backorder, and buy-now data you use in the app, plus saved filters, note

Fund Momentum MCP Server

schneidavie

Fund Momentum MCP Server — VC intelligence for AI assistants. 1000+ active VC funds, live investor signals, AI-powered startup matching.

Advertise