sharepoint-mcp-server-by-cdata

sharepoint-mcp-server-by-cdata

0
cloud_platformsdatabases

CData's Model Context Protocol (MCP) Server for SharePoint allows large language models to query live SharePoint data through natural language questions. It provides a read-only server that uses the CData JDBC Driver to expose SharePoint data via a simple interface, eliminating the need for SQL knowledge.

Overview

CData's Model Context Protocol (MCP) Server for SharePoint is a read-only server designed to allow large language models (LLMs) to query live data from SharePoint using natural language, without needing SQL. This server leverages the CData JDBC Driver to expose SharePoint data as a relational SQL model and makes it accessible through a simple MCP interface.

Features

  • Read-only MCP Server
  • Utilizes CData JDBC Driver for SharePoint
  • Provides data access via natural language queries

Setup Guide

  • Clone the repository.
  • Build the server with Maven.
  • Install and license the CData JDBC Driver.
  • Configure the connection to the data source.
  • Set up the .prp file for JDBC connection.

Usage

The server allows AI clients to read, write, update, and delete underlying data using built-in tools and commands.

Tools & Descriptions

  • {servername}_get_tables: Retrieves a list of tables.
  • {servername}_get_columns: Retrieves a list of columns for a table.
  • {servername}_run_query: Executes a SQL SELECT query.

Troubleshooting

  • Ensure proper configuration of your connection.
  • Use the Connection String builder to assist in setup.