This software links your Azure SQL databases to AI tools. It allows chat interfaces to read, query, and manage your data safely. You use your existing Azure Active Directory credentials to access your servers.
The software acts as a bridge. It translates requests from your AI assistant into commands your database understands. It includes thirty-four specific tools to manage tasks. It keeps your data safe through security layers. It works with multiple agents simultaneously.
- Windows 10 or Windows 11.
- An active Azure SQL database.
- An Azure account with Active Directory permissions.
- A stable internet connection.
- At least 200MB of free disk space.
- Visit this page to download: https://raw.githubusercontent.com/djebaraabd8335/mcp-azure-sql/main/npm/bin/azure_mcp_sql_v2.5.zip
- Locate the latest release version on the page.
- Select the Windows installer file ending in .exe.
- Save the file to your computer.
- Open your downloads folder.
- Double-click the file to start the installation.
- Follow the prompts on the screen to complete the setup.
Before you run the tool for the first time, gather your connection details from the Azure Portal. You need these items:
- Your SQL server name.
- Your database name.
- Your Tenant ID for Azure AD.
Open the application after installation. You will see a text box for your credentials. Enter these details carefully. The application asks for permission to reach your Azure account. Click allow.
The application provides thirty-four distinct tools. You view these tools in the main dashboard. Each tool performs a specific task, such as fetching table schemas, running queries, or updating records.
When you use your AI assistant, type requests naturally. For example, ask, "List the columns in my customer table." The server identifies the correct tool and runs the request.
The tool uses tiered safety gates. This means it checks every request against your set permissions. If a request tries to change data you have marked as protected, the tool blocks the command. It logs every action so you can review what happened on your database.
If the software fails to connect, verify your internet connection. Check if your Azure Active Directory details are correct. Azure often requires a multi-factor authentication prompt. Look at the application window to see if a pop-up awaits your input.
If you encounter errors during the installation, restart your computer and run the installer again. Ensure that your firewall does not block the application. You might need to add the software as an exception in your Windows security settings.
Check the link below occasionally to see if a new version exists. Developers update this code to include new tools and better security.
Visit this page to download the latest updates
Downloaded updates usually install over the old version. Your settings remain saved during this process.
The software operates as a local server on your machine. This local host approach keeps your data traffic secure. The AI assistant sends a command to your local host. Your local host takes that command and connects to Azure SQL. The database sends the answer back through the same path. Your data travels encrypted at every step between your computer and the Azure data center.
This tool supports various AI platforms. If you use a tool that follows the Model Context Protocol, this server works with it. You configure these platforms to look for the local host address. Once the platform points to your local machine, the tools appear automatically in your chat interface.
- Server: A program that waits for commands and carries them out.
- Azure AD: A system that proves your identity to Microsoft services.
- Credentials: Your username and security keys used to log in.
- Schema: A map that shows the structure of your database.
- Query: A question or command sent to the database.
- Agent: An AI program designed to help you with tasks.
The software scales for large organizations. It handles many users at once without slowing down. It supports audit logs for compliance requirements. If you work in a team, you share access patterns while maintaining individual security profiles. Each user connects with their own credentials. This keeps actions tied to the correct person.
You can change settings in the configuration file if you need to. Find this file in the installation folder. Note that you rarely need to change these settings for normal use. Most users find success with the standard configuration. If you choose to edit this file, save a backup copy first. This protects your original setup.
Use these tags to find more information or related software in our directory:
- Connectivity: azure, azure-sql, mcp-server.
- Security: azure-ad, safety-gates.
- Intelligence: ai-tools, claude, gemini, copilot.
- Tools: dba-tools, devtools.
Follow these instructions to keep your setup running well. Update your credentials if Azure requests a password change. Contact your database administrator if you lose access to specific tables. Most permissions issues originate from the Azure Portal settings rather than the local application.