Natural Language MCP-MSSQL Client

by david-ruffin

174 downloads

Not rated

GitHub

Database

About

Natural Language SQL Chat Interface using MCP SQL Server

Details

Author: david-ruffin
Downloads: 174
Categories: Database

Setting up with Highlight

This MCP is not yet compatible with Highlight’s one-click setup. However, you can still use it with Highlight by following these steps:

Download and install Highlight from highlightai.com/download
Navigate to the plugins tab and select "Add Custom Plugin"
Configure the plugin with the settings below

Plugin Name Natural Language MCP-MSSQL Client

Command (node, npx, python, etc.)

Please refer to the README for specific instructions on how to obtain API keys or other required environment variables.
Enable "Start Automatically" if you want the plugin to start when Highlight launches

Setting up with Cursor

Open Cursor's settings
Navigate to the MCP section
Click "Add new Global MCP server"
Copy and paste the configuration below based on your operating system

JSON

{
    "mcpServers": {
        "natural language mcp-mssql client": {
            "MCP-MSSQL-SERVER-WEBAPP": {
                "command": "python",
                "args": [
                    "-m",
                    "venv",
                    "venv"
                ]
            }
        }
    }
}

JSON

{
    "mcpServers": {
        "natural language mcp-mssql client": {
            "MCP-MSSQL-SERVER-WEBAPP": {
                "command": "python",
                "args": [
                    "-m",
                    "venv",
                    "venv"
                ]
            }
        }
    }
}

JSON

{
    "mcpServers": {
        "natural language mcp-mssql client": {
            "MCP-MSSQL-SERVER-WEBAPP": {
                "command": "python",
                "args": [
                    "-m",
                    "venv",
                    "venv"
                ]
            }
        }
    }
}

Setting up with Claude Desktop

Open Claude Desktop's settings
Go to the Integrations tab
Click "Add MCP Server"
Use the configuration below based on your operating system

Note: Make sure Claude Desktop is running before attempting to connect.

JSON

{
    "mcpServers": {
        "natural language mcp-mssql client": {
            "MCP-MSSQL-SERVER-WEBAPP": {
                "command": "python",
                "args": [
                    "-m",
                    "venv",
                    "venv"
                ]
            }
        }
    }
}

JSON

{
    "mcpServers": {
        "natural language mcp-mssql client": {
            "MCP-MSSQL-SERVER-WEBAPP": {
                "command": "python",
                "args": [
                    "-m",
                    "venv",
                    "venv"
                ]
            }
        }
    }
}

JSON

{
    "mcpServers": {
        "natural language mcp-mssql client": {
            "MCP-MSSQL-SERVER-WEBAPP": {
                "command": "python",
                "args": [
                    "-m",
                    "venv",
                    "venv"
                ]
            }
        }
    }
}

Setting up with Windsurf

Open Windsurf's preferences
Go to the Integrations section
Click "Add MCP Integration"
Use the configuration below based on your operating system

JSON

{
    "mcpServers": {
        "natural language mcp-mssql client": {
            "MCP-MSSQL-SERVER-WEBAPP": {
                "command": "python",
                "args": [
                    "-m",
                    "venv",
                    "venv"
                ]
            }
        }
    }
}

JSON

{
    "mcpServers": {
        "natural language mcp-mssql client": {
            "MCP-MSSQL-SERVER-WEBAPP": {
                "command": "python",
                "args": [
                    "-m",
                    "venv",
                    "venv"
                ]
            }
        }
    }
}

JSON

{
    "mcpServers": {
        "natural language mcp-mssql client": {
            "MCP-MSSQL-SERVER-WEBAPP": {
                "command": "python",
                "args": [
                    "-m",
                    "venv",
                    "venv"
                ]
            }
        }
    }
}

Setting up with Cline

Open Cline's settings
Navigate to the Integrations section
Click "Add MCP Server"
Copy and paste the configuration below based on your operating system

Note: Make sure to restart Cline after adding the configuration.

JSON

{
    "mcpServers": {
        "natural language mcp-mssql client": {
            "MCP-MSSQL-SERVER-WEBAPP": {
                "command": "python",
                "args": [
                    "-m",
                    "venv",
                    "venv"
                ]
            }
        }
    }
}

JSON

{
    "mcpServers": {
        "natural language mcp-mssql client": {
            "MCP-MSSQL-SERVER-WEBAPP": {
                "command": "python",
                "args": [
                    "-m",
                    "venv",
                    "venv"
                ]
            }
        }
    }
}

JSON

{
    "mcpServers": {
        "natural language mcp-mssql client": {
            "MCP-MSSQL-SERVER-WEBAPP": {
                "command": "python",
                "args": [
                    "-m",
                    "venv",
                    "venv"
                ]
            }
        }
    }
}

Setting up with Goose

Open Goose's preferences
Go to the Integrations tab
Select "MCP Servers"
Click "Add New Server"
Use the configuration below based on your operating system

JSON

{
    "mcpServers": {
        "natural language mcp-mssql client": {
            "MCP-MSSQL-SERVER-WEBAPP": {
                "command": "python",
                "args": [
                    "-m",
                    "venv",
                    "venv"
                ]
            }
        }
    }
}

JSON

{
    "mcpServers": {
        "natural language mcp-mssql client": {
            "MCP-MSSQL-SERVER-WEBAPP": {
                "command": "python",
                "args": [
                    "-m",
                    "venv",
                    "venv"
                ]
            }
        }
    }
}

JSON

{
    "mcpServers": {
        "natural language mcp-mssql client": {
            "MCP-MSSQL-SERVER-WEBAPP": {
                "command": "python",
                "args": [
                    "-m",
                    "venv",
                    "venv"
                ]
            }
        }
    }
}

From the repository

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.

Claude Desktop / Cursor

Paste into your MCP client config file to install this server.

{
    "mcpServers": {
        "natural language mcp-mssql client": {
            "MCP-MSSQL-SERVER-WEBAPP": {
                "command": "python",
                "args": [
                    "-m",
                    "venv",
                    "venv"
                ]
            }
        }
    }
}

McpServers

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

Natural Language MCP-MSSQL Client

A natural language interface for SQL databases using the Model Context Protocol (MCP). This client allows users to query Microsoft SQL Server databases using plain English questions through Claude AI.

Features

- Natural Language Querying: Ask questions about your database in plain English
- MCP Integration: Connects to MCP-MSSQL server using FastMCP
- Claude AI: Uses Anthropic's Claude API to translate natural language to SQL
- Interactive Mode: Type questions directly and get database results
- Demo Mode: Run predefined questions to showcase functionality

Components

1. MCP-MSSQL Server: Provides access to MS SQL Server databases through MCP
2. Natural Language Client: Converts plain English to SQL using Claude API
3. FastMCP Framework: Handles the communication between client and server

Prerequisites

Python 3.8+
ODBC Driver for SQL Server installed on your system
Anthropic API key
Required Python packages (fastmcp, anthropic, python-dotenv, etc.)

Project Structure

MCP-MSSQL-SERVER-WEBAPP/
├── src/
│   └── mssql/           # MSSQL MCP server implementation
│       ├── __init__.py
│       └── server.py    # Main MCP server
├── interactive_client.py   # Interactive natural language client
├── demo_nl_client.py       # Demo client with predefined questions
├── .env                    # Environment configuration (not in git)
├── .env.example            # Example environment configuration
└── requirements.txt        # Project dependencies

Setup Instructions

1. Clone the repository:

   git clone https://github.com/david-ruffin/MCP-MSSQL-SERVER-WEBAPP.git

   cd MCP-MSSQL-SERVER-WEBAPP

2. Set up a virtual environment:

   python -m venv venv

   source venv/bin/activate  # On Windows: venv\Scripts\activate

   pip install -r requirements.txt

3. Configure the environment:
Copy .env.example to .env and fill in your database and API credentials:

   MSSQL_SERVER=your_server

   MSSQL_DATABASE=your_database

   MSSQL_USER=your_username

   MSSQL_PASSWORD=your_password

   MSSQL_DRIVER={ODBC Driver 17 for SQL Server}

   ANTHROPIC_API_KEY=your_api_key

Running the Client

Interactive Mode

Run the interactive client to ask your own questions:

source venv/bin/activate
export ANTHROPIC_API_KEY=$(grep ANTHROPIC_API_KEY .env | cut -d= -f2)
python interactive_client.py

Type natural language questions at the prompt, and the client will convert them to SQL, execute them, and display the results.

Demo Mode

Run the demo to see predefined questions:

source venv/bin/activate
export ANTHROPIC_API_KEY=$(grep ANTHROPIC_API_KEY .env | cut -d= -f2)
python demo_nl_client.py

The demo will automatically run several example questions, showing the natural language to SQL conversion and results.

Example Questions

- "How many products are there?"
- "List all customers from California"
- "Show me the most expensive products"
- "What are the different product categories?"
- "How many orders were placed in 2004?"

ODBC Driver Setup

This client requires the Microsoft ODBC Driver for SQL Server. Follow the official Microsoft guides to install:

- Windows
- macOS/Linux

License

MIT License

No reviews yet — be the first

Use Google, GitHub, or an email account so ratings stay tied to real people.

Email sign in

No reviews posted yet.

About

Details

Jump to

Setting up with Highlight

From the repository

Claude Desktop / Cursor

McpServers

Natural Language MCP-MSSQL Client

Features

Components

Prerequisites

Project Structure

Setup Instructions

Running the Client

Interactive Mode

Demo Mode

Example Questions

ODBC Driver Setup

License

Install

More like this

Redis

Sqlite

PostgreSQL

Npx Y convex@latest mcp start

AWS MCP Servers

whatsapp-mcp