English Français العربية

SQL Server MCP by InsightfulPipe

Registre officiel Données et bases de données

Hosted SQL Server MCP server for Claude, ChatGPT and Cursor, with each action switched per account.

Code source Site web Documentation

Installation

Ajoutez ceci à la configuration MCP de votre client (Claude Desktop : claude_desktop_config.json ; Cursor : .cursor/mcp.json ; VS Code et les autres utilisent la même forme « mcpServers »).

Remote (streamable-http)
Claude Code 
claude mcp add --transport http sql-server-mcp-by-insightfulpipe 'https://mssql.insightfulmcp.com/'
Configuration JSON (Claude Desktop, Cursor, VS Code) 
{
    "mcpServers": {
        "sql-server-mcp-by-insightfulpipe": {
            "type": "http",
            "url": "https://mssql.insightfulmcp.com/"
        }
    }
}

Documentation

Tirée du README du projet sur GitHub, actualisée chaque semaine. Les liens ouvrent GitHub.

Sommaire
  1. SQL Server MCP Server by Insightful Pipe
  2. MCP Server URL
  3. What is SQL Server MCP?
  4. Installation
  5. Available Actions
  6. Control What Your AI Can Do
  7. Usage Examples
  8. Pricing
  9. Explore More MCP Servers by Insightful Pipe
  10. Resources
  11. Support
  12. License

SQL Server MCP Server by Insightful Pipe

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).

MCP Server URL

https://mssql.insightfulmcp.com/

What is SQL Server MCP?

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.

Installation

Claude
  1. Copy the MCP Server URL: https://mssql.insightfulmcp.com/
  2. Open Claude Connectors Settings
  3. Scroll to the bottom and click Add custom connector
  4. Paste the URL and click Add
  5. Click Connect and sign in to InsightfulPipe if asked. Claude then lists the connector as connected.
ChatGPT

Custom MCP servers are added through ChatGPT's Developer mode. Availability depends on your ChatGPT plan, and workspace admins may need to allow it.

  1. Turn on Developer mode in ChatGPT settings
  2. Create a new app for a remote MCP server and paste the URL: https://mssql.insightfulmcp.com/
  3. Sign in to InsightfulPipe if asked. The connection finishes as soon as you are signed in.

See OpenAI's guide: Developer mode and MCP apps in ChatGPT

Claude Code
claude mcp add --transport http mssql https://mssql.insightfulmcp.com/
Cursor

Add the server to ~/.cursor/mcp.json (all projects) or .cursor/mcp.json (one project):

{
  "mcpServers": {
    "mssql": {
      "url": "https://mssql.insightfulmcp.com/"
    }
  }
}

When Cursor shows Needs authentication, click Connect and sign in to InsightfulPipe if asked.

Available Actions

8 actions: 7 read, 1 write.

Read Actions (7)
ActionDescription
analyze_db_healthConnection state + memory clerks + log-reuse health
explain_querySHOWPLAN_XML for a query
get_table_metadataFull metadata: columns + constraints + indexes + estimated size
get_table_schemaColumn list for a table or view
get_top_queriesHeaviest queries from sys.dm_exec_query_stats
list_schemasList all schemas in the connected database
list_tablesList tables, views, or sequences in a schema
Write Actions (1)
ActionDescription
run_queryExecute a T-SQL statement

Control What Your AI Can Do

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.

Usage Examples

"List the tables in the dbo schema"
"Show the schema of the Orders table"
"Check my database health"

Pricing

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, and you can try it for 7 days. See insightfulpipe.com/pricing for current plans.

Explore More MCP Servers by Insightful Pipe

Visit insightfulpipe.com/mcp-servers to discover our full collection of MCP servers.

View All MCP Servers →

Resources

Support

Insightful Pipe — AI-powered marketing analytics through MCP servers. Explore all integrations →

License

MIT License - see LICENSE for details.

Questions fréquentes

Qu'est-ce que SQL Server MCP by InsightfulPipe ?

Hosted SQL Server MCP server for Claude, ChatGPT and Cursor, with each action switched per account.

Comment installer SQL Server MCP by InsightfulPipe ?

Il fonctionne comme serveur distant. Dans Claude Code : claude mcp add --transport http sql-server-mcp-by-insightfulpipe 'https://mssql.insightfulmcp.com/'. Pour les autres clients, collez la configuration JSON de cette page dans leurs réglages MCP.

Faut-il une clé API pour SQL Server MCP by InsightfulPipe ?

Son entrée au registre n'indique aucune clé ni secret obligatoire. Certaines fonctions peuvent tout de même demander un compte auprès du service auquel il se connecte.

SQL Server MCP by InsightfulPipe est-il open source ?

Oui. Son code est sur GitHub sous licence MIT.

Qui maintient SQL Server MCP by InsightfulPipe ?

Il est publié par Insightful-Pipe. AI.tn le référence sans le maintenir ni le recommander.

Issu du registre MCP officiel. Être listé n'est pas une recommandation : vérifiez le code et les permissions d'un serveur avant de lui donner accès à vos données.