Edit

Share via

Azure SQL tools for the Azure MCP Server

The Azure MCP Server lets you manage Azure resources, including Azure SQL databases and servers, using natural language prompts. This feature lets you quickly manage your database resources without remembering complex syntax.

Azure SQL is a family of managed, secure, and intelligent products that use the SQL Server database engine in the Azure cloud. Azure SQL includes Azure SQL Database, Azure SQL Managed Instance, and SQL Server on Azure VMs. These products provide flexible options for migrating, modernizing, and developing applications.

Note

The Azure MCP Server tools define parameters for data they need to complete tasks. Some of these parameters are specific to each tool and are documented below. Other parameters are global and shared by all tools. For more information, see Tool parameters.

Server

List Microsoft Entra administrators

Lists Microsoft Entra ID administrators configured for an Azure SQL server. Use this command to manage and audit identity-based access to your SQL servers.

Example prompts include:

  • Check admin users: "Show me all Microsoft Entra administrators for my 'prod-sql' server"
  • Identity access: "List Microsoft Entra admins for SQL server 'finance-db' in resource group 'data' and subscription 'corp-main'"
  • Security check: "Who has admin access to my SQL servers?"
  • Administrator review: "Need to verify Entra ID admins on SQL server now"
  • Access audit: "Could you please provide a comprehensive breakdown of all Microsoft Entra administrators assigned to my eastus-sql-02 server in the development environment for security compliance documentation?"
Parameter Required or optional Description
Subscription Required The ID or name of your Azure subscription that contains the SQL server.
Resource group Required The resource group that contains the SQL server.
Server name Required The name of the SQL server to list Microsoft Entra administrators for.

Database

Show database details

Retrieves detailed information about a specific Azure SQL database. Use this command to check the configuration, performance tier, size, and other characteristics of your database.

Example prompts include:

  • View database details: "Show me details for the 'inventory' database on my 'eastus-sql' server"
  • Check database configuration: "Can you tell me the specifications and current state of my customer-db database in the prod-dbs resource group and finance subscription?"
  • Database information: "Database details... financial-data... need info now"
  • Check performance tier: "What service tier is my analytics database using? And is it properly sized for our workload?"
  • Database properties: "I want to see all performance metrics, sizing options, and configuration settings for the orders database hosted on commerce-sql-01 in the west-europe region"
Parameter Required or optional Description
Subscription Required The ID or name of your Azure subscription that contains the SQL database.
Resource group Required The resource group that contains the SQL server and database.
Server name Required The name of the SQL server hosting the database.
Database name Required The name of the database to get details for.

Firewall rules

List firewall rules

Lists all firewall rules for a specific Azure SQL server. Use this command to manage and review the network access settings for your SQL server.

Example prompts include:

  • View firewall settings: "Show me all firewall rules for my 'prod-sql-server' in resource group 'data'"
  • Check access controls: "Are there any firewall rules for my analytics-db SQL server in the eastus region?"
  • Review security: "IP addresses... SQL server eastus-sql-01... security review"
  • Network access: "I need to immediately identify all network access points and IP address ranges that have been granted permissions to connect to our production SQL server environment for the compliance audit happening tomorrow"
  • Security audit: "List the firewall rules for our finance-db server in resource group accounting and subscription finance-prod"
Parameter Required or optional Description
Subscription Required The ID or name of your Azure subscription that contains the SQL server.
Resource group Required The resource group that contains the SQL server.
Server name Required The name of the SQL server to list firewall rules for.

Elastic pools

List elastic pools

Lists all elastic pools for a specific Azure SQL server. Elastic pools are a resource allocation solution that lets you manage and scale multiple databases with varying resource demands.

Example prompts include:

  • View resource pools: "Show me all elastic pools on my 'main-sql' server"
  • Check elasticity: "Could you list any elastic pools we have running on our customer-db SQL server in the production environment?"
  • Resource management: "Elastic pools... SQL server... need status report"
  • Pool inventory: "I need a complete inventory of every single elastic pool deployed across all our SQL servers in the dev-subscription, including their DTU allocation, storage limits, and current database count"
  • Database scaling: "What's the current configuration and available capacity in the analytics elastic pool on our main SQL server in resource group data-services?"
Parameter Required or optional Description
Subscription Required The ID or name of your Azure subscription that contains the SQL server.
Resource group Required The resource group that contains the SQL server.
Server name Required The name of the SQL server to list elastic pools for.

Related content