Skip to main content
Glama
millelog

SQL Server MCP

by millelog
OverviewSchemaRelated ServersScoreDiscussions
Python
Remote

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

Related MCP server: mssql-mcp

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

Install Server
A
license - permissive license
A
quality
D
maintenance

How are these scores calculated?

Maintenance

–Maintainers
–Response time
–Release cycle
–Releases (12mo)
Commit activity

Resources

Unclaimed servers have limited discoverability.

Looking for Admin?

If you are the server author, to access and configure the admin panel.

Tools

View all tools

Related MCP Servers

  • MCP SQL Server

    fabriciofs
    A
    license
    -
    quality
    F
    maintenance
    An MCP server for Microsoft SQL Server integration that enables users to query, monitor, and analyze databases directly through Claude. It supports schema exploration, performance analysis, and optional write operations via natural language commands.
    Last updated
    49
    1
    MIT

  • mssql-mcp

    dhipskind253
    A
    license
    A
    quality
    C
    maintenance
    Read-only MCP server for Microsoft SQL Server that retrieves connection details from AWS Secrets Manager, enabling database exploration and querying via natural language.
    Last updated
    12
    17
    MIT

  • MCP SQL Server

    fabriciofs
    A
    license
    -
    quality
    C
    maintenance
    A Model Context Protocol server that enables Claude to query, monitor, and analyze SQL Server databases, with support for schema exploration, performance analysis, and optional write operations.
    Last updated
    41
    1
    MIT

  • mcp-sql

    benamaraissam
    A
    license
    -
    quality
    C
    maintenance
    An extensible read-only MCP server for SQL databases, enabling schema exploration and safe SELECT queries via tools like list_schemas, list_tables, describe_table, and execute_query.
    Last updated
    MIT

View all related MCP servers

Related MCP Connectors

View all MCP Connectors

Latest Blog Posts

MCP directory API

We provide all the information about MCP servers via our MCP API.

curl -X GET 'https://glama.ai/api/mcp/v1/servers/millelog/sql-server-mcp'

If you have feedback or need assistance with the MCP directory API, please join our Discord server