Home
MCP Servers
TerraCo89
mcp-server-mssql

mcp-server-mssql

3.2

If you are the rightful owner of mcp-server-mssql 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.

This project provides a Model Context Protocol (MCP) server that allows AI agents to interact with Microsoft SQL Server databases using Node.js and TypeScript.

The MCP Server for Microsoft SQL Server is designed to facilitate seamless interaction between AI agents and MSSQL databases. Implemented in Node.js and TypeScript, this server connects directly to a single MSSQL database instance, configured via environment variables. It offers a suite of tools for database management, including listing tables, retrieving table schemas, and performing CRUD operations. The server requires Node.js (v18 or later) and npm, along with access to a Microsoft SQL Server instance and the necessary MSSQL ODBC drivers. Configuration is managed through environment variables, ensuring flexibility and ease of setup. The server can be built and run using npm scripts, and it supports connection via MCP clients like Roo.

Features

Direct connection to a single MSSQL database instance.
Environment variable-based configuration.
Tools for listing tables and retrieving table schemas.
CRUD operations on database tables.
Node.js and TypeScript implementation.

Tools

list_tables
List all tables in the database
get_table_schema
Get the structure information of the specified table
read_table_rows
Read row data in a table
create_table_records
Create a new record in a table
update_table_records
Update records in the table
delete_table_records
Delete records in the table

Related MCP Servers

View all databases servers →

pg-mcp-server

by stuzero

unknown

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.

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.

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

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

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

mcp-server-mysql

by benborla

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

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.

mcp-server-elasticsearch

by elastic

This server connects agents to your Elasticsearch data using the Model Context Protocol, allowing interaction with Elasticsearch indices through natural language conversations.

mcp-kql-server

by 4R9UN

A Model Context Protocol (MCP) server for executing Kusto Query Language (KQL) queries against Azure Data Explorer clusters.

mcp-proxy

by TBXark

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

mcp-google-sheets

by xing5

mcp-google-sheets is a Python-based MCP server that connects MCP-compatible clients to Google Sheets API for automation and data manipulation.

cloud_platforms

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.

db-mcp-server

by FreePeak

A powerful multi-database server implementing the Model Context Protocol (MCP) to provide AI assistants with structured access to databases.

mcp-graphql

by blurrah

A Model Context Protocol server that enables LLMs to interact with GraphQL APIs, providing schema introspection and query execution capabilities.

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

mcp-server-duckdb

by ktanaka101

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

mssql_mcp_server

by RichardHan

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

firebase-mcp

by gannonh

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

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.

supabase-mcp

by coleam00

A Model Context Protocol (MCP) server that provides tools for interacting with a Supabase database. This server enables AI assistants to perform database operations through a standardized interface.

MCPServerForMSSQL

by shakunvohradeltek

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.

notion-mcp-server

by awkoy

Notion MCP Server is a Model Context Protocol server implementation that enables AI assistants to interact with Notion's API, providing tools for reading, creating, and modifying Notion content through natural language interactions.

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.