
SQL Server MCP (macOS)
Built for macOS users running SQL Server in Docker, this server connects AI assistants to SQL Server databases through 12 tools covering schema exploration, relationship mapping, and read-only queries. You get list_databases, describe_table, get_table_relationships, search_schema, and execute_query for SELECT statements with automatic timeouts and row limits. It uses the pure JavaScript mssql driver (no native dependencies), supports SQL Server authentication, and caches schema metadata for 60 minutes by default. Install via npx with your connection string in environment variables. Windows users should grab the sibling package that supports Windows Authentication through ODBC drivers.
- transport
- STDIO
- last updated
- Apr 23, 2026
Sponsors
Readme
SQL Server MCP - Cross-Platform Database Integration for AI
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.
🌟 Features
Details
- Repository
- github.com/tharanabope/sql-mcp-mac-windows
- Categories
- Databases, AI & LLM Tools, Cloud & Infrastructure
- Package
@tharanabopearachchi/sql-server-mcp-macos- Transport
- STDIO
- Registry
- MCP registry, active