mssql-mcp

3.5

If you are the rightful owner of mssql-mcp and would like to certify it and/or have it hosted online, please leave a comment on the right or send an email to henry@mcphub.com.

MSSQL MCP Server provides database interaction and business intelligence capabilities, enabling SQL query execution, data analysis, and automatic business insight generation.

MSSQL MCP Server is a robust platform designed to facilitate interaction with Microsoft SQL Server databases. It allows users to execute SQL queries, analyze business data, and generate business insights automatically. The server supports a variety of database operations, including reading and writing data, creating tables, and managing database schemas. It is particularly useful for businesses looking to leverage their data for strategic insights and decision-making. The server is built to be compatible with Python 3.x and requires specific packages such as pyodbc, pydantic, and mcp. It also supports integration with various platforms like Claude Desktop and Windsurf, making it versatile for different business environments.

Features

Execute SELECT queries to read data from the database.
Perform INSERT, UPDATE, or DELETE operations on the database.
Create new tables within the database.
Retrieve a list of all tables present in the database.
View schema information for specific tables.

Related MCP Servers

View all databases servers →

mindsdb

by mindsdb

MindsDB is an open-source server that enables seamless interaction with large-scale federated data using the Model Context Protocol (MCP).

pg-mcp-server

by stuzero

unknown

mcp-server-neon

by neondatabase-labs

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

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.

genai-toolbox

by googleapis

MCP Toolbox for Databases is an open source MCP server for databases, designed to simplify and secure the development of database tools.

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

anyquery

by julien040

Anyquery is a versatile SQL query engine that allows users to run SQL queries on various data sources, including files, databases, and applications, with support for LLMs and MySQL server functionality.

mcp-server-mysql

by benborla

A Model Context Protocol server for MySQL databases using NodeJS, enabling LLMs to inspect schemas and execute SQL queries.

mcp-clickhouse

by ClickHouse

An MCP server for ClickHouse that allows executing SQL queries and managing databases and tables.

mcp-proxy

by TBXark

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

atlas-mcp-server

by cyanheads

ATLAS (Adaptive Task & Logic Automation System) is a project, knowledge, and task management system for LLM Agents, implemented as a Model Context Protocol (MCP) server.

developer_tools

mcp-mongo-server

by kiliczsh

A Model Context Protocol server that enables LLMs to interact with MongoDB databases, providing capabilities for inspecting collection schemas and executing MongoDB operations through a standardized interface.

airtable-mcp-server

by domdomegg

A Model Context Protocol server that provides read and write access to Airtable databases, enabling LLMs to inspect database schemas and manage records.

mcp-alchemy

by runekaagaard

MCP Alchemy is a model context protocol server that connects Claude Desktop to various databases, enabling advanced database exploration and query execution.

mongo-mcp

by QuantGeekDev

A Model Context Protocol (MCP) server that enables LLMs to interact directly with MongoDB databases. Query collections, inspect schemas, and manage data seamlessly through natural language.

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

postg-mem

by dariogriffo

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

mcp-server-weaviate

by weaviate

Weaviate MCP Server is a protocol server designed to interact with the Weaviate vector database, providing functionalities for inserting and querying data.

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-redis

by redis

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

mssql_mcp_server

by RichardHan

A Model Context Protocol (MCP) server that enables secure interaction with Microsoft SQL Server databases.

mcp-snowflake-server

by isaacwasserman

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

mcp-server-aws

by rishikavikondala

AWS MCP Server is a Model Context Protocol server implementation for AWS operations, supporting S3 and DynamoDB services.

cloud_platforms

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.