SQL Server
Summary
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.
Available Actions(8)
connect
Connect to a SQL Server using a connection string. Parameters: connectionString (string)
get_databases
List all databases available on the SQL Server. Parameters: None
get_tables
List all tables in a specified database. Parameters: database (string)
get_columns
Get the columns of a specified table in a specified database. Parameters: database (string), schema (string), table (string)
get_procedures
List all stored procedures in a specified database. Parameters: database (string)
execute_database_query
Execute a SQL query against a specified database. Parameters: database (string), query (string), parameters (optional object)
execute_system_query
Execute a system query (e.g., querying system tables). Parameters: query (string), parameters (optional object)
execute_procedure
Execute a stored procedure in a specified database. Parameters: database (string), schema (string), procedure (string), parameters (optional object)
Community Reviews
No reviews yet. Be the first to review!
Sign in to join the conversation
