SQL Server MCP (macOS)
NPM · @THARANABOPEARACHCHI/SQL-SERVER-MCP-MACOS · SCANNED SEP 20
SQL Server MCP with RAG capabilities for macOS (Docker SQL Server support)
Available components
How this component scores in each security and reliability category. Every signal is checked automatically from public evidence about the published package, including repeated runs of it in an isolated sandbox, and we only credit what we can confirm. How we score → Why this is hard to score →
Supply Chain Security98
- No malware found by supply-chain analysis.Pass
- No known CVEs affecting this package version or its production dependencies.Pass
- No install/post-install scripts declared.Pass
- 55 of 164 dependencies flagged as unhealthy. View diagnostics → Partial
Provenance & Transparency45
- Source repository is publicly reachable at the declared URL. View diagnostics → Pass
- Provenance check failed: no build-provenance attestation is published. See how to fix → View diagnostics → Fail
- Clear OSI-approved license (MIT).Pass
- Actively maintained (last published 149 days ago).Pass
- Disclosure check failed: no security disclosure policy was found in the source repository. See how to fix → Fail
Schema Quality & AI Usability81
- AI-judged instruction clarity (excellent).Pass
- Tool/resource definitions use about 564 tokens (~47/item across 12 items; 12 tools + 0 resources), lean.Pass
- Usage-examples check failed: none of the tools include examples. See how to fix → Fail
Stability & Change Management87
- Stability observed for 26 of 30 days with no destabilising changes; credit accrues until the full window elapses.Partial
Tool Coverage100
- 100% of tools have a non-trivial description (not blank, and not just the tool's name).Pass
- 100% of tool parameters carry a description.Pass
Tool Safety75
- No prompt-injection markers were found in the server instructions, tool names or descriptions we captured.Pass
- 0 of 1 tool(s) whose name or description implies an irreversible operation declare an MCP destructiveHint annotation; "execute_query" implies "execute" and declares no destructiveHint at all, which the MCP spec reads as destructive by default. See how to fix → Fail
- An AI judge read all 12 captured unit(s) of tool text and found none that tries to manipulate the model reading it.Pass
Capabilities100
- Implements a supported MCP spec version (2025-11-25); the latest is 2026-07-28.Pass
How do I install the SQL Server MCP (macOS) server?
SQL Server MCP (macOS) runs locally as an npm package, launched with npx -y @tharanabopearachchi/sql-server-mcp-macos. Ready-made configuration for Claude, Cursor, VS Code, Codex and 5 more is on this page, copied from each client's own documentation.
npm · @tharanabopearachchi/sql-server-mcp-macos
claude mcp add tharanabope-sql-server-mcp-macos -- npx -y @tharanabopearachchi/sql-server-mcp-macos
{
"mcpServers": {
"tharanabope-sql-server-mcp-macos": {
"command": "npx",
"args": [
"-y",
"@tharanabopearachchi/sql-server-mcp-macos"
]
}
}
} {
"servers": {
"tharanabope-sql-server-mcp-macos": {
"command": "npx",
"args": [
"-y",
"@tharanabopearachchi/sql-server-mcp-macos"
]
}
}
} codex mcp add tharanabope-sql-server-mcp-macos -- npx -y @tharanabopearachchi/sql-server-mcp-macos
{
"$schema": "https://opencode.ai/config.json",
"mcp": {
"tharanabope-sql-server-mcp-macos": {
"type": "local",
"command": [
"npx",
"-y",
"@tharanabopearachchi/sql-server-mcp-macos"
],
"enabled": true
}
}
} openclaw mcp add tharanabope-sql-server-mcp-macos --command npx --arg -y --arg @tharanabopearachchi/sql-server-mcp-macos
mcp_servers:
tharanabope-sql-server-mcp-macos:
command: "npx"
args: ["-y", "@tharanabopearachchi/sql-server-mcp-macos"] {
"McpServers": {
"tharanabope-sql-server-mcp-macos": {
"Transport": "stdio",
"Command": "npx",
"Arguments": [
"-y",
"@tharanabopearachchi/sql-server-mcp-macos"
]
}
}
} assistant mcp add tharanabope-sql-server-mcp-macos -t stdio -c npx -a -y @tharanabopearachchi/sql-server-mcp-macos
{
"mcpServers": {
"tharanabope-sql-server-mcp-macos": {
"command": "npx",
"args": [
"-y",
"@tharanabopearachchi/sql-server-mcp-macos"
]
}
}
} Every change we have recorded for this component, newest first. Security-relevant changes are always shown. ▲ marks a change for the better, ▼ a change for the worse; unmarked changes are neutral.
- 20 Sept 26 +1
No change was recorded against any check on this day. Stability & Change Management went from 83 to 87. That category is still filling its 30-day observation window: 25 days of observed history at the previous scan, 26 at this one. The score rises as the window fills, whether or not the server changes.
- 18 Sept 26 −2
- Stability: pass → 0.80 functional
- 17 Sept 26 0
- Stability: 0.97 → pass security
- 15 Sept 26 +1
No change was recorded against any check on this day. Stability & Change Management went from 90 to 93. That category is still filling its 30-day observation window: 27 days of observed history at the previous scan, 28 at this one. The score rises as the window fills, whether or not the server changes.
- 13 Sept 26 +1
No change was recorded against any check on this day. Stability & Change Management went from 83 to 87. That category is still filling its 30-day observation window: 25 days of observed history at the previous scan, 26 at this one. The score rises as the window fills, whether or not the server changes.
- 11 Sept 26 −2
- Stability: pass → 0.80 functional
- 10 Sept 26 0
- Stability: 0.97 → pass security
- 8 Sept 26 +1
No change was recorded against any check on this day. Stability & Change Management went from 90 to 93. That category is still filling its 30-day observation window: 27 days of observed history at the previous scan, 28 at this one. The score rises as the window fills, whether or not the server changes.
Diagnostic detail from the automated scan of this channel: what the scanner observed at each step, so you can see exactly where a check passed or failed. It is informational only and never changes the trust score.
Captured 20 Sept 2026 · Analysed npm/@tharanabopearachchi/sql-server-mcp-macos@1.0.4
Provenance No attestation
The registry publishes no build provenance for this version, so there is nothing to verify.
| Result | No attestation |
|---|---|
| Ecosystem | npm |
Background: How many MCP packages publish verified provenance →
Dependencies 164 packages
| Packages resolved | 164 |
|---|---|
| Stale | 55 |
| Tree resolution | Complete |
Background: SBOMs and build attestations, explained →
The tools this component advertises to a client, with an estimated token cost for each. Expand a tool to see its parameters and schema. The per-tool counts are indicative and are not scored directly; the schema's total context footprint is one signal in Schema Quality & AI Usability. A tool's description is untrusted text the model reads on every call, which is what makes this list a security surface and not just an inventory: how tool poisoning works →
describe_table ~68
Get detailed schema information about a table including columns, data types, constraints, foreign keys, and indexes. Critical for understanding table structure.
| Name | Type | Req | Description |
|---|---|---|---|
| database | string | yes | Name of the database |
| tableName | string | yes | Name of the table (can include schema, e.g., dbo.Users) |
No output schema declared.
No examples provided.
execute_query ~55
Execute a read-only SELECT query against the database. Automatically limited to prevent large result sets. Only SELECT queries are allowed.
| Name | Type | Req | Description |
|---|---|---|---|
| database | string | yes | Name of the database |
| query | string | yes | SQL SELECT query to execute |
No output schema declared.
No examples provided.
find_column_usage ~58
Find all tables that contain a column with a specific name. Useful for tracking where a field is used across the database.
| Name | Type | Req | Description |
|---|---|---|---|
| columnName | string | yes | Exact column name to search for |
| database | string | yes | Name of the database |
No output schema declared.
No examples provided.
get_database_overview ~42
Get high-level statistics about a database including table count, view count, procedure count, and schema count.
| Name | Type | Req | Description |
|---|---|---|---|
| database | string | yes | Name of the database |
No output schema declared.
No examples provided.
get_procedure_definition ~44
Get the full SQL definition of a stored procedure.
| Name | Type | Req | Description |
|---|---|---|---|
| database | string | yes | Name of the database |
| procedureName | string | yes | Name of the stored procedure |
No output schema declared.
No examples provided.
get_related_tables ~51
Get all tables directly related to a given table through foreign key relationships. Helps understand table dependencies.
| Name | Type | Req | Description |
|---|---|---|---|
| database | string | yes | Name of the database |
| tableName | string | yes | Name of the table |
No output schema declared.
No examples provided.
get_table_relationships ~53
Get all foreign key relationships for a table (both incoming and outgoing). Shows how tables are connected.
| Name | Type | Req | Description |
|---|---|---|---|
| database | string | yes | Name of the database |
| tableName | string | yes | Name of the table |
No output schema declared.
No examples provided.
list_databases ~47
List all databases on the SQL Server instance. Useful for discovering what databases are available.
| Name | Type | Req | Description |
|---|---|---|---|
| includeSystem | boolean | – | Include system databases (master, tempdb, model, msdb) |
No output schema declared.
No examples provided.
list_stored_procedures ~31
List all stored procedures in a database.
| Name | Type | Req | Description |
|---|---|---|---|
| database | string | yes | Name of the database |
No output schema declared.
No examples provided.
list_tables ~36
List all tables in a specific database with row counts. Essential for understanding database structure.
| Name | Type | Req | Description |
|---|---|---|---|
| database | string | yes | Name of the database |
No output schema declared.
No examples provided.
list_views ~26
List all views in a database.
| Name | Type | Req | Description |
|---|---|---|---|
| database | string | yes | Name of the database |
No output schema declared.
No examples provided.
search_schema ~53
Search across tables, columns, views, and stored procedures by keyword. Perfect for finding where something is implemented.
| Name | Type | Req | Description |
|---|---|---|---|
| database | string | yes | Name of the database |
| searchTerm | string | yes | Search term or keyword |
No output schema declared.
No examples provided.
What is the SQL Server MCP (macOS) server?
SQL Server MCP (macOS) is listed in the public MCP registry as io.github.TharanaBope/sql-server-mcp-macos. SQL Server MCP with RAG capabilities for macOS (Docker SQL Server support). This page covers its npm package (@tharanabopearachchi/sql-server-mcp-macos).
Is the SQL Server MCP (macOS) server safe to use?
SQL Server MCP (macOS) scores 82 out of 100 on VerifyMCP. We found no known CVEs affecting it as of 20 September 2026. It declares no install or post-install scripts. That is a record of what we were able to check automatically, not an endorsement. The category breakdown on this page shows every signal behind the number, including the ones we could not confirm.
What tools does the SQL Server MCP (macOS) server expose?
SQL Server MCP (macOS) exposes 12 tools: list_databases, list_tables, describe_table, get_table_relationships, search_schema, and 7 more. Their descriptions and schemas cost roughly 564 tokens of context every time the server is loaded.
Is the SQL Server MCP (macOS) server still maintained?
SQL Server MCP (macOS) is still listed as active in the MCP registry. We last reached this channel on 20 September 2026. Those dates come from our own scans of the registry and the channel itself, not from anything the publisher announced.
What licence is the SQL Server MCP (macOS) server under?
SQL Server MCP (macOS) declares the MIT licence, which is OSI-approved. That covers the source only, and says nothing about the cost of any service it calls.