MCP Servers

SQL Server MCP

A read-only MCP server for SQL Server database introspection that enables Claude to explore and query databases via tools like listing objects and executing SELECT queries.

README

SQL Server MCP

A read-only MCP (Model Context Protocol) server for SQL Server database introspection. Use with Claude Desktop to let Claude explore and query your SQL Server databases.

Features

List databases, tables, views, stored procedures, and functions
Get object definitions (DDL/source code)
Execute read-only SELECT queries
Search for objects across databases
Read-only by design - all mutation queries are blocked

Installation

# Clone the repo
git clone https://github.com/millelog/sql-server-mcp.git
cd sql-server-mcp

# Install in a virtual environment
python -m venv .venv
source .venv/bin/activate  # On Windows: .venv\Scripts\activate
pip install -e .

Claude Desktop Configuration

Add to your Claude Desktop config file:

Windows: %APPDATA%\Claude\claude_desktop_config.json
macOS: ~/Library/Application Support/Claude/claude_desktop_config.json

{
  "mcpServers": {
    "sql-server": {
      "command": "python",
      "args": ["-m", "sql_server_mcp"],
      "cwd": "C:\\path\\to\\sql-server-mcp",
      "env": {
        "MSSQL_HOST": "your-server",
        "MSSQL_USER": "your-username",
        "MSSQL_PASSWORD": "your-password",
        "MSSQL_DATABASE": "master"
      }
    }
  }
}

Restart Claude Desktop after updating the config.

Configuration Options

Variable	Description	Default
`MSSQL_HOST`	SQL Server hostname	`localhost`
`MSSQL_PORT`	SQL Server port	`1433`
`MSSQL_USER`	Username	-
`MSSQL_PASSWORD`	Password	-
`MSSQL_DATABASE`	Default database	`master`
`MSSQL_CONNECTION_STRING`	Full connection string (overrides above)	-
`MAX_ROWS`	Maximum rows returned	`100`
`QUERY_TIMEOUT`	Query timeout (seconds)	`30`
`ALLOWED_DATABASES`	Comma-separated allowlist	-
`BLOCKED_DATABASES`	Comma-separated blocklist	-

Available Tools

Tool	Description
`list_databases`	List all accessible databases
`list_tables`	List tables in a database
`get_table_definition`	Get CREATE TABLE DDL
`get_table_columns`	Get column metadata
`get_table_indexes`	Get index information
`get_table_relationships`	Get foreign key relationships
`list_views`	List views in a database
`get_view_definition`	Get CREATE VIEW DDL
`list_procedures`	List stored procedures
`get_procedure_definition`	Get CREATE PROCEDURE DDL
`get_procedure_parameters`	Get procedure parameters
`list_functions`	List user-defined functions
`get_function_definition`	Get CREATE FUNCTION DDL
`execute_query`	Run read-only SELECT queries
`get_sample_data`	Get sample rows from a table
`search_objects`	Search for objects by name
`search_definitions`	Search within object definitions
`get_schema_overview`	Get database schema summary (object counts, size)

Development

# Run tests
pytest tests/ -v

# Run with coverage
pytest tests/ --cov=src/sql_server_mcp

License

MIT

Recommended Servers

playwright-mcp

A Model Context Protocol server that enables LLMs to interact with web pages through structured accessibility snapshots without requiring vision models or screenshots.

Official

Featured

TypeScript

Magic Component Platform (MCP)

An AI-powered tool that generates modern UI components from natural language descriptions, integrating with popular IDEs to streamline UI development workflow.

Audiense Insights MCP Server

Enables interaction with Audiense Insights accounts via the Model Context Protocol, facilitating the extraction and analysis of marketing insights and audience data including demographics, behavior, and influencer engagement.

VeyraX MCP

Single MCP tool to connect all your favorite tools: Gmail, Calendar and 40 more.

Official

Featured

Local

graphlit-mcp-server

The Model Context Protocol (MCP) Server enables integration between MCP clients and the Graphlit service. Ingest anything from Slack to Gmail to podcast feeds, in addition to web crawling, into a Graphlit project - and then retrieve relevant contents from the MCP client.

Official

Featured

TypeScript

Kagi MCP Server

An MCP server that integrates Kagi search capabilities with Claude AI, enabling Claude to perform real-time web searches when answering questions that require up-to-date information.

Official

Featured

Python

E2B

Using MCP to run code via e2b.

Official

Featured

Neon Database

MCP server for interacting with Neon Management API and databases

Official

Featured

Exa Search

A Model Context Protocol (MCP) server lets AI assistants like Claude use the Exa AI Search API for web searches. This setup allows AI models to get real-time web information in a safe and controlled way.

Official

Featured

Qdrant Server

This repository is an example of how to create a MCP server for Qdrant, a vector search engine.

Official

Featured