Paylocity MCP Server by CData
@CDataSoftware
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
基本情報
設定
以下の設定を使って、このサーバーを MCP 対応クライアントに追加してください。
{
"mcpServers": {
"{classname_dash}": {
"command": "PATH\\TO\\java.exe",
"args": [
"-jar",
"PATH\\TO\\CDataMCP-jar-with-dependencies.jar",
"PATH\\TO\\paylocity.prp"
]
}
}
}ツール
ツールは検出されませんでした
ツールは 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
stdiotransport (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).
「その他」の他のコンテンツ

Sequential Thinking
modelcontextprotocolModel Context Protocol Servers
Blender
ahujasidOpen-source MCP to use Blender with any LLM
Awesome Mlops
visengerA curated list of references for MLOps
🪟 Windows-MCP
CursorTouchMCP Server for Computer Use in Windows
Unity MCP ✨
justinpbarnettUnity MCP acts as a bridge between AI assistants and your Unity Editor. Give your LLM tools to manage assets, control scenes, edit scripts, and automate tasks within Unity.
コメント