MCPSqlServer is a standalone C# server built for the Model Context Protocol (MCP). It acts as an add-on for Windsurf IDE, enabling seamless integration with SQL Server databases.
To get started, build the project using the .NET SDK. Next, edit the appsettings.json file to configure your application settings. Finally, integrate the server with Windsurf IDE by updating its MCP configuration file.
Its key features include SQL Server connectivity, database schema exploration, and inspection of tables and views. You can also retrieve column metadata, enumerate stored procedures, and execute SQL queries. For troubleshooting, a debug mode is available, and the logging path is configurable.
Common use cases involve connecting Windsurf IDE to SQL Server to execute queries and retrieve results. It is also ideal for browsing and analyzing database schemas, as well as running stored procedures and generating SQL code snippets.
Frequently asked questions: What are the prerequisites? You will need .NET 9.0 SDK or later, access to a SQL Server instance, and SQL Server client tools. Is it free? Yes, MCPSqlServer is open-source and licensed under the MIT License. How can I contribute? You can fork the repository, create a feature branch, and submit a pull request.