MCP Sql Server Natural Lang

🚀 SQL Server Agent - Modal Context Protocol

This is a SQL Server Agent that enables interaction with SQL Server databases using natural language. It operates under the Modal Context Protocol (MCP), which serves as an intermediary layer between the LLM and the data source.

✨ Features

• Converse with Your Database: Chat with SQL Server in plain English.
• Code-Free Database Operations: Completely manage your database tasks through natural conversations.
• One-Click Procedure Execution: Effortlessly run stored procedures using natural commands.
• MCP-Enhanced Accuracy: Achieve precise database interactions via the Modal Context Protocol (MCP), which intelligently links your commands to the data source.
• Context-Aware Conversations: Enjoy seamless interactions powered by the Modal Context Protocol.

What is MCP?

MCP (Modal Context Protocol) is a methodology that explains how to bind context to the LLM.

MCP offers a standardized approach to connect AI models with various data sources and tools.

Why Choose MCP?

MCP assists us in constructing complex workflows in a simplified manner, facilitating the creation of agents on top of the LLM, where the language model needs to frequently integrate with data sources and tools.

MCP Architecture

The MCP architecture adheres to the client - server model, allowing a single client to interact seamlessly with multiple servers.

• MCP Client: Your AI client (LLM) accesses data.
• MCP Protocol: Connects your client directly to the server.
• MCP Server: Helps your client access the data source via MCP.
• Local Databases, Cloud Databases, External APIs: Provide data through local storage, cloud computing, or online APIs.

Now, Dive into the Implementation

After understanding MCP and its architecture, let's combine it all with the SQL Server Agent.

What is SQL Server Agent?

The SQL Server Agent is a natural - language - based AI query CLI that enables you to interact with your SQL Server database using natural language. Supported by the Modal Context Protocol, it acts as an intelligent layer between your language model and the database, making it possible to:

• Query the database without writing SQL.
• Execute stored procedures using conversational commands.
• Maintain context across multiple steps for complex operations.

Whether you're a developer, analyst, or non - technical person, this agent makes your data accessible through intuitive human interactions.

Now, let's start following these steps👇

📦 Installation

Prerequisites

Before you begin, ensure that the following are installed:

• Python 3.12+ installed on your computer.
• A valid OpenAI API key.

Steps to Start Using SQL Server Agent

Follow these steps to get the project up and running:

1. Clone the Repository

git clone https://github.com/Amanp17/mcp-sql-server-natural-lang.git
cd mcp-sql-server-natural-lang

2. Install Dependencies

pip install -r requirements.txt

3. Set Environment Variables

Create a .env file in the project's root directory and add the following content:

OPENAI_API_KEY=your_openai_api_key
MSSQL_SERVER=localhost
MSSQL_DATABASE=your_database_name
MSSQL_USERNAME=your_username
MSSQL_PASSWORD=your_password
MSSQL_DRIVER={ODBC Driver 17 for SQL Server}

💻 Usage Examples

Run the SQL Server Agent

After setting up the environment and dependencies, you can interact with the agent.

Run the Client Script

Execute the following command to start the agent:

python mcp-ssms-client.py

Once the script starts running, it will prompt you as follows:

Press any key to continue...

Then, you can interact with the database by entering queries. For example:

Enter your query:
SELECT TOP 5 * FROM Customers;

Conclusion

The SQL Server Agent provides a powerful and straightforward way to interact with databases using natural language. Supported by the Modal Context Protocol, you can easily perform complex operations while maintaining code simplicity and maintainability. We hope this tool will bring convenience to your development work!