SQL Server MCP server: connect SQL Server to Claude, ChatGPT, Cursor and Claude Code. Hosted remote MCP for schemas, tables, T-SQL and database health for SQL Server and Azure SQL.
Setup
Choose your client, copy the config, then fill in any required environment variables.
claude mcp add --transport http sql-server-by-insightfulpipe https://mssql.insightfulmcp.com/~/.codex/config.toml
[mcp_servers.sql-server-by-insightfulpipe]
url = "https://mssql.insightfulmcp.com/"
# codex mcp add sql-server-by-insightfulpipe --url https://mssql.insightfulmcp.com/~/.cursor/mcp.json
{
"mcpServers": {
"sql-server-by-insightfulpipe": {
"url": "https://mssql.insightfulmcp.com/"
}
}
}.vscode/mcp.json
{
"servers": {
"sql-server-by-insightfulpipe": {
"type": "http",
"url": "https://mssql.insightfulmcp.com/"
}
}
}~/.gemini/settings.json
{
"mcpServers": {
"sql-server-by-insightfulpipe": {
"httpUrl": "https://mssql.insightfulmcp.com/"
}
}
}claude_desktop_config.json · Customize › Connectors › Add custom connector
{
"mcpServers": {
"sql-server-by-insightfulpipe": {
"command": "npx",
"args": [
"-y",
"mcp-remote",
"https://mssql.insightfulmcp.com/"
]
}
}
}.trae/mcp.json
{
"mcpServers": {
"sql-server-by-insightfulpipe": {
"url": "https://mssql.insightfulmcp.com/"
}
}
}