CData Paylocity MCP Server
JSON →A read-only MCP server by CData that enables LLMs to query live data from Paylocity.
Tools · 3
- {servername}_get_tables Retrieves a list of tables available in the data source. Use the {servername}_get_columns tool to list available columns on a table. The output of the tool will be returned in CSV format, with the first line containing column headers.
- {servername}_get_columns Retrieves a list of columns for a table. Use the {servername}_get_tables tool to get a list of available tables. The output of the tool will be returned in CSV format, with the first line containing column headers.
- {servername}_run_query Execute a SQL SELECT query