Advertise
MCP.so
Sign In

SQL Server MCP Server for Windsurf IDE

@ian-cowley

Repository

Basic information

Category

Databases

License

MIT

Transports

stdio

Author

ian-cowley

About 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 config

No standard config provided

This server doesn't expose a parseable MCP config block in its README. See the repository for install instructions.

Repository

SQL Server MCP Server for Windsurf IDE tools

Tool list not available yet

This listing does not currently have a tool list to display. This does not mean the server has no tools; check its documentation for supported capabilities.

We auto-extract tools from the README. The maintainer can list them under a ## Tools heading to populate this section.

Overview

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

Frequently asked questions

1

What are the prerequisites?

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

2

How does the server communicate?

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

3

How do I configure the connection?

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

4

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.

5

What tools are available?

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

Comments

More Databases MCP servers

Multi Database MCP Server

FreePeak

A powerful multi-database server implementing the Model Context Protocol (MCP) to provide AI assistants with structured access to databases.

397

Dbhub

bytebase

Zero-dependency, token-efficient database MCP server for Postgres, MySQL, SQL Server, MariaDB, SQLite.

3.1K

PostgreSQL

modelcontextprotocol

Model Context Protocol Servers

88.1K

nuzur

nuzur is a model-first database platform for MySQL and PostgreSQL. The MCP server lets any AI assistant or agent (Claude, Cursor, Gemini, or anything else that speaks MCP) design your schema, query your data, generate mi

Redis

modelcontextprotocol

Model Context Protocol Servers

88.2K
Advertise