MCP.so
Sign In

MCP SQL Server

@dennismartis

Repository

About MCP SQL Server

No overview available yet

#sql-mcp-server#sql-database#conversational-ai

Basic information

Category

Databases

Runtime

python

Transports

stdio

Publisher

dennismartis

Config

Add this server to your MCP-compatible client using the configuration below.

{
  "mcpServers": {
    "sql_mcp_server": {
      "command": "python",
      "args": [
        "mcp_sql_server.py"
      ]
    }
  }
}

Tools

No tools detected

We auto-extract tools from the README. The maintainer can list them under a ## Tools heading to populate this section.

Overview

What is MCP SQL Server?

MCP SQL Server is a FastMCP server that exposes Microsoft SQL Server database operations through a conversational AI interface, allowing users to query and manipulate data using natural language.

How to use MCP SQL Server?

Install Python dependencies (pip install pyodbc asyncio fastmcp), ensure Microsoft SQL Server and ODBC Driver 17 for SQL Server are available, then configure the connection parameters (SERVER and DATABASE) in the script. Run the server with python mcp_sql_server.py.

Key features of MCP SQL Server

  • Execute SQL queries and view results
  • List available tables in the database
  • Describe table structure with column names and data types
  • Execute INSERT, UPDATE, DELETE operations
  • List all ODBC drivers on the system
  • Display database information and server version

Use cases of MCP SQL Server

  • Interact with SQL Server databases through a conversational AI interface
  • Quickly explore database schema without manual SQL queries
  • Perform CRUD operations via natural language instructions
  • Retrieve server and database metadata for administration

FAQ from MCP SQL Server

What are the system requirements for MCP SQL Server?

Python 3.7+, pyodbc, asyncio, FastMCP, Microsoft SQL Server, and ODBC Driver 17 for SQL Server.

How does MCP SQL Server handle database connections?

The server uses Windows Authentication ("Trusted_Connection=yes") and manages the connection via a lifecycle context manager that handles setup and teardown.

What should I do if I get a connection error?

Verify the SQL Server instance name, ensure the server is running, and confirm that ODBC Driver 17 for SQL Server is installed.

Does MCP SQL Server support any authentication besides Windows Authentication?

The README only documents Windows Authentication; no other authentication methods are mentioned.

How does MCP SQL Server prevent blocking during database operations?

Database operations run in a separate thread using asyncio.get_event_loop().run_in_executor() to avoid blocking the main event loop.

Comments

More Databases MCP servers

Elasticsearch/OpenSearch MCP Server

cr7258

A Model Context Protocol (MCP) server implementation that provides Elasticsearch and OpenSearch interaction.

295

ClickHouse MCP Server

ClickHouse

Connect ClickHouse to your AI assistants.

818

MCP Server for MySQL based on NodeJS

benborla

A Model Context Protocol server that provides read-only access to MySQL databases. This server enables LLMs to inspect database schemas and execute read-only queries.

1.9K

Sqlite

modelcontextprotocol

Model Context Protocol Servers

88.1K

Dbhub

bytebase

Zero-dependency, token-efficient database MCP server for Postgres, MySQL, SQL Server, MariaDB, SQLite.

3.1K