sage-200-mcp-server-by-cdata

sage-200-mcp-server-by-cdata

3.2

If you are the rightful owner of sage-200-mcp-server-by-cdata and would like to certify it and/or have it hosted online, please leave a comment on the right or send an email to henry@mcphub.com.

CData's Model Context Protocol (MCP) Server for Sage 200 is a read-only server designed to allow LLMs to query live data from Sage 200 using the CData JDBC Driver.

The CData MCP Server for Sage 200 is a specialized server that facilitates the interaction between large language models (LLMs) and the Sage 200 data system. By leveraging the CData JDBC Driver, this server exposes Sage 200 data as relational SQL models, enabling LLMs to access live data through natural language queries without the need for SQL knowledge. This server is particularly useful for applications that require real-time data retrieval from Sage 200, such as business intelligence tools and AI-driven analytics platforms. The server is built to be read-only, ensuring data integrity while providing seamless access to the underlying data structures. Users can set up the server by cloning the repository, building the server, and configuring the connection to the Sage 200 data source. The server is compatible with various platforms, including Claude Desktop, and can be integrated into existing workflows to enhance data accessibility and decision-making processes.

Features

  • Read-only access to Sage 200 data
  • Integration with CData JDBC Driver for seamless data exposure
  • Natural language querying without SQL
  • Compatible with LLMs like Claude Desktop
  • Simplified setup and configuration

Tools

  1. source_get_tables

    Retrieves a list of tables available in the data source.

  2. source_get_columns

    Retrieves a list of columns for a specified table.

  3. source_run_query

    Executes a SQL SELECT query.