Paylocity MCP Server by CData

@CDataSoftware

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

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"
      ]
    }
  }
}

Tools

No tools detected

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

FAQ from Paylocity MCP Server by CData

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

Frequently asked questions

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

Comments

Basic information

More Other MCP servers

Production-ready MCP integrations for AI applications

Klavis-AI

Klavis AI: MCP integration platforms that let AI agents use tools reliably at any scale

5.8K

AutoBrowser MCP

autobrowser-ai

Browser MCP is a Model Context Provider (MCP) server that allows AI applications to control your browser

6.8K

Peekaboo MCP – lightning-fast macOS screenshots for AI agents

steipete

Peekaboo is a macOS CLI & optional MCP server that enables AI agents to capture screenshots of applications, or the entire system, with optional visual question answering through local or remote AI models.

4.8K

ghidraMCP

LaurieWired

MCP Server for Ghidra

9.4K

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.