Advertise
MCP.so
Sign In
P

Paylocity MCP Server by CData

@CDataSoftware

Repository

Basic information

Category

Other

Transports

stdio

Author

CDataSoftware

Submitted by

Cameron Leblanc

About 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 config

Add this server to your MCP-compatible client using the configuration below.

{
  "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 tools

Tool list not available yet

This listing does not currently have a tool list to display. This does not mean the server has no tools; check its documentation for supported capabilities.

We auto-extract tools from the README. The maintainer can list them under a ## Tools heading to populate this section.

Overview

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

Frequently asked questions

1

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.

2

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.

3

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.

4

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.

5

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).

Comments

More Other MCP servers

Soar Flight Booking MCP

Soar Flight Booking MCP is a remote MCP server available at https://mcp.soar.flights.

N

Next Generation Movers: free moving quotes (remote MCP)

Next Generation Movers

Free moving quotes for AI agents from Next Generation Movers, a licensed interstate mover (USDOT 3764697). US long-distance nationwide and local DC/MD/VA. Indicative ballpark price and booking options; optional $0.01 x40

Hindsight

vectorize-io

Hindsight: Agent Memory That Learns

50.4K

Lemon.io

lemon-io

Request dedicated senior developers to work on your project, write job descriptions, and prep technical interviews — all without leaving your Claude chat. Just describe what you need, and Lemon.io MCP does the rest. 1–3

MCP Toolbox for Databases

googleapis

MCP Toolbox for Databases is an open source MCP server for databases.

15.9K
Advertise