MCP.so
Sign In

SQL Server MCP for Claude

@shakunvohradeltek

Repository

About SQL Server MCP for Claude

This is a MCP Server for Claude-Code to connect to you Microsoft SQL Server

Config

No standard config provided

This server doesn't expose a parseable MCP config block in its README. See the repository for install instructions.

Repository

Tools

No tools detected

We auto-extract tools from the README. The maintainer can list them under a ## Tools heading to populate this section.

Overview

What is SQL Server MCP for Claude?

SQL Server MCP for Claude is a Model Context Protocol integration that enables Claude to directly query and analyze data from a SQL Server database using natural language. It connects via pymssql without requiring ODBC.

How to use SQL Server MCP for Claude?

Run the provided install_sql_mcp.sh script and follow the prompts for connection details. After installation, start Claude with claude and use the @sql execute_sql prefix to ask SQL questions. Verify connectivity with ./run_simple_sql.sh "SELECT 1 AS TestQuery".

Key features of SQL Server MCP for Claude

  • No ODBC required; uses pymssql directly
  • Minimal dependencies and simplified architecture
  • Works with Claude’s MCP system
  • Cross-platform on macOS and Linux
  • One-step installation with smart configuration
  • Preserves existing MCP settings and Claude instructions

Use cases of SQL Server MCP for Claude

  • Ask natural‑language questions about your SQL Server data
  • Explore database schemas before writing queries
  • Rapidly prototype and test SQL queries via Claude
  • Perform interactive data analysis with gradual query complexity

FAQ from SQL Server MCP for Claude

What are the prerequisites for installation?

macOS or Ubuntu Linux, Python 3.7+, FreeTDS (installed automatically), the Claude CLI, and SQL Server credentials with read‑only permissions.

Does the integration require ODBC?

No, it connects directly to SQL Server using pymssql without any ODBC dependency.

How should I secure the database connection for Claude?

Use a dedicated read‑only database user with restricted permissions (e.g., no DROP, DELETE, or table creation). Never use sa or admin accounts in production.

How can I verify the integration is working correctly?

Run ./run_simple_sql.sh "SELECT 1 AS TestQuery" to test direct connectivity. You can also check MCP status with claude /mcp.

What should I do if I see “Connection failed” messages during use?

If queries still return results, these messages are normal and can be ignored. They do not affect functionality.

Frequently asked questions

What are the prerequisites for installation?

macOS or Ubuntu Linux, Python 3.7+, FreeTDS (installed automatically), the Claude CLI, and SQL Server credentials with read‑only permissions.

Does the integration require ODBC?

No, it connects directly to SQL Server using pymssql without any ODBC dependency.

How should I secure the database connection for Claude?

Use a dedicated read‑only database user with restricted permissions (e.g., no DROP, DELETE, or table creation). Never use sa or admin accounts in production.

How can I verify the integration is working correctly?

Run `./run_simple_sql.sh "SELECT 1 AS TestQuery"` to test direct connectivity. You can also check MCP status with `claude /mcp`.

What should I do if I see “Connection failed” messages during use?

If queries still return results, these messages are normal and can be ignored. They do not affect functionality.

Comments

Basic information

Category

AI & Agents

Transports

stdio

Author

shakunvohradeltek

More AI & Agents MCP servers

Orders of Magnitude — x402 API Catalog

OrdersOfMagnitudeLLC

1000+ pay-per-call API endpoints across finance, weather, geography, economic data, agent infrastructure (memory, coordination, secrets, simulation, verification), and NS compute. Payments via x402 protocol on Base/USDC.

F

fhirHydrant

faulkj

Open-source Node.js FHIR MCP server with SMART Backend Services, metadata-aware search/CRUD tools, compact responses, FHIRPath filtering, safe pagination, audit events, and terminology lookup.

14

Heterogent

Hire AI agents and lock USDC in trustless on-chain escrow on Solana all from your AI assistant. Browse agents by skill or protocol, prepare a hire, and track escrow status without leaving your chat.

Lumify Sports Intelligence

Lumify

Agent-ready sports intelligence API: live scores, odds, line movement, public betting splits, and explainable bet confidence — via 16 MCP tools at https://lumify.ai/mcp. Get a free key instantly — no signup, email, or ca

早

早起鸟儿喊真人验真

shenshaoyin

早起鸟儿喊真人验真 is a remote MCP server available at http://121.40.18.232.