MCP Azure Tablestorage

🚀 Azure Table Storage MCP Server

A TypeScript-based MCP server that enables direct interaction with Azure Table Storage via Cline. This tool allows you to query and manage data in Azure Storage Tables.

🚀 Quick Start

This server provides a convenient way to interact with Azure Table Storage. You can install and configure it according to the following steps and start using it in Cline.

✨ Features

• Support querying Azure Storage Tables using OData filters.
• Retrieve the table schema to understand the data structure.
• List all tables in the storage account.
• Provide detailed error handling and response information.
• Offer simple connection string configuration.

📦 Installation

Local Development Environment Setup

1. Clone the repository:

git clone https://github.com/dkmaker/mcp-azure-tablestorage.git
cd mcp-azure-tablestorage

2. Install dependencies:

npm install

3. Build the server:

npm run build

NPM Installation

You can install the package globally via npm:

npm install -g dkmaker-mcp-server-tablestore

Or directly run it using npx:

npx dkmaker-mcp-server-tablestore

Note: When using npx or global installation, you still need to configure the AZURE_STORAGE_CONNECTION_STRING environment variable.

Installation in Cline

To use the Azure Table Storage server in Cline, add it to the MCP settings configuration file. The configuration file is located at:

Windows: %APPDATA%\Code\User\globalStorage\saoudrizwan.claude-dev\settings\cline_mcp_settings.json

Add the following content to the configuration file:

{
  "mcpServers": {
    "tablestore": {
      "command": "node",
      "args": ["C:/path/to/your/mcp-azure-tablestorage/build/index.js"],
      "env": {
        "AZURE_STORAGE_CONNECTION_STRING": "your_connection_string_here"  // Required: Your Azure Storage connection string
      }
    }
  }
}

Replace C:/path/to/your/mcp-azure-tablestorage with the actual path where you cloned the repository.

🔧 Configuration

The server requires the following environment variables:

• AZURE_STORAGE_CONNECTION_STRING: Your Azure Storage account connection string

💻 Usage Examples

Basic Usage

⚠️ Important Note

The query_table tool returns the first 1,000 rows of the result set by default. To get the full results, include the $top=10000 parameter in your query.

# Query the Users table where PartitionKey equals 'ACTIVE'
clitable tablestore query "Users" --where "PartitionKey='ACTIVE'"

# Insert a new record into the Items table
clitable tablestore insert "Items" --json '{"id": 1, "name": "Item 1"}'

# Update an existing record in the Items table
clitable tablestore update "Items" --where "PartitionKey=1" --set "Name='NewItem'"

# Delete records from the Users table where PartitionKey equals 'ARCHIVED'
clitable tablestore delete "Users" --where "PartitionKey='ARCHIVED'"

Output Format

The results of all commands will be presented in a tabular format for easy reading and analysis.

📚 Documentation

Project Structure

src/
├── index.ts              # Main entry file
├── commands/             # Contains definitions for each operation
│   ├── query.ts         # Query table data
│   ├── insert.ts        # Insert new records
│   ├── update.ts        # Update existing records
│   └── delete.ts        # Delete records
└── config.json          # Configuration file containing connection strings and other information

Dependencies

{
  "name": "mcp-azure-tablestorage",
  "version": "1.0.0",
  "dependencies": {
    "@types/azure-storage": "^latest",
    "cli-table": "^latest"
  }
}

📄 License

This project is licensed under the MIT License, which allows you to freely use, modify, and distribute the code, as long as you include the original copyright notice and license terms in the derivative works.