home / mcp / azure table mcp server

Azure Table MCP Server

Provides a read-only MCP server to query live data from Azure Table using the CData JDBC Driver.

Installation

Add the following to your MCP client configuration file.

Configuration

{
  "mcpServers": {
    "cdatasoftware-azure-table-mcp-server-by-cdata": {
      "command": "java",
      "args": [
        "-jar",
        "/PATH/TO/CDataMCP-jar-with-dependencies.jar",
        "/PATH/TO/azure-table.prp"
      ]
    }
  }
}

You can run a local, read-only MCP server that exposes live Azure Table data through the CData JDBC Driver. This enables large language models to query Azure Table data in natural language without writing SQL, keeping data access fast and tightly scoped to your Azure Table resources.

How to use

You will interact with the Azure Table MCP Server through an MCP client. Start the local server using the provided MCP configuration, then connect your client (for example an AI assistant) to issue natural language questions about your Azure Table data. Typical usage patterns include asking for counts, summaries, or relationships between tables, such as customer counts by region, recent calendar events linked to accounts, or status aggregations across tables. The server exposes a small set of tools that the client can invoke behind the scenes, so you usually do not need to call tools directly.

Tools you can access

The server provides tools to interact with your data source. You can retrieve the list of tables, inspect table columns, and run SQL queries against the Azure Table data. The tool names are composed from the server prefix you configure and follow the pattern described below.

Available tools

azure_table_get_tables

Retrieves a list of available tables in the data source. The output is in CSV format with a header row.

azure_table_get_columns

Retrieves a list of columns for a specified table. The output is in CSV format with a header row.

azure_table_run_query

Executes a SQL SELECT query against the Azure Table data source and returns results.