By Source · Workday

Workday + Connect AI

Query Workday worker objects, org structures, and HR data from any AI agent. Connect AI handles WQL syntax, ACL passthrough, and pagination transparently.

Use with Claude  ·  Use with CrewAI

Common objects
Worker Organization Position JobProfile CompensationPlan 
-- Ask Claude Code (or any MCP-aware agent):
--
-- "From Workday, show me the 20 most recently hired employees
-- with their organization."
--
-- Claude generates and runs this SQL via the queryData MCP tool.
-- Standard SQL -- WQL translated automatically.

SELECT
  w.WorkerID,
  w.WorkerName,
  w.HireDate,
  o.OrganizationName
FROM [Workday].[Workday].[Worker] w
LEFT JOIN [Workday].[Workday].[Organization] o
  ON w.OrganizationID = o.OrganizationID
WHERE w.WorkerType = 'Employee'
ORDER BY w.HireDate DESC
LIMIT 20

Tutorials by AI surface

Workday + Claude Agent SDK Onboarding automation, org-chart questions, and headcount analysis via a Python agent.
Workday + CrewAI Multi-agent HR research across org structure, headcount, and workforce metrics.
Workday + OpenAI SDK OpenAI Python SDK assistant for natural-language HR queries against live Workday data.

Known quirks

WQL vs. SQL

Workday uses WQL (Workday Query Language) natively. Connect AI translates standard SQL to WQL transparently, but some advanced WQL features may require raw WQL passthrough via the queryData tool.

ACL passthrough

Workday enforces domain-level security. Configure per-user OAuth delegation in Connect AI to ensure agents only surface data the requesting user is authorized to see.

Existing tutorials

Long-form recipes from the CData Knowledge Base.

View tutorials
Connect AI documentation

Full API reference, authentication guides, and configuration details.

View docs