S
SQL Server
Provides robust SQL Server database access with T-SQL validation, connection management, and cross-platform Docker support for executing queries, discovering sc
Share:
About
Provides robust SQL Server database access with T-SQL validation, connection management, and cross-platform Docker support for executing queries, discovering schemas, and exploring table structures.
Example tools
Illustrative tool names — the actual tool set is defined by the server at runtime.
query
Run a read-only SQL query
list_tables
List tables in the connected database
describe_table
Return column info for a table
Screenshots
No screenshots yet.
Frequently Asked Questions
Common questions about SQL Server.
- What is the primary function of the SQL Server MCP?
- The SQL Server MCP provides access to SQL Server databases. It supports T-SQL validation, manages connections, and facilitates executing queries and schema discovery.
- How can I deploy this SQL Server MCP?
- This MCP supports cross-platform Docker deployment. You would typically use a suitable Docker environment to get the MCP running, and then connect to it via an MCP client.
- Does this MCP require authentication credentials?
- The provided information states 'Auth type: none', suggesting no explicit authentication is required by the MCP itself. However, access to the SQL Server database will require its own authentication.
- What specific database operations does this SQL Server MCP support?
- This MCP allows for executing T-SQL queries, discovering database schemas, and exploring the structure of tables within a SQL Server instance.
- Are there any known limitations or prerequisites for using this SQL Server MCP?
- A prerequisite is access to a running SQL Server instance. The MCP itself does not provide the SQL Server, only the interface to connect to it. Performance may vary based on network latency and database load.
- What are the licensing costs associated with this MCP?
- The associated costs depend on the underlying SQL Server instance and its licensing model, which is separate from this MCP. The MCP itself is open-source, based on its GitHub repository.
Install SQL Server
Claude Desktop
Add this to claude_desktop_config.json.
{
"mcpServers": {
"sql-server": {
"command": "npx",
"args": [
"-y",
"@modelcontextprotocol/server-sql-server"
]
}
}
}Cursor
Add this to ~/.cursor/mcp.json.
{
"mcpServers": {
"sql-server": {
"command": "npx",
"args": [
"-y",
"@modelcontextprotocol/server-sql-server"
]
}
}
}VS Code
Add this to your workspace settings.json.
{
"mcp.servers": {
"sql-server": {
"type": "stdio",
"command": "npx",
"args": [
"-y",
"@modelcontextprotocol/server-sql-server"
]
}
}
}Reviews
Sign in to leave a review.
No reviews yet. Be the first!
Discussion(0)
No comments yet.