SQL Server MCP Server for Windsurf IDE

@ian-cowley

代码仓库

基本信息

分类

数据库

许可证

MIT

传输方式

stdio

作者

ian-cowley

关于 SQL Server MCP Server for Windsurf IDE

SQL Server MCP Server - A standalone MCP server providing SQL Server integration capabilities

#sqlserver #mcp-server#windsurf-ide

SQL Server MCP Server for Windsurf IDE 配置

暂无标准配置

该服务器的 README 中没有可解析的 MCP 配置块，请前往代码仓库查看安装说明。

代码仓库

SQL Server MCP Server for Windsurf IDE 工具

工具列表暂未提供

当前收录暂时没有可展示的工具列表，不代表服务没有工具。请查阅项目文档了解支持的能力。

工具是从 README 中自动提取的。维护者可以在 ## Tools 标题下列出工具,即可填充这部分内容。

概览

What is SQL Server MCP Server for Windsurf IDE?

SQL Server MCP Server for Windsurf IDE is a standalone C# server that provides SQL Server integration for any MCP-compliant IDE or client. It enables AI assistants to browse schemas, execute queries, and run stored procedures against SQL Server databases.

How to use SQL Server MCP Server for Windsurf IDE?

Build the project with .NET 10.0 SDK or higher, configure appsettings.json with your SQL Server connection string, then add the server to your IDE’s MCP config file (e.g., Windsurf, Claude Desktop, Cursor) pointing to the built executable.

Key features of SQL Server MCP Server for Windsurf IDE

SQL Server database connectivity and schema exploration
Table, view, and column metadata inspection
Stored procedure enumeration and execution
SQL query execution at database or system level
Debug mode and configurable logging path
Dynamic Project Connection Resolver for multi-project workspaces

Use cases of SQL Server MCP Server for Windsurf IDE

Browse database schemas and get code completion for table/column names
Execute SQL queries and view results directly from the IDE
Run stored procedures with custom parameters
Generate SQL code snippets based on database structure analysis
Manage multiple databases in a workspace with automatic connection resolution

常见问题

What are the prerequisites?

.NET 10.0 SDK or higher, a SQL Server instance, and SQL Server client tools.

How does the server communicate?

It uses standard input/output with JSON-RPC 2.0 protocol (Model Context Protocol).

How do I configure the connection?

Edit `appsettings.json` with your SQL Server connection string, log path, and debug mode setting.

What is the Dynamic Project Connection Resolver?

It automatically uses the nearest `appsettings.json` from the active file’s directory to override the connection string for multi-project workspaces.

What tools are available?

Tools include listing databases, tables, columns, stored procedures, executing queries, and running stored procedures.

数据库分类下的更多 MCP 服务器

Schemity

tbson

Local database MCP server: your agent sees a migration's impact before it runs, for PostgreSQL, MySQL, SQL Server and SQLite, with no database credentials.

NPILayer

Healthcare provider data for AI assistants, from the official CMS NPPES dataset (updated weekly). Look up any NPI (active or deactivated), search providers and organizations by name, city, state, ZIP, taxonomy code or pl

Lawstronaut

Lawstronaut-FZCO

Access millions of official legal and regulatory source documents from 155+ jurisdictions via MCP. Lawstronaut supports AI agents with structured legal research, legal data, laws, regulations, cases, guidance, official s