SQL Server Analysis Services MCP Server by CData

Created By

CDataSoftware7 months ago

This project builds a read-only MCP server. For full read, write, update, delete, and action capabilities and a simplified setup, check out our free [CData MCP Server for SQL Server Analysis Services (beta)](https://www.cdata.com/download/download.aspx?sku=FYZK-V&type=beta).

# sql-server

# mcp-server

Overview Content Tools Comments

Overview

What is SQL Server Analysis Services MCP Server?

The SQL Server Analysis Services MCP Server by CData is a read-only Model Context Protocol (MCP) server designed to allow large language models (LLMs) to query live data from SQL Server Analysis Services using natural language, without the need for SQL queries.

How to use SQL Server Analysis Services MCP Server?

To use the MCP Server, clone the repository, build the server, install the CData JDBC Driver, configure your connection, and create a configuration file for your AI client (e.g., Claude Desktop). Finally, run the server and interact with it through your AI client.

Key features of SQL Server Analysis Services MCP Server?

Provides a read-only interface for SQL Server Analysis Services data.
Allows querying of live data using natural language.
Simplifies data access for AI applications without requiring SQL knowledge.

Use cases of SQL Server Analysis Services MCP Server?

Enabling AI models to retrieve and analyze business intelligence data.
Facilitating data-driven decision-making through natural language queries.
Integrating with AI clients for seamless data interaction.

FAQ from SQL Server Analysis Services MCP Server?

Can I write data using this MCP Server?

No, this server is read-only. For write capabilities, consider the full CData MCP Server for SQL Server Analysis Services.

Is there a trial version available?

Yes, you can access a free trial of the CData MCP Server for SQL Server Analysis Services.

What kind of data sources can I connect to?

The server supports various data sources, including Salesforce, and many others as listed in the documentation.

Server Config

{
  "mcpServers": {
    "{classname_dash}": {
      "command": "PATH\\TO\\java.exe",
      "args": [
        "-jar",
        "PATH\\TO\\CDataMCP-jar-with-dependencies.jar",
        "PATH\\TO\\ssas.prp"
      ]
    }
  }
}

Recommend Servers

TraeBuild with Free GPT-4.1 & Claude 3.7. Fully MCP-Ready.

AiimagemultistyleA Model Context Protocol (MCP) server for image generation and manipulation using fal.ai's Stable Diffusion model.

Howtocook Mcp基于Anduin2017 / HowToCook （程序员在家做饭指南）的mcp server，帮你推荐菜谱、规划膳食，解决“今天吃什么“的世纪难题； Based on Anduin2017/HowToCook (Programmer's Guide to Cooking at Home), MCP Server helps you recommend recipes, plan meals, and solve the century old problem of "what to eat today"

CursorThe AI Code Editor

Tavily Mcp

DeepChatYour AI Partner on Desktop

Visual Studio Code - Open Source ("Code - OSS")Visual Studio Code

EdgeOne Pages MCPAn MCP service designed for deploying HTML content to EdgeOne Pages and obtaining an accessible public URL.

BlenderBlenderMCP connects Blender to Claude AI through the Model Context Protocol (MCP), allowing Claude to directly interact with and control Blender. This integration enables prompt assisted 3D modeling, scene creation, and manipulation.

Zhipu Web SearchZhipu Web Search MCP Server is a search engine specifically designed for large models. It integrates four search engines, allowing users to flexibly compare and switch between them. Building upon the web crawling and ranking capabilities of traditional search engines, it enhances intent recognition capabilities, returning results more suitable for large model processing (such as webpage titles, URLs, summaries, site names, site icons, etc.). This helps AI applications achieve "dynamic knowledge acquisition" and "precise scenario adaptation" capabilities.

WindsurfThe new purpose-built IDE to harness magic