This read-only MCP Server allows you to connect to RSS data from Claude Desktop through CData JDBC Drivers. For full CRUD support, check out our MCP Server for RSS (https://www.cdata.com/drivers/rss/download/mcp).
Configuration
View docs{
"mcpServers": {
"cdatasoftware-rss-mcp-server-by-cdata": {
"command": "java",
"args": [
"-jar",
"/PATH/TO/CDataMCP-jar-with-dependencies.jar",
"/PATH/TO/Salesforce.prp"
]
}
}
}You can query live RSS data using a dedicated MCP server that wraps the CData JDBC Driver for RSS. This read-only MCP server exposes your RSS sources through a simple MCP interface so you can ask natural-language questions and retrieve up-to-date information without writing SQL. It is designed for quick, read-only access to live RSS feeds via MCP clients.
Install and run the MCP server, then connect your MCP client to the running process. You will interact with the server by asking questions about your RSS data. The server presents read-only access to tables and columns derived from RSS sources, and it supports built-in tools for discovering available data and executing read queries. You don’t need to know SQL to get answers; just ask in natural language and the client will leverage the MCP tools to fetch the data.
# prerequisites
- Java (JRE/JDK) installed
- Maven for building the server jar
# 1. Clone the repository
git clone https://github.com/cdatasoftware/rss-mcp-server-by-cdata.git
cd rss-mcp-server-by-cdata
# 2. Build the server jar with dependencies
mvn clean install
# This creates the JAR file: CDataMCP-jar-with-dependencies.jar
# 3. Obtain and license the CData JDBC Driver for RSS
download the driver from the RSS JDBC driver page and install it following the provided installer guidance.
# 4. Create a .prp connection descriptor for the driver
# Example contents (rss.prp)
Prefix=rss
ServerName=CDataRSS
ServerVersion=1.0
DriverPath=PATH/TO/cdata.jdbc.rss.jar
DriverClass=cdata.jdbc.rss.RSSDriver
JdbcUrl=jdbc:rss:InitiateOAuth=GETANDREFRESH;
Tables=
# 5. Run the MCP server using the prepared .prp file
java -jar /PATH/TO/CDataMCP-jar-with-dependencies.jar /PATH/TO/rss.prpThe server is started with a single .prp file that contains your JDBC connection information. This MCP server runs in stand-alone mode and is designed for read-only access. You license the CData JDBC Driver during installation, configure your connection string with the Connection String utility, and create the .prp file that the MCP server will consume at runtime. When you start the server, you will see it bind to standard input/output so it can communicate with MCP clients on the same host.
After the server is running, your MCP client can discover available data, list tables and columns, and execute read queries. Use the client’s built-in tools to call the following endpoints: get_tables to retrieve the list of data sources, get_columns to list columns for a given table, and run_query to execute a SELECT against a table. All responses come in the format defined by the MCP client, typically as CSV for column listings and as query results for data requests.
The server exposes the following tools (named with the server name as a prefix): - rss_get_tables: Retrieve a list of available tables. - rss_get_columns: Retrieve a list of columns for a specific table. - rss_run_query: Execute a SQL SELECT query against a table.
If you are scripting against the MCP server, you can issue tool calls using the JSON-RPC format. The following patterns illustrate how to request tables, request columns, and run a query. Adapt the payloads to your client’s MCP endpoint.
If the MCP server does not appear in your client, ensure you have fully started the process and that the correct .prp file is being used. Verify that your Java runtime is installed and that the path to the CDataMCP-jar-with-dependencies.jar and the .prp file are correct. If data cannot be retrieved, double-check your JDBC connection string, including any OAuth flow and token refresh requirements.
This MCP server is released under the MIT License. You may use, modify, and distribute it in compliance with the terms of that license.
RSS is the primary source supported by this MCP server. The server uses the CData JDBC Driver for RSS to expose RSS feeds as relational-like models for querying through MCP.
Retrieves a list of tables available in the data source.
Retrieves a list of columns for a given table. Use this after getting tables.
Executes a SQL SELECT query against a specified table.