Skip the install. Get this working in under 2 minutes.
Start a free trial on cloud.anythingmcp.com, add the Microsoft SQL Server in one click, then point your AI client (Claude, ChatGPT, Copilot or Cursor) at the generated MCP endpoint. No Docker, no git clone, zero engineering experience required.
Summary
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.
Try asking
Example prompts for Microsoft SQL Server
Click any prompt to copy it. Paste into Claude, ChatGPT, Cursor, Gemini, Copilot or OpenClaw to run it against this connector.
Claude is AI and can make mistakes. Please double-check responses.
💡 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
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.
Setup
Setup
- 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; - Set
MSSQL_HOST,MSSQL_PORT(1433),MSSQL_DATABASE,MSSQL_USERandMSSQL_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)
Prerequisites: MSSQL_HOST, MSSQL_PORT, MSSQL_DATABASE, MSSQL_USER, MSSQL_PASSWORD
Install the connector locally
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
Open http://localhost:3000/connectors/store, pick Microsoft SQL Server and paste in the env vars listed under Prerequisites.
Available tools
| Tool | What it does |
|---|---|
mssql_list_tables | List the tables and views in the database with their schema and, where the server tracks it, an approximate row count |
mssql_describe_table | Describe one table: every column with its data type, nullability and default |
mssql_find_columns | Find columns across every table whose name matches a pattern — the fast way to locate where customer e-mail addresses, IBANs or order number |
mssql_query | Run a read-only SQL statement against Microsoft SQL Server and return up to 1000 rows |
mssql_query_examples | Show worked example queries for Microsoft SQL Server: how to list schemas, find large tables, inspect indexes and check what is running righ |
Next steps
Was this guide helpful?