SQL Server MCP (macOS) MCP server

by TharanaBope·io.github.TharanaBope/sql-server-mcp-macos·v1.0.4·1 stars

No reviews yet

SQL Server MCP with RAG capabilities for macOS (Docker SQL Server support)

B82/100grade B

Write a review Install

What users say

No reviews yet

Be the first

Safety scan

B82/100

full report

Adoption

New

1 stars42 downloads/wk

Reviews

Write one

Nobody has reviewed SQL Server MCP (macOS) yet.

If you have run it, two minutes of your experience saves the next person an afternoon.

SQL Server MCP (macOS) tools (12, 1 write)

write = sends, deletes, buys or posts

Read from the package source without running it. The installed server may list more.

describe_table
Get detailed schema information about a table including columns, data types, constraints, foreign keys, and indexes. Critical for understanding table structure.
execute_querywrite action
Execute a read-only SELECT query against the database. Automatically limited to prevent large result sets. Only SELECT queries are allowed.
find_column_usage
Find all tables that contain a column with a specific name. Useful for tracking where a field is used across the database.
get_database_overview
Get high-level statistics about a database including table count, view count, procedure count, and schema count.
get_procedure_definition
Get the full SQL definition of a stored procedure.
get_related_tables
Get all tables directly related to a given table through foreign key relationships. Helps understand table dependencies.
get_table_relationships
Get all foreign key relationships for a table (both incoming and outgoing). Shows how tables are connected.
list_databases
List all databases on the SQL Server instance. Useful for discovering what databases are available.
list_stored_procedures
List all stored procedures in a database.
list_tables
List all tables in a specific database with row counts. Essential for understanding database structure.
list_views
List all views in a database.
search_schema
Search across tables, columns, views, and stored procedures by keyword. Perfect for finding where something is implemented.

Public scan report

scanner v0.1.9 · 2026-09-27 · same rubric, same numbers if you re-run it

no findings

Code scan19 source files scanned25/25
–Live reliabilityno gateway calls yet and no remote to proben/a
–Tool poisoningtools not inspected (local package is not executed); not countedn/a
Auth qualitylocal package, no credentials required12/15
Maintenancelast push 158 days ago8/15
Maintainer identityregistry namespace matches repository owner; GitHub account older than a year8/10

Overall 82/100. Components that don't apply are left out of the denominator. Any critical finding is an F.Rubric Appeal a finding JSON

How SQL Server MCP (macOS) compares

Against every graded Databases MCP server, from our own scans and uptime checks. Updated after each scan run.

Safety score: 82/100; higher than 55% of 802 Databases servers
Tools: 12; the typical Databases server has 8
Tools that change things: 8%; typical: 10%. Fewer write tools means less an agent can break
GitHub stars: 1; more than 45% of 602 Databases servers
Downloads a week: 42; more than 29% of 328 Databases servers with a package

What its tools let an agent do: 11 read · 1 run or deploy

Install SQL Server MCP (macOS) in Claude Code, Cursor or VS Code

Runs npx -y @tharanabopearachchi/sql-server-mcp-macos on your machine. Read the scan report first; the gateway never runs local packages.

claude mcp add sql-server-mcp-macos -- npx -y @tharanabopearachchi/sql-server-mcp-macos

Add to Cursor

What the publisher says

From the SQL Server MCP (macOS) repository's README, as published. We do not edit it. Read it on GitHub

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

🔍 Schema Exploration - List databases, tables, views, stored procedures
🔗 Relationship Mapping - Discover foreign key relationships and table dependencies
🔎 Search & Discovery - Global schema search across tables, columns, procedures
⚡ Safe Query Execution - Read-only SELECT queries with automatic timeouts and row limits
🗄️ Schema Caching - Fast retrieval with configurable TTL (default: 60 minutes)
🔐 Security First - Read-only by default, SQL injection prevention, query validation
🖥️ Cross-Platform - Native Windows Authentication & macOS Docker support

🎥 Demo

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!

🚀 Quick Start

This repository contains two platform-specific implementations:

Windows Version → sql-server-mcp/

✅ Windows Authentication (ODBC Driver 17)
✅ SQL Server Authentication
✅ Native msnodesqlv8 driver for optimal performance
📖 Windows Setup Guide

macOS Version → sql-server-mcp-mac/

✅ SQL Server Authentication (Docker required)
✅ Pure JavaScript mssql driver (no native dependencies)
📖 macOS Setup Guide

📦 Installation

🎉 Now Available on MCP Registry!

This server is officially published in the Model Context Protocol Registry:

Windows: io.github.TharanaBope/sql-server-mcp
macOS: io.github.TharanaBope/sql-server-mcp-macos

🚀 Quick Start (Recommended)

No installation needed! Just add to your AI assistant's configuration:

Claude Desktop (Windows)

Config Location: %APPDATA%\Claude\claudedesktopconfig.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"
      }
    }
  }
}

Claude Desktop (macOS)

Config Location: ~/Library/Application Support/Claude/claudedesktopconfig.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"
      }
    }
  }
}

LM Studio Configuration

Config Location: Varies by platform

Windows: %USERPROFILE%\.lmstudio\config.json
macOS: ~/.lmstudio/config.json

Shortened. The full README is on GitHub.

Nothing above is checked by us. What we check is on the safety report.

SQL Server MCP (macOS): common questions

Is SQL Server MCP (macOS) MCP server safe?: Mostly: it is graded B (82/100). Read the SQL Server MCP (macOS) safety report
How do I install SQL Server MCP (macOS)?: It runs on your machine. Copy the Claude Code, Cursor, VS Code or Claude Desktop config from the install section.
Does SQL Server MCP (macOS) need an API key?: Not as far as the registry entry and our scan can tell: no credentials are declared or required.
Is SQL Server MCP (macOS) maintained?: The last commit was 195 days ago (2026-04-23). The latest release is v1.0.4.
What can I use instead of SQL Server MCP (macOS)?: Servers from other publishers that do the same job: DBHub MCP server, Motherduck MCP server and Keboola MCP server.
How does SQL Server MCP (macOS) compare with other Databases MCP servers?: safety score 82/100 (higher than 55% of 802 Databases servers); tools 12 (the typical Databases server has 8); tools that change things 8% (typical: 10%. Fewer write tools means less an agent can break). Full comparison.

Alternatives to SQL Server MCP (macOS)

Same job from other publishers: the closest match first, then the best rated.

DBHub
Token-efficient database MCP server for PostgreSQL, MySQL, MariaDB, SQL Server, Oracle, SQLite
not reviewed
Widely used
A
Motherduck
SQL analytics and data engineering for AI Assistants and IDEs
not reviewed
Established
A
Keboola
Connect your AI assistants to Keboola and expose your data, transformations, SQL queries, ...
not reviewed
Established
A
GeoLens
Read-only access to a self-hosted GeoLens spatial catalog: datasets, features, maps, sandboxed SQL.
not reviewed
Established
B
Faucet
SQL database to MCP tools and REST API: PostgreSQL, MySQL, SQL Server, Oracle, SQLite, Snowflake.
not reviewed
Established
A