How to Connect Microsoft SQL Server to Gemini — via MCP

💡 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 + Gemini

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 Gemini

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.

Gemini CLI reads MCP servers from ~/.gemini/settings.json (or %APPDATA%\gemini\settings.json on Windows). Add:

{
  "mcpServers": {
    "anythingmcp": {
      "httpUrl": "https://cloud.anythingmcp.com/mcp/YOUR_SERVER_ID",
      "headers": { "X-API-Key": "YOUR_MCP_API_KEY" }
    }
  }
}

1. Get your MCP API key from AnythingMCP → MCP Servers → your server → API keys.
2. Save the file and restart gemini.
3. Run /mcp inside the Gemini CLI — Microsoft SQL Server should be listed as available.
4. Vertex AI Studio: pass https://cloud.anythingmcp.com/mcp/YOUR_SERVER_ID to the tools array of your request with the same X-API-Key header.

Available tools

FAQ

Does Gemini 1.5 Pro or 2.x support MCP? Yes — Gemini CLI ≥ 0.4 and Vertex AI tools API both accept MCP httpUrl connectors with custom headers.

Next steps

• Connector landing page
• Connect to Claude
• Connect to ChatGPT
• Connect to Cursor
• Connect to Meta Muse
• Connect to Microsoft Copilot