Mcp Sqlserver
@bilims
About Mcp Sqlserver
No overview available yet
Config
Add this server to your MCP-compatible client using the configuration below.
{
"mcpServers": {
"mcp-sqlserver": {
"command": "npx",
"args": [
"-y",
"@bilims/mcp-sqlserver"
],
"env": {
"SQLSERVER_HOST": "your-server-host",
"SQLSERVER_DATABASE": "your-database",
"SQLSERVER_USERNAME": "your-username",
"SQLSERVER_PASSWORD": "your-password"
}
}
}
}Tools
No tools detected
Fetch the live tool list by running this server in a temporary sandbox using the button above.
Overview
What is Mcp Sqlserver?
Mcp Sqlserver is a Model Context Protocol (MCP) server that enables AI agents to securely interact with Microsoft SQL Server databases. It provides CRUD operations, schema introspection, stored procedure execution, transaction management, and bulk operations for production environments.
How to use Mcp Sqlserver?
Install and configure via NPX (recommended), global npm installation, or from source. Create a .env file with SQL Server credentials and add the server configuration (command, args, env) to your Claude Desktop MCP settings (claude_desktop_config.json). The server exposes 22 tools accessible from any MCP‑compatible client.
Key features of Mcp Sqlserver
- Complete CRUD operations (SELECT, INSERT, UPDATE, DELETE)
- Schema introspection for databases, tables, columns, and indexes
- Stored procedure execution with parameters and multiple result sets
- Transaction management with isolation levels and savepoints
- High‑performance bulk insert, batch update/delete, and CSV/JSON import
- All queries use parameterized inputs to prevent SQL injection
Use cases of Mcp Sqlserver
- AI‑powered data analysis and reporting on SQL Server databases
- Automated database maintenance and schema exploration
- Intelligent application backends that query and modify data on demand
- Bulk data loading and transformation tasks via AI agents
- Secure, controlled database operations within MCP‑compatible chat assistants
FAQ from Mcp Sqlserver
What are the runtime requirements?
Node.js 20+, TypeScript 5.0+, and Microsoft SQL Server 2016+ are required.
How is data kept secure?
All queries use parameterized inputs to prevent SQL injection, DDL operations are blocked in custom queries, and connections include validation, health checks, and timeout controls.
Where does the server store configuration?
Database credentials and connection pool settings are stored in a .env file or passed as environment variables in the MCP client configuration.
Which transports are supported?
The server uses the standard MCP transport. It is designed for use with Claude Desktop and any MCP‑compatible client.
What is the maximum number of tools available?
22 tools are provided, covering core database operations, stored procedures, transaction management, and bulk operations.
Frequently asked questions
What are the runtime requirements?
Node.js 20+, TypeScript 5.0+, and Microsoft SQL Server 2016+ are required.
How is data kept secure?
All queries use parameterized inputs to prevent SQL injection, DDL operations are blocked in custom queries, and connections include validation, health checks, and timeout controls.
Where does the server store configuration?
Database credentials and connection pool settings are stored in a `.env` file or passed as environment variables in the MCP client configuration.
Which transports are supported?
The server uses the standard MCP transport. It is designed for use with Claude Desktop and any MCP‑compatible client.
What is the maximum number of tools available?
22 tools are provided, covering core database operations, stored procedures, transaction management, and bulk operations.
Basic information
More Databases MCP servers
Local YDB MCP
astandrikSafety-first stdio MCP server with 38 tools for operating Docker-based local-ydb environments locally or over SSH.
Fund Momentum MCP Server
schneidavieFund Momentum MCP Server — VC intelligence for AI assistants. 1000+ active VC funds, live investor signals, AI-powered startup matching.
Elasticsearch/OpenSearch MCP Server
cr7258A Model Context Protocol (MCP) server implementation that provides Elasticsearch and OpenSearch interaction.
mcp_mysql_server
xwb602625136Model Context Protocol (MCP) server that supports secure interaction with MySQL databases and has anomaly analysis capabilities.更加牛逼！更加好用！不仅止于mysql的增删改查功能； 还包含了数据库异常分析能力；且便于开发者们进行个性化的工具扩展
Postgres Mcp
crystaldbaPostgres MCP Pro provides configurable read/write access and performance analysis for you and your AI agents.
Comments