The Model Context Protocol (MCP) standardizes how AI applications and agents connect to outside data sources. MCP servers can be local or remote. Local MCP servers typically run on your local machine and use the standard input and output streams (stdio) for communication between services on the same device. Remote MCP servers run on the service's infrastructure and offer an HTTP endpoint to AI applications for communication between the AI MCP client and the MCP server.
For more information, see MCP architecture .
Cloud SQL for SQL Server supports two remote servers for usage with MCP:
-
Cloud SQL for SQL Server server: Provides tools for managing Cloud SQL for SQL Server instances, and executing SQL queries.
- Learn how to Use the Cloud SQL for SQL Server MCP server .
- View the detailed Cloud SQL for SQL Server MCP tool reference .
-
Database Insights server: Provides tools for querying and analyzing database performance and system metrics.
- View the detailed Database Insights MCP tool reference .
