Natural Language MCP-MSSQL Client

@david-ruffin

About Natural Language MCP-MSSQL Client

Natural Language SQL Chat Interface using MCP SQL Server

Config

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

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

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 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.

Frequently asked questions

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.

Comments

Basic information

More Databases MCP servers

MCP Alchemy

runekaagaard

A MCP (model context protocol) server that gives the LLM access to and knowledge about relational databases like SQLite, Postgresql, MySQL & MariaDB, Oracle, and MS-SQL.

412

Sail MCP Server for Spark SQL

lakehq

Drop-in Apache Spark replacement written in Rust, unifying batch processing, stream processing, and compute-intensive AI workloads.

3.1K

Local YDB MCP

astandrik

Safety-first stdio MCP server with 38 tools for operating Docker-based local-ydb environments locally or over SSH.

MongoDB MCP Server

mongodb-js

A Model Context Protocol server to connect to MongoDB databases and MongoDB Atlas Clusters.

1.1K

Fund Momentum MCP Server

schneidavie

Fund Momentum MCP Server — VC intelligence for AI assistants. 1000+ active VC funds, live investor signals, AI-powered startup matching.