Azure/BQ MCP Optimiser Server

Provides live FinOps insights for BigQuery and Azure SQL with cost, performance, and AI-driven SQL translation.

python

GitHub Stars

python

Language

7 months ago

First Indexed

3 months ago

Catalog Refreshed

Documentation & install

Readme and setup notes from the catalogue, plus a client-ready config you can copy for your MCP host.

Installation

Add the following to your MCP client configuration file.

Configuration

View docs

{
  "mcpServers": {
    "urfanazad-bq_azure_mcp": {
      "command": "python",
      "args": [
        "mcp_server.py"
      ],
      "env": {
        "GCP_PROJECT_ID": "YOUR_GCP_PROJECT_ID",
        "AZURE_CLIENT_ID": "YOUR_CLIENT_ID",
        "AZURE_TENANT_ID": "YOUR_TENANT_ID",
        "AZURE_SQL_SERVER": "YOUR_AZURE_SQL_SERVER",
        "DATA_SOURCE_TYPE": "bigquery",
        "AZURE_SQL_DATABASE": "YOUR_DATABASE",
        "AZURE_SQL_PASSWORD": "YOUR_PASSWORD",
        "AZURE_SQL_USERNAME": "YOUR_USERNAME",
        "AZURE_CLIENT_SECRET": "YOUR_CLIENT_SECRET",
        "AZURE_OPENAI_API_KEY": "YOUR_AZURE_OPENAI_API_KEY",
        "AZURE_RESOURCE_GROUP": "YOUR_RESOURCE_GROUP",
        "AZURE_OPENAI_ENDPOINT": "YOUR_AZURE_OPENAI_ENDPOINT",
        "AZURE_SUBSCRIPTION_ID": "YOUR_SUBSCRIPTION_ID",
        "AZURE_OPENAI_DEPLOYMENT_NAME": "YOUR_DEPLOYMENT_NAME",
        "GOOGLE_APPLICATION_CREDENTIALS": "PATH/TO/YOUR/SA_KEY.json"
      }
    }
  }
}

Available tools

get_cost_summary

Return a concise summary of the database performance and associated costs.

get_expensive_queries

Provide a list of the most resource-intensive queries to help identify optimization opportunities.

get_project_costs

Break down costs by project for BigQuery or summarize database-related metrics for Azure SQL.

get_cost_trends

Show historical cost or resource usage trends to aid capacity planning.

analyze_query_cost

Estimate the execution cost for a given query, helping you optimize performance.

get_cost_by_user

Break down usage and costs by user to understand access patterns.

natural_language_to_sql

Translate a natural language question into a SQL query for Azure SQL.

Built by

VeilStrat

AI signals for GTM teams