act-crm-mcp-server-by-cdata

act-crm-mcp-server-by-cdata

3.2

If you are the rightful owner of act-crm-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 Act CRM is a read-only server designed to allow LLMs to query live Act CRM data using natural language.

CData's Model Context Protocol (MCP) Server for Act CRM is a specialized server that facilitates the interaction between large language models (LLMs) and Act CRM data. By leveraging the CData JDBC Driver for Act CRM, this server exposes Act CRM data as relational SQL models, enabling LLMs to access live data without the need for SQL queries. This server is particularly useful for applications like Claude Desktop, where users can ask natural language questions to retrieve real-time information from Act CRM. The server is designed to be read-only, providing a secure way to access data without the risk of unintended modifications. For those seeking full CRUD capabilities, CData offers a more comprehensive MCP Server for Act CRM in beta. The setup process involves cloning the repository, building the server, and configuring the connection to Act CRM using the CData JDBC Driver. Once configured, the server can be integrated with AI clients to enhance data accessibility and usability.

Features

  • Read-only access to Act CRM data
  • Integration with CData JDBC Driver for Act CRM
  • Natural language querying via LLMs
  • Simple MCP interface for data retrieval
  • Secure data access without SQL

Tools

  1. get_tables

    Retrieves a list of tables available in the data source.

  2. get_columns

    Retrieves a list of columns for a specified table.

  3. run_query

    Executes a SQL SELECT query.