Connect SQL Server to Claude: MSSQL MCP Server, Read-Only

💡 No install? Use cloud.anythingmcp.com directly. Sign in, click Connectors → Microsoft SQL Server, paste your credentials, mint an MCP API key — done. No Docker, no git clone, no local server.

Microsoft SQL Server + Claude

Query a Microsoft SQL Server database directly: list tables, describe columns and run read-only T-SQL. Supports SQL Server and Windows (NTLM) authentication. Installs read-only.

Prerequisites

See the full setup instructions baked into the connector (visible in the in-app store when you select the connector). The required environment variables for this connector are:

MSSQL_HOST, MSSQL_PORT, MSSQL_DATABASE, MSSQL_USER, MSSQL_PASSWORD

Step 1 — Get credentials

Setup

1. Create a login and a database user with only db_datareader:

   CREATE LOGIN amcp_reader WITH PASSWORD = 'change-me';
   USE sales;
   CREATE USER amcp_reader FOR LOGIN amcp_reader;
   ALTER ROLE db_datareader ADD MEMBER amcp_reader;
   

2. Set MSSQL_HOST, MSSQL_PORT (1433), MSSQL_DATABASE, MSSQL_USER and MSSQL_PASSWORD.

Windows authentication: set MSSQL_DOMAIN as well and the engine switches to NTLM instead of SQL Server auth. Leave it blank for a SQL login.

…(continued in the in-app connector instructions)

Step 2 — Install the adapter

curl -fsSL https://raw.githubusercontent.com/HelpCode-ai/anythingmcp/main/docker-compose.quickstart.yml -o docker-compose.yml
printf 'JWT_SECRET=%s\nENCRYPTION_KEY=%s\n' "$(openssl rand -hex 32)" "$(openssl rand -hex 32)" > .env
docker compose up -d

Step 3 — Add the connector in Claude

Your server URL: in AnythingMCP, open MCP Servers → the server this connector is on, and copy its URL (https://cloud.anythingmcp.com/mcp/…). Use it wherever this guide shows YOUR_SERVER_ID.

Recommended path — works on claude.ai web without editing any config file.

1. In Claude, open Customize → Connectors.
2. Click +, then Add custom connector.
3. Enter a name, e.g. Microsoft SQL Server, and the remote MCP server URL https://cloud.anythingmcp.com/mcp/YOUR_SERVER_ID, then click Add.
4. Click Connect and sign in to AnythingMCP (OAuth) to allow access.

All tools below appear in your chat — start typing prompts.

Available tools

FAQ

Is there an MCP server for SQL Server? Yes. AnythingMCP's SQL Server connector gives Claude, ChatGPT and Copilot five tools: list tables, describe a table, find columns, run a query and example queries. It runs on AnythingMCP Cloud or self-hosted next to your database.

Can Claude change data in SQL Server? No, by default. The query tool only runs a single SELECT and blocks INSERT, UPDATE, DELETE, DDL and stacked statements. Give the login SELECT rights only as well.

Does it support Windows authentication? Yes, SQL Server logins and Windows (NTLM) accounts both work; see Step 1.

My SQL Server is on the internal network. Does that work? Yes, with a self-hosted AnythingMCP on the same network and the server's hostname in SSRF_ALLOWED_HOSTS. AnythingMCP Cloud can only reach a server exposed to the internet.

Does it work with Claude Code as well as Claude Desktop? Yes. Add the MCP server URL once in Claude; Claude Code can also add it with claude mcp add --transport http.

Next steps

• sql-to-mcp on GitHub: the database connectors with a five-minute Docker demo

• Database to MCP: PostgreSQL, MySQL, Oracle and MongoDB too

• Connector landing page

• Connect to ChatGPT

• Connect to Cursor

• Connect to Gemini

• Connect to Meta Muse

• Connect to Microsoft Copilot