RSS MCP Server by CData is an MCP server that connects LLM clients to live RSS feeds by exposing them as relational data tables through the CData JDBC Driver for RSS. Developed for researchers, analysts, and developers using AI assistants like Claude Desktop, the server wraps the underlying JDBC driver to turn news and syndication feeds into queryable SQL models. Users can interact with live content streams by asking natural language questions rather than writing complex scripts or raw database queries. The server functions over standard input and output (stdio), translating agent inquiries into structured tool calls that fetch tables, inspect column schemas, and execute read-only SELECT queries. It operates locally, allowing language models to inspect schema definitions across subscribed feeds, run queries against recent entries, and aggregate information across sources without needing direct SQL syntax expertise.
Category: Data & Analytics
Tags: cdata, feeds, jdbc, news, rss
bash git clone https://github.com/cdatasoftware/rss-mcp-server-by-cdata.git cd rss-mcp-server-by-cdata 2. Build the project JAR: bash mvn clean install 3. Download, install, and license the CData JDBC Driver for RSS from CData. 4. Run java -jar cdata.jdbc.rss.jar to build and test your connection string. 5. Create a property file named rss.prp with configuration values for Prefix, ServerName, ServerVersion, DriverPath, DriverClass, and JdbcUrl. 6. Add the server entry to your claude_desktop_config.json file: json { "mcpServers": { "rss": { "command": "/PATH/TO/java", "args": [ "-jar", "/PATH/TO/CDataMCP-jar-with-dependencies.jar", "/PATH/TO/rss.prp" ] } } } 7. Restart Claude Desktop completely to load the tools.Part of MCP Servers
Clone the GitHub repository, build the project with Apache Maven using mvn clean install, and install the CData JDBC Driver for RSS. Next, create a properties file specifying your JDBC driver path and connection URL. Finally, register the compiled JAR and property file in your Claude Desktop configuration file under mcpServers, specifying Java as the command.
The server exposes three read-only tools to an MCP client: getting a list of tables, getting column schemas for a table in CSV format, and executing SQL SELECT queries. This lets language models query live RSS feed data using natural language prompts without writing manual database commands.
The server works with any MCP-compliant client that supports standard input and output (stdio) transport running on the same local machine, such as Claude Desktop. Because it relies on stdio, it cannot be hosted directly on a remote server without a compatible bridge.
Yes, this MCP server wrapper is open source and licensed under the MIT License. However, connecting to RSS feeds requires the CData JDBC Driver for RSS, which must be installed, configured, and licensed separately via CData Software.