OneNote MCP Server by CData

Name: OneNote MCP Server by CData
Author: CDataSoftware

@CDataSoftware

About OneNote MCP Server by CData

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 OneNote (beta): https://www.cdata.com/download/download.aspx?sku=UNZK-V&type=beta

#onenote #mcp-server #cdata

Basic information

Config

Add this server to your MCP-compatible client using the configuration below.

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

Tools

No tools detected

We auto-extract tools from the README. The maintainer can list them under a ## Tools heading to populate this section.

Overview

What is OneNote MCP Server by CData?

This read-only MCP server lets LLMs query live Microsoft OneNote data using the CData JDBC Driver for OneNote, exposing notebooks, sections, and pages as relational SQL tables without requiring the user to write SQL.

How to use OneNote MCP Server by CData?

Clone the repository, build with Maven, install and license the CData JDBC Driver for OneNote, create a .prp file with the JDBC connection string, then add the server to your Claude Desktop config and launch.

Key features of OneNote MCP Server by CData?

Read-only access to OneNote data via MCP
Uses CData JDBC Driver for SQL-based queries
Exposes tools: get_tables, get_columns, run_query
Accepts natural language questions through LLMs
Communicates via stdio transport (same machine only)

Use cases of OneNote MCP Server by CData?

Ask an LLM to summarize your OneNote notebooks or sections
Retrieve live notes without writing SQL queries
Integrate OneNote data into AI-driven analytics workflows

FAQ from OneNote MCP Server by CData?

Is this server read-only?

Yes, this server provides read-only access. For full create, read, update, and delete capabilities, use the CData MCP Server for OneNote (beta) linked in the README.

What are the runtime requirements?

Java and the CData JDBC Driver for OneNote must be installed and licensed on the same machine as the MCP client.

How do I configure a connection?

Create a .prp file with the JDBC connection string obtained from the driver’s Connection String utility, including OAuth settings. The server reads this file at startup.