SQL Server MCP Server for Windsurf IDE
@ian-cowley
About SQL Server MCP Server for Windsurf IDE
SQL Server MCP Server - A standalone MCP server providing SQL Server integration capabilities
Config
No standard config provided
This server doesn't expose a parseable MCP config block in its README. See the repository for install instructions.
RepositoryTools
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.
Frequently asked questions
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.
Basic information
More Databases MCP servers
Database Gateway
centralmindUniversal MCP-Server for your Databases optimized for LLMs and AI-Agents.
Sail MCP Server for Spark SQL
lakehqDrop-in Apache Spark replacement written in Rust, unifying batch processing, stream processing, and compute-intensive AI workloads.
PostgreSQL
modelcontextprotocolModel Context Protocol Servers
MySQL MCP Server
designcomputerA Model Context Protocol (MCP) server that enables secure interaction with MySQL databases
Neon MCP Server
neondatabaseMCP server for interacting with Neon Management API and databases
Comments