MCP.so
Sign In

SQL Server MCP Server for Windsurf IDE

@ian-cowley

Repository

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

Basic information

Category

Databases

License

MIT

Runtime

c#

Transports

stdio

Publisher

ian-cowley

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

Tools

No tools detected

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

FAQ from SQL Server MCP Server for Windsurf IDE

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.

Comments

More Databases MCP servers

Elasticsearch/OpenSearch MCP Server

cr7258

A Model Context Protocol (MCP) server implementation that provides Elasticsearch and OpenSearch interaction.

295

MongoDB Lens

furey

🍃🔎 MongoDB Lens: Full Featured MCP Server for MongoDB Databases

204

MCP Alchemy

runekaagaard

A MCP (model context protocol) server that gives the LLM access to and knowledge about relational databases like SQLite, Postgresql, MySQL & MariaDB, Oracle, and MS-SQL.

412

mcp-server-qdrant: A Qdrant MCP server

qdrant

An official Qdrant Model Context Protocol (MCP) server implementation

637

Neon MCP Server

neondatabase

MCP server for interacting with Neon Management API and databases

617