This MCP server implementation provides SQL Server integration capabilities for Windsurf IDE. Developed by MCPSqlServer Contributors, it offers tools for database schema exploration, query execution, and stored procedure management. The server uses a JSON-RPC protocol for communication and supports features like database switching, table inspection, and column metadata retrieval. It's designed for use cases requiring AI assistants to interact with SQL Server databases, such as natural language querying of relational data or AI-driven database analysis.
No reviews yet. Be the first to review!
Sign in to join the conversation
Connect to a SQL Server using a specified connection string.
List all databases available in the connected SQL Server.
List all tables in a specified database.
Retrieve the columns of a specified table in a given database and schema.
List all stored procedures in a specified database.
Execute a SQL query on a specified database with optional parameters.
Execute a system query on the SQL Server with optional parameters.
Execute a specified stored procedure in a given database and schema with parameters.