MCP.so
ログイン

SQL Server MCP for Claude

@shakunvohradeltek

リポジトリ

SQL Server MCP for Claude について

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

基本情報

カテゴリ

AI とエージェント

ランタイム

shell

トランスポート

stdio

公開者

shakunvohradeltek

設定

標準の設定はありません

このサーバーの README には解析可能な MCP 設定ブロックが含まれていません。インストール手順はリポジトリをご確認ください。

リポジトリ

ツール

ツールは検出されませんでした

ツールは 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

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.

コメント

「AI とエージェント」の他のコンテンツ

Web Agent Protocol

OTA-Tech-AI

🌐Web Agent Protocol (WAP) - Record and replay user interactions in the browser with MCP support

500

Solon Ai

opensolon

Java AI application development framework (supports LLM-tool,skill; RAG; MCP; Agent-ReAct,Team-Agent). Compatible with java8 ~ java25. It can also be embedded in SpringBoot, jFinal, Vert.x, Quarkus, and other frameworks.

416

MCP-LLM Bridge

patruff

Bridge between Ollama and MCP servers, enabling local LLMs to use Model Context Protocol tools

976

🔎 GPT Researcher

assafelovic

An autonomous agent that conducts deep research on any data using any LLM providers

28.1K

MCP Client for Ollama (ollmcp)

jonigl

Harness the power of local LLMs with this TUI MCP Client for Ollama. Featuring all core MCP primitives (tools, prompts, resources), agent mode, multi-server, model switching, streaming responses, human-in-the-loop, thinking mode, model params config, system prompts, and saved pre

768