Natural Language MCP-MSSQL Client
@david-ruffin
关于 Natural Language MCP-MSSQL Client
Natural Language SQL Chat Interface using MCP SQL Server
基本信息
配置
使用下面的配置,将此服务器添加到你的 MCP 客户端。
{
"mcpServers": {
"MCP-MSSQL-SERVER-WEBAPP": {
"command": "python",
"args": [
"-m",
"venv",
"venv"
]
}
}
}工具
未检测到工具
工具是从 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
FAQ from Natural Language MCP-MSSQL Client
What prerequisites are needed?
Python 3.8+, the Microsoft ODBC Driver for SQL Server installed, and an Anthropic API key.
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.
How do I run the client in interactive mode?
After setup, run python interactive_client.py and type natural language questions at the prompt.
What does demo mode do?
python demo_nl_client.py runs several predefined questions automatically, showing the translation to SQL and the results.
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 服务器
ClickHouse MCP Server
ClickHouseConnect ClickHouse to your AI assistants.
MCP Server for Milvus
zilliztechModel Context Protocol Servers for Milvus
MySQL MCP Server
designcomputerA Model Context Protocol (MCP) server that enables secure interaction with MySQL databases
MCP MongoDB Server
kiliczshA Model Context Protocol Server for MongoDB
评论