广告提交登录

Natural Language MCP-MSSQL Client

@david-ruffin

基本信息

分类

数据库

传输方式

stdio

作者

david-ruffin

关于 Natural Language MCP-MSSQL Client

Natural Language SQL Chat Interface using MCP SQL Server

Natural Language MCP-MSSQL Client 配置

使用下面的配置,将此服务器添加到你的 MCP 客户端。

{
  "mcpServers": {
    "MCP-MSSQL-SERVER-WEBAPP": {
      "command": "python",
      "args": [
        "-m",
        "venv",
        "venv"
      ]
    }
  }
}

Natural Language MCP-MSSQL Client 工具

工具列表暂未提供

当前收录暂时没有可展示的工具列表，不代表服务没有工具。请查阅项目文档了解支持的能力。

工具是从 README 中自动提取的。维护者可以在 ## Tools 标题下列出工具,即可填充这部分内容。

概览

What is Natural Language MCP-MSSQL Client?

A client that lets users query Microsoft SQL Server databases using plain English questions through Claude AI, integrating with an MCP-MSSQL server via the Model Context Protocol. It is designed for anyone who wants to interact with SQL databases without writing SQL manually.

How to use Natural Language MCP-MSSQL Client?

Clone the repository, set up a virtual environment, install dependencies from requirements.txt, copy .env.example to .env and fill in database and API credentials. Then run python interactive_client.py for interactive questioning, or python demo_nl_client.py to run predefined questions.

Key features of Natural Language MCP-MSSQL Client

Natural language querying of MS SQL Server databases
MCP integration via FastMCP framework
Uses Anthropic’s Claude API to translate English to SQL
Interactive mode for ad‑hoc questions
Demo mode with predefined example queries

Use cases of Natural Language MCP-MSSQL Client

Ask “How many products are there?” without writing SQL
List customers from a specific state (e.g., California)
Show the most expensive products in the database
Quickly explore order counts or product categories
Demo the system with built‑in example questions

常见问题

1

What prerequisites are needed?

Python 3.8+, the Microsoft ODBC Driver for SQL Server installed, and an Anthropic API key.

2

How do I configure the environment?

Copy `.env.example` to `.env` and fill in your database server, database name, username, password, ODBC driver name, and Anthropic API key.

3

How do I run the client in interactive mode?

After setup, run `python interactive_client.py` and type natural language questions at the prompt.

4

What does demo mode do?

`python demo_nl_client.py` runs several predefined questions automatically, showing the translation to SQL and the results.

5

How does the client connect to the database?

It uses the MCP-MSSQL server (via FastMCP) and the credentials supplied in the `.env` file to access the MS SQL Server database.

评论

数据库分类下的更多 MCP 服务器

Redis

modelcontextprotocol

Model Context Protocol Servers

mcp-server-qdrant: A Qdrant MCP server

An official Qdrant Model Context Protocol (MCP) server implementation

Neon MCP Server

neondatabase-labs

MCP server for interacting with Neon Management API and databases

Dbhub

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

Xata MCP Server

The Xata MCP server lets AI assistants and agents interact with your Xata organizations, projects, and Postgres database branches.