mcp-server-mssql

TerraCo89/mcp-server-mssql

3.2
databases

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 dayong@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.

Tools
6
Resources
0
Prompts
0

MCP Server for Microsoft SQL Server (Node.js/TypeScript)

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

Features

  • Connects directly to a single MSSQL database instance configured via environment variables.
  • Provides tools for:
    • Listing tables (list_tables).
    • Retrieving table schemas (get_table_schema).
    • Performing CRUD operations (read_table_rows, create_table_records, update_table_records, delete_table_records).

Prerequisites

  • Node.js (v18 or later recommended)
  • npm (usually comes with Node.js)
  • Access to a Microsoft SQL Server instance.
  • Necessary MSSQL ODBC drivers installed on the machine running the server.

Installation

  1. Clone the repository: 
    git clone <repository-url>
cd mcp-server-mssql
  2. Install dependencies: 
    npm install

Configuration

  1. Environment Variables: Configuration is handled entirely through environment variables.
    • Copy .env.example to .env.
    • Fill in the required MSSQL connection details:
      • MSSQL_HOST
      • MSSQL_PORT (defaults to 1433 if not set)
      • MSSQL_USER
      • MSSQL_PASSWORD
      • MSSQL_DATABASE
    • Optionally configure other MSSQL options (MSSQL_DRIVER, MSSQL_ENCRYPT, MSSQL_TRUST_SERVER_CERTIFICATE) and logging (LOG_LEVEL) as described in .env.example.

Usage

  1. Build the TypeScript code: 
    npm run build
  2. Run the server: 
    npm start
    Alternatively, for development: 
    npm run dev
  3. Connect via MCP Client: Configure your MCP client (e.g., Roo) to connect to this server using stdio.

Tools

(Detailed descriptions of the tools can be found in the server's ListTools response)

  • list_tables
  • get_table_schema
  • read_table_rows
  • create_table_records
  • update_table_records
  • delete_table_records

Development

(Add details about running tests, linting, etc. later)

License

[MIT] - (Or your chosen license)

Related MCP Servers

View all databases servers →
dbhub

dbhub

4.6

by bytebase

DBHub is a universal database gateway implementing the Model Context Protocol (MCP) server interface.

databases
mindsdb

mindsdb

4.6

by mindsdb

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

databases
mcp-alchemy

mcp-alchemy

4.4

by runekaagaard

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

databases
mcp-pinecone

mcp-pinecone

4.4

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.

databases
notion-mcp-server

notion-mcp-server

4.4

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.

ai_chatbot
mcp-clickhouse

mcp-clickhouse

4.3

by ClickHouse

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

databases
mongodb-mcp-server

mongodb-mcp-server

4.2

by mongodb-js

A Model Context Protocol server for interacting with MongoDB Databases and MongoDB Atlas.

databases
mcp-server-qdrant

mcp-server-qdrant

4.1

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
sqlite-explorer-fastmcp-mcp-server

sqlite-explorer-fastmcp-mcp-server

4.0

by hannesrudolph

SQLite Explorer MCP Server provides safe, read-only access to SQLite databases using the FastMCP framework.

databases
genai-toolbox

genai-toolbox

4.0

by googleapis

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

databases
supabase-mcp-server

supabase-mcp-server

4.0

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.

databases
supabase-mcp

supabase-mcp

3.9

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.

databases
mcp-server-neon

mcp-server-neon

3.9

by neondatabase

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

databases
mcp-server-mysql

mcp-server-mysql

3.8

by benborla

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

databases
azure-mcp

azure-mcp

3.8

by Azure

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

cloud_platforms
chroma-mcp

chroma-mcp

3.7

by chroma-core

Chroma MCP Server is an open-source embedding database server that facilitates the integration of LLM applications with external data sources using the Model Context Protocol.

databases
mcp-server-motherduck

mcp-server-motherduck

3.7

by motherduckdb

An MCP server implementation that interacts with DuckDB and MotherDuck databases, providing SQL analytics capabilities to AI Assistants and IDEs.

databases
mcp-google-sheets

mcp-google-sheets

3.7

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
airtable-mcp-server

airtable-mcp-server

3.7

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.

databases
openehr-mcp-server

openehr-mcp-server

3.7

by deak-ai

An MCP server designed to interface with openEHR REST APIs, specifically the EHRbase implementation.

databases
mariadb-mcp-server

mariadb-mcp-server

3.7

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.

databases
mcp-server-milvus

mcp-server-milvus

3.6

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.

databases
mcp-teradata

mcp-teradata

3.6

by arturborycki

A Model Context Protocol (MCP) server implementation that provides database interaction and business intelligence capabilities through Teradata.

databases
mcp-database-server

mcp-database-server

3.6

by executeautomation

The MCP Database Server provides database access capabilities to Claude, supporting SQLite, SQL Server, and PostgreSQL databases.

databases
redshift-utils-mcp

redshift-utils-mcp

3.6

by vinodismyname

Redshift Utils MCP Server is a Model Context Protocol server designed to integrate LLM capabilities with Amazon Redshift databases.

databases
mssql_mcp_server

mssql_mcp_server

3.6

by RichardHan

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

databases
mcp-server-starrocks

mcp-server-starrocks

3.6

by StarRocks

The StarRocks Official MCP Server facilitates seamless interaction between AI assistants and StarRocks databases, enabling SQL execution, data exploration, and visualization.

databases