SQL Server MCP Server for Windsurf IDE - A standalone MCP server providing SQL Server integration capabilities
Overview
What is MCPSqlServer?
MCPSqlServer is a standalone Model Context Protocol (MCP) server written in C# that provides SQL Server integration capabilities as an addon to Windsurf IDE.
How to use MCPSqlServer?
To use MCPSqlServer, build the project using .NET SDK, configure the application settings in appsettings.json, and integrate it with Windsurf IDE by updating the MCP configuration file.
Key features of MCPSqlServer?
- SQL Server connectivity
- Database schema exploration
- Table and view inspection
- Column metadata retrieval
- Stored procedure enumeration
- SQL query execution
- Debug mode for troubleshooting
- Configurable logging path
Use cases of MCPSqlServer?
- Connecting to SQL Server databases from Windsurf IDE.
- Executing SQL queries and retrieving results.
- Browsing and analyzing database schemas.
- Running stored procedures and generating SQL code snippets.
FAQ from MCPSqlServer?
- What are the prerequisites for using MCPSqlServer?
You need .NET 9.0 SDK or higher, a SQL Server instance, and SQL Server client tools.
- Is MCPSqlServer free to use?
Yes! MCPSqlServer is open-source and available under the MIT License.
- How can I contribute to MCPSqlServer?
You can fork the repository, create a feature branch, and submit a pull request.