tharanabope avatar

SQL Server MCP (macOS)

tharanabope/sql-mcp-mac-windows

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

License: MIT TypeScript MCP npm version npm downloads

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


View the full README on GitHub

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

Related Databases MCP servers

View all
1aidancorrell avatarSpark SQLaidancorrell/spark-sql-mcp-serverQuery Spark SQL clusters via Thrift/HiveServer2. Works with Spark, EMR, Hive, Impala.0stars
2infoinlet-marketplace avatarMcp Clickhouseinfoinlet-marketplace/marketplaceRead-only ClickHouse for AI agents — analytics queries, table inspection, sizes, health.0stars
3originchaindb avatarOriginChainDBoriginchaindb/mcp-serverConnect an MCP host to an OriginChainDB tenant through four tools: SQL, vector search, full-text search, and schema discovery.0stars
4bytebase avatarDBHubbytebase/dbhubToken-efficient database MCP server for PostgreSQL, MySQL, MariaDB, SQL Server, Oracle, SQLite3.8Kstars
5runekaagaard avatarMCP Alchemy Serverrunekaagaard/mcp-alchemyA MCP (model context protocol) server that gives the LLM access to and knowledge about relational databases like SQLite, Postgresql, MySQL & MariaDB, Oracle, an403stars
6faucetdb avatarFaucetfaucetdb/faucetSQL database to MCP tools and REST API: PostgreSQL, MySQL, SQL Server, Oracle, SQLite, Snowflake.170stars