Paylocity MCP Server by CData

@CDataSoftware

代码仓库

基本信息

分类

其他

传输方式

stdio

作者

CDataSoftware

提交者

Cameron Leblanc

关于 Paylocity MCP Server by CData

This project builds a read-only MCP server. For full read, write, update, delete, and action capabilities and a simplified setup, check out our free CData MCP Server for Paylocity (beta): https://www.cdata.com/download/download.aspx?sku=KPZK-V&type=beta

#paylocity#mcp-server #data-access

Paylocity MCP Server by CData 配置

使用下面的配置,将此服务器添加到你的 MCP 客户端。

{
  "mcpServers": {
    "{classname_dash}": {
      "command": "PATH\\TO\\java.exe",
      "args": [
        "-jar",
        "PATH\\TO\\CDataMCP-jar-with-dependencies.jar",
        "PATH\\TO\\paylocity.prp"
      ]
    }
  }
}

Paylocity MCP Server by CData 工具

工具列表暂未提供

当前收录暂时没有可展示的工具列表，不代表服务没有工具。请查阅项目文档了解支持的能力。

工具是从 README 中自动提取的。维护者可以在 ## Tools 标题下列出工具,即可填充这部分内容。

概览

What is Paylocity MCP Server by CData?

Paylocity MCP Server by CData is a read-only Model Context Protocol server that allows large language models (like Claude Desktop) to query live data from Paylocity. It wraps the CData JDBC Driver for Paylocity, exposing Paylocity data as relational SQL models accessible through a simple MCP interface — no SQL required by the user.

How to use Paylocity MCP Server by CData?

Clone the repository, run mvn clean install to build the JAR, download and license the CData JDBC Driver for Paylocity, and create a .prp file with connection properties. Configure Claude Desktop by adding the server to claude_desktop_config.json with the path to Java, the JAR, and the .prp file. Once running, ask natural language questions about Paylocity data.

Key features of Paylocity MCP Server by CData

Exposes Paylocity data as MCP tools via CData JDBC Driver
Provides three tools: get_tables, get_columns, run_query
Queries live data with natural language — no SQL required
Read-only server; full CRUD available in beta version
Uses stdio transport (client must run on same machine)
Licensed under MIT

Use cases of Paylocity MCP Server by CData

Ask an AI assistant for current employee counts or department summaries
Retrieve payroll history or benefit enrollment data via chat
Generate reports by querying Paylocity tables without writing SQL
Integrate Paylocity data into AI-driven analytics workflows

常见问题

What is Paylocity MCP Server by CData?

It is a read-only MCP server that enables LLMs to query live Paylocity data using the CData JDBC Driver for Paylocity. It is built for scenarios where retrieval of information is the primary need.

How do I set up the server?

You need Java, Maven, and the CData JDBC Driver for Paylocity (license required, TRIAL available). Clone the repo, build with `mvn clean install`, create a `.prp` file with the JDBC connection string, and configure your AI client to launch the JAR.

What tools does the server provide?

The server exposes three tools: `{prefix}_get_tables` (list available tables), `{prefix}_get_columns` (list columns of a table), and `{prefix}_run_query` (execute a SQL SELECT query). All output is CSV format.

Is this server read-only?

Yes, this project builds a read-only MCP server. For full create, update, delete, and action capabilities, CData offers a free beta MCP Server for Paylocity with a simplified setup.

What transport and dependencies are required?

The server communicates over `stdio`, so the client must run on the same machine. It requires Java JDK, Maven, and a licensed CData JDBC Driver for Paylocity (installed separately).

其他分类下的更多 MCP 服务器

Codelf

unbug

A search tool helps dev to solve the naming things problem.

14.2K

DeepMark

DeepMark helps teachers deliver rapid, consistent marking with meaningful feedback for every student — in a fraction of the time. What once took a week, now takes one free period.

Handl

Handl speaks the Model Context Protocol. Your whole billing operation — projects, invoices, clients, reports, approvals — as tools any AI assistant can call, inside your autonomy rules.