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
Highlight AIList all available non-system SQL Server databases.
List all tables and views in a specified database. Parameters: database (string), schema (string)
List all columns and column metadata in a specified table. Parameters: database (string), schema (string), table (string)
List all stored procedures in a specified database. Parameters: database (string), schema (string)
Get the definition of a stored procedure. Parameters: database (string), schema (string), name (string)
Execute a SQL query in the context of a specific database. Parameters: database (string), query (string)
Execute a SQL query at the server instance level (no database context required). Parameters: query (string)
Execute a stored procedure. Parameters: database (string), schema (string), procedure (string), parameters (object)
