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 AIConnect to a SQL Server using a connection string. Parameters: connectionString (string)
List all databases on the connected SQL Server. Parameters: None
List tables in a specified database. Parameters: database (string)
Get columns of a specified table in a 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 SQL query. Parameters: query (string), parameters (object)
Execute a specified stored procedure in a database. Parameters: database (string), schema (string), procedure (string), parameters (object)
