exact-online -by-cdata

This MCP server provides a read-only interface to Exact Online data by wrapping the CData JDBC driver in a Model Context Protocol (MCP) server. Once running, clients (such as Claude Desktop or other MCP-enabled tools) can query live data from Exact Online using natural language prompts, without writing SQL. The server exposes basic tools that allow listing available tables and columns, and running SQL-like queries against the data source. To use it, start the server with the Java command and point it at your Exact Online PRP configuration file, then connect your MCP client to the server using the configured classname (as shown in the Claude Desktop config examples). The server operates over stdio, so it typically runs on the same machine as the client.

Tools available (per the README):

• {servername}_get_tables: Retrieves a list of tables available in the data source. Output is CSV with column headers.
• {servername}_get_columns: Retrieves a list of columns for a specific table. Output is CSV with column headers.
• {servername}_run_query: Executes a SQL SELECT query against the data source.

JSON-RPC examples are provided in the README for invoking these tools via a client, following the jsonrpc 2.0 format. While you generally do not need to call the tools directly, you can script requests to list tables, inspect columns, or run specific queries as needed.

Prerequisites:\n- Java Runtime Environment (JRE) or JDK installed and accessible on your system. Ensure java -version runs successfully.\n- Maven (for building the MCP server) if you intend to compile from source.\n- A valid CData JDBC Driver for Exact Online installed and licensed. Follow the license steps in the README if you are using the JDBC driver locally.\n- Access to the Exact Online data via the CData JDBC Driver and a JDBC connection string (to be placed in a .prp file).\n\nInstallation steps:\n1) Build the MCP server (if you have the source):\nbash\nmvn clean install\n\nThis produces CDataMCP-jar-with-dependencies.jar.\n2) Obtain and license the CData JDBC Driver for Exact Online as described in the README (download jar, run license command, etc.).\n3) Create the exact-online.prp file with your JDBC connection parameters as shown in the setup guide (Prefix, ServerName, ServerVersion, DriverPath, DriverClass, JdbcUrl, Tables).\n4) Start the server using the provided command configuration, pointing to the exact-online.prp file:\nbash\njava -jar CDataMCP-jar-with-dependencies.jar /PATH/TO/exact-online.prp\n\n5) Connect your MCP client (e.g., Claude Desktop) to the server using the classname and the same prp path configuration as described in the Claude Desktop config section of the README.

Notes and tips:\n- The MCP server runs on stdio, so it is intended for clients and tools running on the same machine. Ensure your client can access the server’s stdio channel.\n- This solution is read-only by default (as described in the README). If you require write/delete capabilities, consider using the full MCP server variant referenced in CData documentation.\n- If you encounter connection or data retrieval issues, verify that the JDBC connection string is correctly configured and test the connection using the CData Connection String utility provided by the driver.\n- The server relies on the Exact Online data accessible through the JDBC driver; OAuth and connection authentication may require browser-based authentication during the initial connection setup.\n- Ensure the exact-online.prp file is correctly formatted and path references are accurate for your OS (Windows vs. Linux/macOS).