SQL Server Agent - Modal Context Protocol

Here is the SQL Server Agent that let's you Interact with the SQL Server Database in the Natural Language leveraging the Modal Context Protocol as a layer between our LLMs and Data Source.

Key Features:

• Talk to Your Database: Chat with SQL Server using plain English.
• No-Code Database Operations: Manage your database tasks entirely through natural conversations.
• One-Click Procedure Execution: Run stored procedures effortlessly with natural commands.
• MCP-Enhanced Accuracy: Achieve precise database interactions through Modal Context Protocol (MCP), intelligently connecting your commands to data.
• Context-Aware Conversations: Enjoy seamless interactions powered by Modal Context Protocol.

What is MCP?

MCP (Modal Context Protocol) is a metodology that stats how we should bind the context to the LLMs.

MCP provides a standardized way to connect AI models to different data sources and tools.

Why MCP?

MCP helps us to build the complex workflows in a simplified way to build the Agents on top of LLMs where the laguage models needs a frequent integration with the data sources and tools.

MCP Architecture:

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

MCP-Client: Your AI client (LLM) accessing data.

MCP-Protocol: Connects your client directly to the server.

MCP-Server: Helps your client access data sources via MCP.

Local Database, Cloud Database, External APIs: Sources providing data through local storage, cloud, or online APIs.

Now, Let's Dive Into the Implementation

With an understanding of MCP and its architecture, it's time to bring it all together with the SQL Server Agent.

What is SQL Server Agent?

The SQL Server Agent is a conversational AI Query CLI that enables you to interact with your SQL Server Database using natural language. Powered by the Modal Context Protocol, it acts as a smart layer between your language model and the database, making it possible to:

• Query your database without writing SQL
• Execute stored procedures with conversational commands
• Perform complex operations while maintaining context across multiple steps

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

Now, let’s walk through how to get it up and running 👇

Prerequisites

Before you get started, make sure you have the following:

• Python 3.12+ installed on your machine
• A valid OpenAI API Key

Getting Started

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. Setup Environment Variables

Create a .env file in the root of the project and add the following:

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}

Running the SQL Server Agent

Once you've set up your environment and dependencies, you're ready to interact with the SQL Server Agent.

Run the Client Script

Execute the following command to start the agent:

python mcp-ssms-client.py

Once the script starts, it will prompt you like this:

Enter your Query:

Now, you can type your request in plain English. For example:

Create a Employee table with 10 dummy data in it with their departments and salaries.

The agent will process your input using the Modal Context Protocol and return the relevant data from your SQL Server database.

🧠 Tip: You can ask follow-up questions or make requests like "show me the employees and their departments?" or "how many employees are having salary under $40K?" — the context is preserved!

Conclusion

The SQL Server Agent powered by the Modal Context Protocol (MCP) brings the power of conversational AI to your database operations. By bridging the gap between natural language and SQL, it allows users to interact with their data effortlessly, making database access more intuitive, efficient, and accessible to everyone even those without technical expertise.

Whether you're querying data, executing procedures, or building complex workflows, this agent serves as your intelligent interface to SQL Server.

Feel free to contribute, open issues, or suggest enhancements — we're building the future of AI-driven data interaction together! 🚀