Enhanced MSSQL

You have a production-ready MCP server for Microsoft SQL Server that lets AI agents access databases securely and without maintaining state. It provides schema discovery, safe querying, and health monitoring, so you can build intelligent data-driven workflows with reliable, read-only access to your MSSQL data.

How to use

Use this MCP server to let AI agents connect to MSSQL databases, discover schemas, and run read-only queries with security safeguards. You will interact with the MCP through an MCP client that communicates via the supported tools. The server enforces read-only access, validates inputs, and returns structured metadata and safe results.

How to install

Prerequisites: Node.js 18+ and access to an MSSQL Server with a read-only user.

Step-by-step commands you should run in your terminal:

# Install dependencies
npm install

# Build the project
npm run build

# Configure your database connection (rename example to real env file if needed)
cp .env.example .env

# Start the server
npm start

# Run tests (requires running MSSQL server)
npm test

Configuration

Configuration is designed to be stateless. You provide connection details at call time, and the AI agent supplies credentials as needed. To integrate with Claude Desktop, add a dedicated MCP server entry that points to the MSSQL connector.

{
  "mcpServers": {
    "mssql": {
      "command": "node",
      "args": ["path/to/mcp-mssql-connector/dist/index.js"]
    }
  }
}

Security

The server emphasizes safety by allowing only read operations, validating inputs, and encrypting connections by default. It includes SQL injection protections, parameterized queries, and automatic query validation to prevent unsafe data access.

Examples

Here are common usage patterns you can perform with the MCP server to explore your MSSQL data set.

Notes

The MCP server exposes tools for database discovery, schema analysis, and safe querying. It runs in a stateless mode and is designed for production-grade monitoring and security.

Troubleshooting

If you encounter issues, verify your MSSQL server connection details, ensure the read-only user has the necessary permissions, and confirm TLS is enabled for encrypted connections.

Available tools

mssql_list_databases

List all accessible databases on the MSSQL server.

mssql_list_tables

List tables in a specific database.

mssql_describe_table

Get detailed table schema information for a given table.

mssql_query

Execute a SELECT query with security validation and metrics.

mssql_sample_data

Retrieve a sample of rows from specified tables for quick analysis.

mssql_get_relationships

Discover foreign key relationships between tables.

mssql_health_check

Monitor server health with real-time performance metrics.

mssql_validate_query

Validate security of a query without executing it.

mssql_bulk_insert

Perform efficient bulk data insertion operations.