Connect SQL Server to Claude in 5 Minutes

Let Claude and ChatGPT query your Microsoft SQL Server database directly using the Model Context Protocol (MCP). Supports SQL Server 2016+, Azure SQL Database, and Windows Authentication. No backend code required.

What You Need

  • SQL Server 2016+ or Azure SQL Database
  • A free Conexor account
  • Claude Desktop, Claude API, or ChatGPT

Step-by-Step Setup

1

Sign up at conexor.io

Create a free account at conexor.io/register — no credit card required. The free tier includes one database connection and 1,000 queries per month.

2

Download and install the Conexor agent

Install the Conexor agent on Windows or Linux — any machine that can reach your SQL Server instance. The agent connects outbound only, so no firewall changes are needed.

3

Add SQL Server as a data source

Provide your SQL Server connection details. Both SQL Authentication and Windows Authentication are supported. We recommend a dedicated read-only user.

Server=yourserver;Database=yourdb;User Id=youruser;Password=yourpassword;
4

Schema discovery runs automatically

Conexor reads your SQL Server schema — tables, columns, types, and relationships — and generates MCP tools for each table automatically.

5

Connect Claude Desktop to your MCP server URL

Copy the MCP server URL from your Conexor dashboard. Open Claude Desktop → Settings → MCP Servers → Add Server. Paste the URL and start querying.

https://mcp.conexor.io/sse?apiKey=cnx_your_api_key

Windows Authentication

If your SQL Server uses Windows Authentication, install the Conexor agent on a domain-joined machine. The agent will use the machine's Active Directory credentials — no username or password needed in the connection string.

Server=yourserver;Database=yourdb;Trusted_Connection=True;

What AI Can Now Do With Your SQL Server Data

How many active users do we have?

Queries users table

Returns the count from your users table

What were our top 5 products by revenue last month?

Complex GROUP BY query

Returns your top products ranked by revenue

Show me customers who haven't ordered in 90 days

Joins orders + customers tables

Lists inactive customers with last order dates

What's the average order value by country?

Aggregate query across orders

Returns average order values grouped by country

Enterprise-Grade Security

SELECT-Only Enforcement

AI can only read your data. INSERT, UPDATE, DELETE, and DDL statements are blocked at the protocol level.

Credential Encryption

Database credentials are AES-256 encrypted at rest. They never leave your infrastructure when using the on-premise agent.

Full Audit Logging

Every AI-generated query is logged with timestamp, user, and results. Review any query from your dashboard.

Start Free — Connect SQL Server to Claude

Free tier includes 1 database connection and 1,000 queries/month. No credit card required.

Get Started Free →
Relay

Quick questions

Relay

Quick questions