Connect SQL Server to AI assistants: schemas, tables, T-SQL and database health for SQL Server and Azure SQL.
Part of the Insightful Pipe MCP Server Collection — use SQL Server from Claude, ChatGPT, Cursor, and other AI assistants through the Model Context Protocol (MCP).
https://mssql.insightfulmcp.com/
SQL Server MCP is a remote Model Context Protocol server hosted by InsightfulPipe. Browse schemas, inspect tables, and run T-SQL against your own Microsoft SQL Server or Azure SQL instance. Read vs. read-write is decided by the GRANT/REVOKE privileges on the login this connector uses.
- Copy the MCP Server URL:
https://mssql.insightfulmcp.com/ - Open Claude Connectors Settings
- Scroll to the bottom and click Add custom connector
- Paste the URL and click Add
- Click Connect on the connector to start authorization
- Click Authorize access in the browser to complete the connection
Custom MCP servers are added through ChatGPT's Developer mode. Availability depends on your ChatGPT plan, and workspace admins may need to allow it.
- Turn on Developer mode in ChatGPT settings
- Create a new app for a remote MCP server and paste the URL:
https://mssql.insightfulmcp.com/ - Authorize with your InsightfulPipe account
See OpenAI's guide: Developer mode and MCP apps in ChatGPT
claude mcp add --transport http mssql https://mssql.insightfulmcp.com/Add the server to ~/.cursor/mcp.json (all projects) or .cursor/mcp.json (one project):
{
"mcpServers": {
"mssql": {
"url": "https://mssql.insightfulmcp.com/"
}
}
}Then authorize the connection when Cursor prompts you.
8 actions: 7 read, 1 write.
| Action | Description |
|---|---|
analyze_db_health |
Connection state + memory clerks + log-reuse health |
explain_query |
SHOWPLAN_XML for a query |
get_table_metadata |
Full metadata: columns + constraints + indexes + estimated size |
get_table_schema |
Column list for a table or view |
get_top_queries |
Heaviest queries from sys.dm_exec_query_stats |
list_schemas |
List all schemas in the connected database |
list_tables |
List tables, views, or sequences in a schema |
| Action | Description |
|---|---|
run_query |
Execute a T-SQL statement |
You decide what AI agents can do with each connected account:
- Turn individual actions on or off for every connected account, so agents only see the actions you allow.
- Connect as Read-only or Read & Write. A read-only connection can only enable read actions.
- Destructive actions stay off by default. Actions such as deletes are disabled until an admin enables them.
- Team access per account. Restricted team members only use the accounts they are granted, with the read actions enabled on them.
"List the tables in the dbo schema"
"Show the schema of the Orders table"
"Check my database health"
The SQL Server MCP server is included in every InsightfulPipe plan, together with all other MCP servers and the CLI. Plans start at $29.99/month with a 7-day free trial. See insightfulpipe.com/pricing for current plans.
Visit insightfulpipe.com/mcp-servers to discover our full collection of MCP servers.
- Documentation: insightfulpipe.com/docs
- All MCP Servers: insightfulpipe.com/mcp-servers
- Email: support@insightfulpipe.com
Insightful Pipe — AI-powered marketing analytics through MCP servers. Explore all integrations →
MIT License - see LICENSE for details.