MS SQL MCP Server

MCPOpen SourceGPL-3.058.0

by dperussina • Data & Databases

A lightweight bridge that lets AI assistants discover, inspect, and run read-only queries against Microsoft SQL Server databases without writing integration code.

Example Use Cases

1
Discover and navigate MS SQL Server schemas and table structures before composing queries.
2
Run safe, read-only queries with support for pagination and large-result handling (saved JSON results).
3
Convert natural language requests into SQL Server-compatible queries and integrate with desktop or IDE assistant workflows (Claude, Cursor).

Description

This MCP server exposes tools for discovering database schema, viewing table details, and executing safe read-only SQL Server queries, including pagination and result storage. It integrates with AI assistant workflows (e.g., Claude Desktop, Cursor) so agents can generate and run SQL from natural language. It emphasizes safety (read-only by default), local credential storage, and ease of use for non-developers.

Capabilities(33 total)

Tools (33)

list_connections

List all available named database connections configured in the server

test_connection

Test the database connection and return basic server information

connectionString:stringconnectionName:string

list_databases

List all databases available on the SQL Server instance

connectionString:stringconnectionName:string

list_tables

List all tables in the connected database

connectionString:stringconnectionName:stringschema:string

describe_table

Get detailed schema information for a specific table including columns, data types, and constraints

connectionString:stringconnectionName:stringtableName:string*schema:string

Quick Actions

View on GitHub

Security

Scanned 2 month(s) ago

Risk Level

MODERATE

Can modify files, state, or send data externally

Trust Score

C56/100

5/17 checks passed

Scores are informational only and provided “as is” without warranty. AgentHotspot assumes no liability for actions taken based on these ratings.

Quick Stats

Service TypeMCP

Pricing ModelFree

Capabilities33 Tools / 0 Prompts / 0 Resources

Ownerdperussina

CategoryData & Databases

DependenciesStandalone

Set Your Username