OneNote MCP Server by CData

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.

Which tables are exposed by default?

All tables are exposed unless you explicitly list specific tables in the .prp file.

What transport does the server use?

The server uses stdio transport, so it must run on the same machine as the MCP