広告掲載
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 とエージェント」の他のコンテンツ

Hypnothera

La-Salida

Agent skill: turn what your AI assistant knows about you into a personalized hypnosis session on hypnothera.ai

AskOne: Live Q&A and Polls

phuryn

Run free live audience Q&A and polls from your agent: start an AskOne room, add and launch a poll, approve or hide questions and mark them answered, close the room, then read the questions as a FAQ draft and get the resu

strac-mcp-dlp

strac-io

Detect and redact PII, PHI, PCI and secrets — SSNs, credit cards, passports, API keys and cloud credentials — in text and in local files, using the Strac DLP API. Five tools: redact_text, detect_sensitive_data, detect_fi

3

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

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

広告掲載