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

Czechia Payments Mcp

@junter1989k-ai

12 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

Qatar Payments Mcp

@junter1989k-ai

12 days ago

Hungary Payments Mcp

@junter1989k-ai

12 days ago

Rwanda Payments Mcp

@junter1989k-ai

12 days ago

Sweden Payments Mcp

@junter1989k-ai

12 days ago

Saudi Arabia Payments Mcp

@junter1989k-ai

13 days ago

@modelcontextprotocol

Channel management and messaging capabilities

a year ago

Lithuania Payments Mcp

@junter1989k-ai

12 days ago

Estonia Payments Mcp

@junter1989k-ai

12 days ago

Ireland Payments Mcp

@junter1989k-ai

12 days ago

302_browser_use_mcp

Automatically create a remote browser to complete your specified tasks, developed based on Browser Use + Sandbox. 自动创建一个远程浏览器，完成你指定的任务，基于Browser Use + Sandbox开发。

a year ago

Poland Payments Mcp

@junter1989k-ai

13 days ago

@modelcontextprotocol

Web and local search using Brave's Search API

a year ago

302_sandbox_mcp

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

a year ago

Greece Payments Mcp

@junter1989k-ai

12 days ago

Spain Payments Mcp

@junter1989k-ai

12 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).

12 days ago

Canada Payments Mcp

@junter1989k-ai

12 days ago

Official MiniMax Model Context Protocol (MCP) server that enables interaction with powerful Text to Speech, image generation and video generation APIs.

Python

a year ago

South Africa Payments Mcp

@junter1989k-ai

13 days ago

Bulgaria Payments Mcp

@junter1989k-ai

12 days ago

Belgium Payments Mcp

@junter1989k-ai

13 days ago

Cyprus Payments Mcp

@junter1989k-ai

12 days ago

Senegal Payments Mcp

@junter1989k-ai

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

Uganda Payments Mcp

@junter1989k-ai

12 days ago

Zhipu Web Search

Zhipu Web Search MCP Server is a search engine specifically designed for large models. It integrates four search engines, allowing users to flexibly compare and switch between them. Building upon the web crawling and ranking capabilities of traditional search engines, it enhances intent recognition capabilities, returning results more suitable for large model processing (such as webpage titles, URLs, summaries, site names, site icons, etc.). This helps AI applications achieve "dynamic knowledge acquisition" and "precise scenario adaptation" capabilities.

a year ago

Playwright MCP server

TypeScript

a year ago

Guatemala Payments Mcp

@junter1989k-ai

12 days ago