Schema | Azure SQL MCP Server

Azure SQL MCP Server

Describes the environment variables required to run the server.

Name	Required	Description
`DATABASE`	Yes	The name of the database
`SERVER_NAME`	Yes	The Azure SQL server name (e.g., your-server.database.windows.net)
`AZURE_CLIENT_ID`	No	Optional Azure client ID for authentication via environment variables
`AZURE_TENANT_ID`	No	Optional Azure tenant ID for authentication via environment variables
`AZURE_CLIENT_SECRET`	No	Optional Azure client secret for authentication via environment variables

Features and capabilities supported by this server

Capability	Details
`tools`	{ "listChanged": false }
`prompts`	{ "listChanged": false }
`resources`	{ "subscribe": false, "listChanged": false }
`experimental`	{}

Functions exposed to the LLM to take actions

Name	Description
check_database_configA	Check if the database is properly configured. `Returns configuration status and any error messages.`
execute_queryC	Execute a SQL query against the Azure SQL database. `Args: query: SQL query to execute (e.g., "SELECT * FROM users LIMIT 10")`
get_tablesA	Get list of all tables in the Azure SQL database.
get_table_schemaB	Get schema information for a specific table. `Args: table_name: Name of the table (e.g., "users" or "schema.table_name")`
get_sample_dataA	Get sample data from a table. `Args: table_name: Name of the table (e.g., "users" or "schema.table_name") limit: Number of rows to return (default: 5, max: 100)`

Interactive templates invoked by user choice

Name	Description
No prompts

Contextual data attached and managed by the client

Name	Description
No resources

We provide all the information about MCP servers via our MCP API.

curl -X GET 'https://glama.ai/api/mcp/v1/servers/carlosgutierrezch/mcp_component'

If you have feedback or need assistance with the MCP directory API, please join our Discord server