SQL Server MCP (Model Context Protocol) Server
Overview
What is SQL Server MCP?
SQL Server MCP (Model Context Protocol) Server is a server designed to connect to one or more SQL Server databases, enabling Visual Studio Code and GitHub Copilot to interact with SQL databases via the Model Context Protocol.
How to use SQL Server MCP?
To use SQL Server MCP, set up the server with the required environment variables, start the server using the provided scripts, and configure Visual Studio Code to connect to the MCP server.
Key features of SQL Server MCP?
- SQL query execution
- Database metadata retrieval (tables, views, stored procedures, functions)
- Connection string encryption with AES-256
- Robust logging with Serilog
- Dependency injection for testable components
- Strongly-typed models for database metadata
Use cases of SQL Server MCP?
- Executing SQL queries through Visual Studio Code.
- Retrieving detailed database schema information.
- Managing multiple database connections securely.
FAQ from SQL Server MCP?
- Can SQL Server MCP connect to multiple databases?
Yes, it can connect to one or more SQL Server databases.
- Is there a way to encrypt connection strings?
Yes, connection strings are encrypted using AES-256 encryption.
- How do I manage database connections?
You can manage connections through the MCP interface or programmatically using the provided tools.
Recommend Servers
TraeBuild with Free GPT-4.1 & Claude 3.7. Fully MCP-Ready.
MCP AdvisorMCP Advisor & Installation - Use the right MCP server for your needs
ChatWiseThe second fastest AI chatbot™
Playwright McpPlaywright MCP server
MiniMax MCPOfficial MiniMax Model Context Protocol (MCP) server that enables interaction with powerful Text to Speech, image generation and video generation APIs.
AiimagemultistyleA Model Context Protocol (MCP) server for image generation and manipulation using fal.ai's Stable Diffusion model.
Baidu Map百度地图核心API现已全面兼容MCP协议，是国内首家兼容MCP协议的地图服务商。
Tavily Mcp
Amap Maps高德地图官方 MCP Server
WindsurfThe new purpose-built IDE to harness magic
Howtocook Mcp基于Anduin2017 / HowToCook （程序员在家做饭指南）的mcp server，帮你推荐菜谱、规划膳食，解决“今天吃什么“的世纪难题；
Based on Anduin2017/HowToCook (Programmer's Guide to Cooking at Home), MCP Server helps you recommend recipes, plan meals, and solve the century old problem of "what to eat today"
TimeA Model Context Protocol server that provides time and timezone conversion capabilities. This server enables LLMs to get current time information and perform timezone conversions using IANA timezone names, with automatic system timezone detection.
Jina AI MCP ToolsA Model Context Protocol (MCP) server that integrates with Jina AI Search Foundation APIs.
Visual Studio Code - Open Source ("Code - OSS")Visual Studio Code
Serper MCP ServerA Serper MCP Server
Zhipu Web SearchZhipu 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.
CursorThe AI Code Editor
DeepChatYour AI Partner on Desktop
EdgeOne Pages MCPAn MCP service designed for deploying HTML content to EdgeOne Pages and obtaining an accessible public URL.
BlenderBlenderMCP 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.
Context7Context7 MCP Server -- Up-to-date code documentation for LLMs and AI code editors