广告合作
MCP.so
登录

SQL Server MCP for Claude

@shakunvohradeltek

代码仓库

基本信息

分类

AI 与智能体

传输方式

stdio

作者

shakunvohradeltek

关于 SQL Server MCP for Claude

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

SQL Server MCP for Claude 配置

暂无标准配置

该服务器的 README 中没有可解析的 MCP 配置块，请前往代码仓库查看安装说明。

代码仓库

SQL Server MCP for Claude 工具

工具列表暂未提供

当前收录暂时没有可展示的工具列表，不代表服务没有工具。请查阅项目文档了解支持的能力。

工具是从 README 中自动提取的。维护者可以在 ## Tools 标题下列出工具,即可填充这部分内容。

概览

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

常见问题

1

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.

2

Does the integration require ODBC?

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

3

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.

4

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`.

5

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.

评论

AI 与智能体 分类下的更多 MCP 服务器

bsv.cx

Andy Rowe

Timestamp and verify evidence on-chain. Let your agent prove what it saw and when. bsv.cx gives an AI agent verifiable memory. Timestamp a hash of any output, archive a web page as it looked, or fetch a URL with a recei

CrawlForge MCP Server

mysleekdesigns

28-tool MCP server for web scraping, crawling, deep research & autonomous extraction — clean Markdown & structured JSON for Claude, Cursor & any MCP client. 1,000 free one-time credits, local-Ollama LLM support.

2

WordPress MCP Server

miniOrange

miniOrange WordPress MCP Server turns a WordPress site into a Model Context Protocol server, so AI clients like Claude, ChatGPT, Cursor, Gemini and Windsurf can read and edit the site through chat instead of the admin da

scvd.store

seancrecord

scvd.store is an evidence observatory for agentic commerce. Independent signed observation of what other people's endpoints, artifacts and payments actually did among other things. USDC on Base, Arbitrum One, World Chain

2

Quest: Hire a Human

Quest (hireahuman.quest)

Hire a verified local human for small real-world tasks your AI agent can't do: errands, queues, pickups, in-person checks and on-site photos. Your agent posts a quest, local humans send offers, and your user picks one an

广告合作