Paylocity MCP Server by CData

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