Advertise
MCP.so
Sign In

SQL Server MCP Server

@ranjithr99

Repository

Basic information

Category

Databases

Transports

stdio

Author

ranjithr99

About SQL Server MCP Server

No overview available yet

#sql#database#mcp

SQL Server MCP Server 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

SQL Server MCP Server 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 SQL-Server-MCP?

A lightweight MCP stdio server that connects to Microsoft SQL Server using provided credentials and exposes tools to query and discover schema. It is designed for MCP-compatible clients such as Claude Desktop.

How to use SQL-Server-MCP?

Install Node.js >= 18, then run npm install and npm run build to build the server. Start it with npm start. The server communicates over stdio and must be driven by an MCP client. Use the connect tool first with SQL Server credentials, then use other tools like query, info, or list_* tools.

Key features of SQL-Server-MCP

  • Connects to Microsoft SQL Server via MCP stdio.
  • Exposes tools: connect, disconnect, query, info.
  • Lists databases, schemas, and tables.
  • Executes arbitrary SQL queries securely.
  • Credentials provided at call-time, not stored.
  • Built with TypeScript, MIT licensed.

Use cases of SQL-Server-MCP

  • Query a SQL Server database from an MCP client like Claude Desktop.
  • Discover database schema: list databases, schemas, and tables.
  • Execute ad-hoc SQL queries and retrieve results.
  • Integrate SQL Server data into AI assistant workflows.

Frequently asked questions

1

How do I connect to SQL Server?

Use the `connect` tool with `server`, `port`, `user`, `password`, optional `database`, and `encrypt` flag.

2

What tools are available after connecting?

Tools: `info` (returns `@@VERSION`), `query` (execute SQL), `list_databases`, `list_schemas`, `list_tables`.

3

Are credentials stored?

No, credentials are provided at call-time and not stored. TLS encryption defaults to `true`.

4

What are the runtime requirements?

Node.js version 18 or higher is required.

5

Can I list tables from a specific schema?

Yes, the `list_tables` tool accepts an optional `schema` parameter to filter results.

Comments

More Databases MCP servers

Redis MCP Server

redis

The official Redis MCP Server is a natural language interface designed for agentic applications to manage and search data in Redis efficiently

539

Sqlite

modelcontextprotocol

Model Context Protocol Servers

88.1K

golfdata.online - Verified Golf Clubs

golfdata.online

Verified golf club data for AI agents: holes, par, address, phone, booking links, facilities, visitor rules and green fees for golf clubs in Spain (Canary Islands and mainland), expanding across Europe. Every fact comes

Neon MCP Server

neondatabase-labs

MCP server for interacting with Neon Management API and databases

617

PostgreSQL

modelcontextprotocol

Model Context Protocol Servers

88.1K
Advertise