Mcp Sqlserver

Created By

bilimsa year ago

# mcp-sqlserver

Overview Content Tools Comments

Overview

What is MCP SQL Server?

MCP SQL Server is a Model Context Protocol (MCP) server that allows AI agents to interact with Microsoft SQL Server databases, enabling secure and intelligent database operations.

How to use MCP SQL Server?

To use MCP SQL Server, you can run it directly using NPX, install it globally, or build it from source. Configuration is done through a .env file with your SQL Server settings.

Key features of MCP SQL Server?

CRUD Operations: Complete functionality for SELECT, INSERT, UPDATE, DELETE.
Custom Queries: Safe execution of custom SELECT statements.
Schema Introspection: Explore database structures.
Stored Procedures: Execute stored procedures with parameters.
Transaction Management: Manage transactions with isolation levels.
Security: Parameterized queries to prevent SQL injection.

Use cases of MCP SQL Server?

Automating database operations for AI applications.
Managing complex SQL Server transactions.
Performing bulk data operations efficiently.

FAQ from MCP SQL Server?

Can MCP SQL Server handle large datasets?

Yes, it supports high-performance bulk operations.

Is it secure for production use?

Yes, it includes multiple security features to protect against SQL injection and unauthorized access.

What are the prerequisites?

Node.js 20+, TypeScript 5.0+, and Microsoft SQL Server 2016+ are required.

Try in Playground

Server Config

{
  "mcpServers": {
    "mcp-sqlserver": {
      "command": "npx",
      "args": [
        "-y",
        "@bilims/mcp-sqlserver"
      ],
      "env": {
        "SQLSERVER_HOST": "your-server-host",
        "SQLSERVER_DATABASE": "your-database",
        "SQLSERVER_USERNAME": "your-username",
        "SQLSERVER_PASSWORD": "your-password"
      }
    }
  }
}

Project Info

Created At

a year ago

Updated At

a year ago

Author Name

bilims

Star

-

Language

-

License

-

Category

developer-tools

Tags

Homepage

https://github.com/bilims/mcp-sqlserver

Recommend Servers

Sequential Thinking

@modelcontextprotocol

An MCP server implementation that provides a tool for dynamic and reflective problem-solving through a structured thinking process.

a year ago

302_sandbox_mcp

Create a remote sandbox that can execute code/run commands/upload and download files. 创建远程沙盒，可以执行代码/运行命令/上传下载文件

a year ago

Bangladesh Payments Mcp

@junter1989k-ai

11 days ago

Ukraine Payments Mcp

@junter1989k-ai

11 days ago

Czechia Payments Mcp

@junter1989k-ai

11 days ago

GBOX Android MCP

GBOX provides environments for AI Agents to operate computer and mobile devices. Mobile Scenario: Your agents can use GBOX to develop/test android apps, or run apps on the Android to complete various tasks(mobile automation). Desktop Scenario: Your agents can use GBOX to operate desktop apps such as browser, terminal, VSCode, etc(desktop automation). MCP: You can also plug GBOX MCP to any Agent you like, such as Cursor, Claude Code. These agents will instantly get the ability to operate computer and mobile devices.

a year ago

New Zealand Payments Mcp

@junter1989k-ai

11 days ago

高德地图官方 MCP Server

a year ago

Qiniu MCP Server

基于七牛云产品构建的 Model Context Protocol (MCP) Server，支持用户在 AI 大模型客户端的上下文中通过该 MCP Server 来访问七牛云存储资源、利用 Dora 服务进行图片操作等。如果有什么需求欢迎在下方评论，您也可以在 github 仓库中提 issue。

Python

a year ago

BlenderMCP connects Blender to Claude AI through the Model Context Protocol (MCP), allowing Claude to directly interact with and control Blender. This integration enables prompt assisted 3D modeling, scene creation, and manipulation.

a year ago

Canada Payments Mcp

@junter1989k-ai

11 days ago

Aws Kb Retrieval Server

@modelcontextprotocol

An MCP server implementation for retrieving information from the AWS Knowledge Base using the Bedrock Agent Runtime.

a year ago

Finland Payments Mcp

@junter1989k-ai

11 days ago

Tanzania Payments Mcp

@junter1989k-ai

11 days ago

Australia Payments Mcp

@junter1989k-ai

11 days ago

South Africa Payments Mcp

@junter1989k-ai

12 days ago

Kenya Payments Mcp

@junter1989k-ai

12 days ago

@modelcontextprotocol

a year ago

Jordan Payments Mcp

@junter1989k-ai

11 days ago

Norway Payments Mcp

@junter1989k-ai

11 days ago

Latvia Payments Mcp

@junter1989k-ai

11 days ago

JavaScript

a year ago

Malta Payments Mcp

@junter1989k-ai

11 days ago

Papaya Pay Any Bill

Ready for a new way to bill pay? Pay any bill in a snap, right from a chat. Describe or snap a photo of your bill (electric, water, gas, internet, phone, medical, credit card, rent, parking tickets, traffic violations and more) and Papaya reads it, then hands you a secure link to pay by card. Fast, secure, and no juggling twelve logins, with full or partial payments and status updates. Powered by Papaya (papayapay.com).

11 days ago

Israel Payments Mcp

@junter1989k-ai

11 days ago

Hungary Payments Mcp

@junter1989k-ai

11 days ago

Croatia Payments Mcp

@junter1989k-ai

11 days ago

Austria Payments Mcp

@junter1989k-ai

11 days ago

Neon MCP Server

@neondatabase-labs

MCP server for interacting with Neon Management API and databases

TypeScript

a year ago

One API for Search, Crawling, and Sitemaps

a year ago