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. Parameters: connectionString (string)
List all databases. Parameters: none
List tables in a specified database. Parameters: database (string)
Get columns from a specified table in a specific database. Parameters: database (string), schema (string), table (string)
List stored procedures in a specified database. Parameters: database (string)
Execute a SQL query on a specified database. Parameters: database (string), query (string), parameters (object)
Execute a system query. Parameters: query (string), parameters (object)
Execute a stored procedure in a specified database. Parameters: database (string), schema (string), procedure (string), parameters (object)
