에이전트 강화
게시자의 자체 명령입니다. PlugMCP 엔드포인트가 아닙니다.
Host a copy with our keys and logs.
npx -y @tharanabopearachchi/[email protected]Claude Code에는 로컬 명령용 설치 링크가 없습니다. 아래 명령을 복사해 터미널에서 실행합니다.
claude mcp add io.github.tharanabope-sql-server-mcp-macos -- npx -y @tharanabopearachchi/sql-server-mcp-macos@1.0.4터미널에서 실행합니다.
{ "mcpServers": { "io.github.tharanabope-sql-server-mcp-macos": { "command": "npx", "args": [ "-y", "@tharanabopearachchi/[email protected]" ] } }}claude_desktop_config.json
원격 URL인가요, 내 컴퓨터에서 실행하는 명령인가요? 두 설치 방식의 차이
PlugMCP에서 실행
A new server you create. It is not this listing's official endpoint. Use the publisher install when you want their URL and their credentials.
실행A Model Context Protocol (MCP) server implementation for SQL Server that enables AI assistants to explore and query SQL Server databases through natural language. Built as a RAG (Retrieval-Augmented Generation) system optimized for database knowledge exploration.
See SQL Server MCP in action with AI assistant integration:
Note: Watch how natural language queries instantly explore database schemas, find relationships, and retrieve data - all without leaving your AI assistant!
This repository contains two platform-specific implementations:
sql-server-mcp/msnodesqlv8 driver for optimal performancesql-server-mcp-mac/mssql driver (no native dependencies)This server is officially published in the Model Context Protocol Registry:
io.github.TharanaBope/sql-server-mcpio.github.TharanaBope/sql-server-mcp-macosNo installation needed! Just add to your AI assistant's configuration:
Config Location: %APPDATA%\Claude\claude_desktop_config.json
{
"mcpServers": {
"sql-server": {
"command": "npx",
"args": ["-y", "@tharanabopearachchi/sql-server-mcp@latest"],
"env": {
"SQL_SERVER": "localhost",
"SQL_DATABASE": "master",
"SQL_USE_WINDOWS_AUTH": "true"
}
}
}
}
Config Location: ~/Library/Application Support/Claude/claude_desktop_config.json
{
"mcpServers": {
"sql-server": {
"command": "npx",
"args": ["-y", "@tharanabopearachchi/sql-server-mcp-macos@latest"],
"env": {
"SQL_SERVER": "localhost",
"SQL_DATABASE": "master",
"SQL_USE_WINDOWS_AUTH": "false",
"SQL_USERNAME": "sa",
"SQL_PASSWORD": "your_password"
}
}
}
}
Config Location: Varies by platform
%USERPROFILE%\.lmstudio\config.json~/.lmstudio/config.json{
"mcpServers": {
"sql-server": {
"command": "npx",
"args": ["-y", "@tharanabopearachchi/sql-server-mcp@latest"],
"env": {
"SQL_SERVER": "localhost",
"SQL_DATABASE": "master",
"SQL_USE_WINDOWS_AUTH": "true",
"SQL_USERNAME": "",
"SQL_PASSWORD": ""
}
}
}
}
Config Location: ~/.continue/config.json
{
"experimental": {
"modelContextProtocolServers": [
{
"transport": {
"type": "stdio",
"command": "npx",
"args": ["-y", "@tharanabopearachchi/sql-server-mcp@latest"]
},
"env": {
"SQL_SERVER": "localhost",
"SQL_DATABASE": "master",
"SQL_USE_WINDOWS_AUTH": "true"
}
}
]
}
}
Config Location: Cursor Settings → Features → Model Context Protocol
{
"mcpServers": {
"sql-server": {
"command": "npx",
"args": ["-y", "@tharanabopearachchi/sql-server-mcp@latest"],
"env": {
"SQL_SERVER": "localhost",
"SQL_DATABASE": "master",
"SQL_USE_WINDOWS_AUTH": "true"
}
}
}
}
Config Location: VS Code Settings → Cline → MCP Settings
{
"mcpServers": {
"sql-server": {
"command": "npx",
"args": ["-y", "@tharanabopearachchi/sql-server-mcp@latest"],
"env": {
"SQL_SERVER": "localhost",
"SQL_DATABASE": "master",
"SQL_USE_WINDOWS_AUTH": "true"
}
}
}
}
Restart your AI assistant and you're ready to go!
For development or local modifications:
cd sql-server-mcp
npm install
npm run build
cd sql-server-mcp-mac
npm install
npm run build
The server provides 12 powerful tools for database exploration:
list_databases - Discover all available databaseslist_tables - View tables with row countsdescribe_table - Get detailed schema (columns, types, constraints, indexes)list_views - List all viewslist_stored_procedures - List stored procedures with metadataget_procedure_definition - Get full SQL definitionget_database_overview - High-level statisticsget_table_relationships - Get foreign key relationships (incoming & outgoing)get_related_tables - Find directly connected tablessearch_schema - Search across tables, columns, views, proceduresfind_column_usage - Find all tables containing a specific columnexecute_query - Execute read-only SELECT queries safelyOnce configured, you can ask your AI assistant:
"What databases are available on this server?"
"Show me all tables in the Sales database"
"What's the schema of the Orders table?"
"Find all tables that reference the Customers table"
"Search for any columns related to 'email'"
"Execute: SELECT TOP 10 * FROM Products ORDER BY Price DESC"
Both versions use environment variables for configuration:
SQL_SERVER=localhost
SQL_DATABASE=master
SQL_PORT=1433
SQL_USE_WINDOWS_AUTH=true # Windows only
SQL_USERNAME= # For SQL Auth
SQL_PASSWORD= # For SQL Auth
QUERY_TIMEOUT=30
MAX_RESULT_ROWS=1000
ENABLE_SCHEMA_CACHE=true
CACHE_TTL_MINUTES=60
See platform-specific READMEs for detailed configuration instructions.
MCP/
├── sql-server-mcp/ # Windows implementation
│ ├── src/
│ │ ├── index.ts # MCP server entry point
│ │ ├── database/ # Connection, caching, queries
│ │ ├── tools/ # 12 MCP tools
│ │ └── types/ # TypeScript interfaces
│ ├── dist/ # Compiled output
│ ├── package.json
│ └── README.md # Windows documentation
│
├── sql-server-mcp-mac/ # macOS implementation
│ ├── src/ # Same structure as Windows
│ └── README.md # macOS documentation
│
├── LICENSE # MIT License
└── README.md # This file
Contributions are welcome! Please feel free to submit a Pull Request. For major changes, please open an issue first to discuss what you would like to change.
This project is licensed under the MIT License - see the LICENSE file for details.
sql-server-mcp/README.mdsql-server-mcp-mac/README.mdTROUBLESHOOTING.md filesMade with ❤️ for the MCP community
⭐ Star this repo if you find it useful! 🐛 Report bugs via Issues 💬 Questions? Check the Discussions
SQL Server MCP with RAG capabilities for macOS (Docker SQL Server support)
{ "mcpServers": { "io.github.tharanabope-sql-server-mcp-macos": { "command": "npx", "args": [ "-y", "@tharanabopearachchi/[email protected]" ] } }}도구
아직 도구 목록이 없습니다. 원격 서버는 첫 상태 확인 후에 도구 목록이 생깁니다.
FAQ
이 페이지에서 Cursor, Claude Desktop, Claude Code 또는 VS Code용 stdio 설정을 복사합니다. PlugMCP 프록시가 아니라 게시자의 설치 방식을 사용합니다.
이 레코드에는 필수 환경 변수가 등록되어 있지 않습니다.
SQL Server MCP (macOS)은(는) stdio를 통해 로컬에서 실행됩니다.
마지막 확인: 2026-11-09. SQL Server MCP with RAG capabilities for macOS (Docker SQL Server support)