MCPServerForMSSQL

3.6

Certified

This repository contains the SQL Server MCP (Model Context Protocol) integration for Claude, allowing direct querying and analysis of SQL Server databases using natural language.

The SQL MCP integration for Claude enables seamless interaction with SQL Server databases through natural language processing. It sets up a local server that communicates with Claude via the Model Context Protocol, translating natural language requests into SQL queries and returning results for interpretation. This integration is compatible with Claude's MCP protocol version '2025-03-26', ensuring proper JSON-RPC format and Content-Length headers. It simplifies database interactions by eliminating the need for ODBC, using pymssql for direct connections, and supports cross-platform functionality on macOS and Linux. The installation process is straightforward, preserving existing MCP settings while adding SQL support.

Features

No ODBC Required: Uses pymssql to connect directly to SQL Server, eliminating the need for ODBC.
Simplified Architecture: Minimal dependencies and straightforward design for easy integration.
Protocol Support: Fully compatible with Claude's MCP system, ensuring seamless communication.
Cross-Platform: Consistent performance on macOS and Linux platforms.
Easy Installation: One-step installation process with smart configuration.

Tools

execute_sql
Execute SQL queries on the connected database, returning results in JSON format.

Related MCP Servers

View all databases servers →

mcp-notion-server

by suekou

MCP Server for the Notion API, enabling LLM to interact with Notion workspaces. Additionally, it employs Markdown conversion to reduce context size when communicating with LLMs, optimizing token usage and making interactions more efficient.

mcp-server-neon

by neondatabase-labs

Neon MCP Server is an open-source tool that enables natural language interaction with Neon Postgres databases.

prisma

by prisma

Prisma is a next-generation ORM for Node.js and TypeScript, providing tools for data modeling, migrations, and querying databases.

gateway

by centralmind

CentralMind Gateway is a tool designed to expose databases to AI agents via MCP or OpenAPI protocols, providing secure, LLM-optimized APIs.

mysql_mcp_server_pro

by wenb1n-dev

mcp_mysql_server_pro is a comprehensive MySQL server tool that extends beyond basic CRUD operations to include database anomaly analysis and custom tool extensions.

mcp-server

by keboola

Keboola MCP Server connects AI agents and MCP clients to Keboola, enabling data access and transformations without glue code.

cloud_platforms

postgres-mcp

by crystaldba

Postgres MCP Pro is an open-source Model Context Protocol server designed to enhance database performance and management through advanced tools and features.

supabase-mcp

by supabase-community

Connect your Supabase projects to AI assistants using the Model Context Protocol (MCP) server.

azure-mcp

by Azure

The Azure MCP Server implements the MCP specification to create a seamless connection between AI agents and Azure services.

cloud_platforms

mcp-server-qdrant

by qdrant

The mcp-server-qdrant is a Model Context Protocol server designed to integrate with the Qdrant vector search engine, providing a semantic memory layer for storing and retrieving information.

knowledge_and_memory

supabase-mcp-server

by alexander-zuev

Query MCP is an open-source MCP server that lets your IDE safely run SQL, manage schema changes, call the Supabase Management API, and use Auth Admin SDK — all with built-in safety controls.

mariadb-mcp-server

by rjsalgado

This MCP server provides access to MariaDB / MySQL databases, allowing users to list databases, tables, describe table schemas, and execute SQL queries with security features.

mcp-proxy

by TBXark

An MCP proxy server that aggregates and serves multiple MCP resource servers through a single HTTP server.

mcp-server-milvus

by zilliztech

The MCP Server for Milvus enables seamless integration between LLM applications and the Milvus vector database, providing a standardized way to connect LLMs with the context they need.

postg-mem

by dariogriffo

PostgMem is a .NET-based MCP server that provides vector memory storage using PostgreSQL and pgvector for AI applications.

mongodb-lens

by furey

MongoDB Lens is a local Model Context Protocol (MCP) server that provides full-featured access to MongoDB databases using natural language via LLMs.

mcp-server-splunk

by jkosik

A Go implementation of the MCP server for Splunk, supporting STDIO and SSE (Server-Sent Events HTTP API) using the github.com/mark3labs/mcp-go SDK.

cloud_platforms

prometheus-mcp-server

by pab1it0

A Model Context Protocol (MCP) server for Prometheus, enabling access to Prometheus metrics and queries through standardized MCP interfaces.

mcp-redis

by redis

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

mcp-server-duckdb

by ktanaka101

A Model Context Protocol (MCP) server implementation for DuckDB, providing database interaction capabilities through MCP tools.

mcp-pinecone

by sirmews

The Pinecone Model Context Protocol Server for Claude Desktop allows users to read and write to a Pinecone index, facilitating operations like semantic search and document processing.

firebase-mcp

by gannonh

Firebase MCP enables AI assistants to work directly with Firebase services, including Firestore, Storage, and Authentication.

mcp-server-bigquery

by LucasHild

A Model Context Protocol server that provides access to BigQuery, enabling LLMs to inspect database schemas and execute queries.

meilisearch-mcp

by meilisearch

A Model Context Protocol (MCP) server for interacting with Meilisearch through LLM interfaces like Claude.

mcp-snowflake-server

by isaacwasserman

A Model Context Protocol (MCP) server implementation that provides database interaction with Snowflake.

mcp-mysql-server

by f4ww4z

A Model Context Protocol server that provides MySQL database operations, enabling AI models to interact with MySQL databases through a standardized interface.

doris-mcp-server

by apache

Doris MCP Server is a backend service built with Python and FastAPI, designed to connect to Apache Doris databases and potentially leverage LLMs for tasks like NL2SQL.