SQL Server

Provides SQL Server connectivity and management actions via an MCP service for Windsurf IDE.

other

14

GitHub Stars

other

Language

6 months ago

First Indexed

2 months ago

Catalog Refreshed

Documentation & install

Readme and setup notes from the catalogue, plus a client-ready config you can copy for your MCP host.

Installation

Add the following to your MCP client configuration file.

Configuration

View docs

{
  "mcpServers": {
    "ian-cowley-mcpsqlserver": {
      "command": "path/to/your/MCPSqlServer.exe",
      "args": []
    }
  }
}

You can add SQL Server integration to Windsurf IDE with a standalone MCP server written in C#. This server lets you connect to SQL Server, inspect schemas, run queries and stored procedures, and debug during development. It provides a practical bridge between Windsurf and your SQL data sources, enabling fast iteration and code generation within the IDE.

How to use

In Windsurf, configure the SQL Server MCP service to connect to your SQL Server instance. Once connected, you can browse databases, inspect tables and views, explore column metadata, enumerate stored procedures, and execute queries or stored procedures directly from the IDE. Use the MCP service to generate SQL snippets, run ad hoc queries, and troubleshoot database structures with a dedicated debug mode that helps you diagnose issues.

How to install

Prerequisites you need before installing the MCP server are listed below. Ensure you have these ready before starting the setup.

dotnet build

Configure the application settings by creating a working configuration file. Copy the example configuration to a new file and update the SQL Server connection details and logging paths.

{
  "ConnectionStrings": {
    "DefaultConnection": "Server=your-server;Database=master;User ID=your-username;Password=your-password;TrustServerCertificate=True"
  },
  "LogPath": "C:\\Path\\To\\Your\\LogDirectory\\",
  "DebugMode": "false"
}

Next, configure Windsurf to recognize and run the MCP server. Create or update your MCP configuration to point to the built executable and give the service a name and description.

{
  "mcpServers": {
    "sqlMcpService": {
      "command": "path/to/your/MCPSqlServer.exe",
      "args": [],
      "description": "SQL Server MCP Service"
    }
  }
}

Additional setup notes

If you want to publish the MCP server as a self-contained executable, you can build a distribution that includes all dependencies. Use the release configuration and specify a Windows x64 runtime, and enable a single-file publish.

dotnet publish -c Release -r win-x64 --self-contained true -p:PublishSingleFile=true

Available tools

connect

Establishes a connection to a SQL Server instance using a configured connection string.

get_databases

Lists available databases on the connected SQL Server.

get_tables

Retrieves tables and views for a selected database to explore schema.

get_columns

Fetches column metadata for a specified table.

get_procedures

Lists stored procedures available in the specified database.

execute_database_query

Executes a SQL query against a chosen database and returns results.

execute_system_query

Executes system-level queries, such as retrieving database information from system catalogs.

execute_procedure

Runs a stored procedure with provided parameter values and returns results.