WordPress

Provides a read-only MCP server exposing live WordPress data through MCP for natural-language exploration by AI clients.

other

0

GitHub Stars

other

Language

7 months ago

First Indexed

3 months ago

Catalog Refreshed

Documentation & install

Readme and setup notes from the catalogue, plus a client-ready config you can copy for your MCP host.

Installation

Add the following to your MCP client configuration file.

Configuration

View docs

{
  "mcpServers": {
    "cdatasoftware-wordpress-mcp-server-by-cdata": {
      "command": "java",
      "args": [
        "-jar",
        "/PATH/TO/CDataMCP-jar-with-dependencies.jar",
        "/PATH/TO/wordpress.prp"
      ]
    }
  }
}

You run a local, read-only MCP server that exposes live WordPress data to LLMs through a simple MCP interface. It lets you ask natural-language questions about your WordPress data and get answers without writing SQL, while keeping the data access read-only.

How to use

Once the MCP server is running, connect your MCP client to the local process. Use natural-language prompts to ask questions about your WordPress data and have the client translate those prompts into the built-in tools the server exposes. For example, you can ask about the status of posts, comments, or custom data you expose through the WordPress connection, and the client will retrieve results from the WordPress data source without requiring you to write SQL.

How to install

Prerequisites: you will need Java installed on your machine to run the MCP server. You may also need Maven for building the server from source.

# 1) Clone the project and prepare the folder
git clone https://github.com/cdatasoftware/wordpress-mcp-server-by-cdata.git
cd wordpress-mcp-server-by-cdata

# 2) Build the server to produce the JAR with dependencies
mvn clean install

Download and install the CData JDBC Driver for WordPress. The driver enables WordPress data to be exposed as relational models. Access the download here: https://www.cdata.com/drivers/wordpress/download/jdbc
License the CData JDBC Driver. Open a terminal in the driver installation folder and run the license command, then enter your name, email, and a license key (TRIAL is acceptable for evaluation): java -jar cdata.jdbc.wordpress.jar --license
Configure your connection to the WordPress data source. Run the connection string utility to test and generate the connection string: java -jar cdata.jdbc.wordpress.jar Follow the prompts to configure the WordPress connection; click Test Connection. If OAuth is required, complete authentication in your browser. Copy the resulting connection string for the next step.
Create a .prp file that holds the JDBC connection details for the MCP server. Name it wordpress.prp and include at minimum the properties shown below. Replace values with your actual paths and strings.

Prefix=wordpress
ServerName=CDataWordPress
ServerVersion=1.0
DriverPath=/path/to/cdata.jdbc.wordpress.jar
DriverClass=cdata.jdbc.wordpress.WordPressDriver
JdbcUrl=jdbc:wordpress:InitiateOAuth=GETANDREFRESH;
Tables=

Running the Server

To run the MCP server locally, execute the following command. The server runs in stdio mode, so the client must be on the same machine.

java -jar /PATH/TO/CDataMCP-jar-with-dependencies.jar /PATH/TO/Salesforce.prp

Available tools

wordpress_get_tables

Retrieves a list of available WordPress data tables. Output is CSV with a header row.

wordpress_get_columns

Retrieves columns for a specified WordPress table. Output is CSV with a header row.

wordpress_run_query

Executes a SQL SELECT query against the WordPress data exposed by the JDBC driver.