Peliqan

Query and update AFAS with AI

Connect AFAS to Claude, ChatGPT, or any MCP client through Peliqan. Ask questions in plain English across HR, payroll, finance, and CRM, and write updates back to AFAS – no Get Connector and Update Connector setup, no read-only compromises.

Pulling answers out of AFAS still takes too many clicks

AFAS Profit runs your HR, payroll, finance, and CRM in one place – but every quick question still means logging in, navigating modules, exporting reports, and reconciling numbers in Excel. HR, finance, and operations teams lose hours on questions Claude could answer in seconds.

No natural language interface

"Show me sick leave by department this quarter" still means filters, custom Get Connector queries, exports, and pivot tables

AFAS API needs Get Connector configuration per query

Every new question means going back to AFAS to define a Get Connector - heavy AI workloads multiply that maintenance burden

No cross-source joins

Combining AFAS with HubSpot CRM, Exact Online, ecommerce platforms, or banking data means custom integrations and a separate warehouse

Most AFAS MCP options are HR-only

Generic HRIS-scoped MCP servers cover employee data only - they miss the finance, CRM, and projects modules that drive operational reporting

Query employees, payroll, invoices, GL, CRM, and projects in plain English

Write changes back - update employees, post invoices, create CRM records, manage workflows

Join with 250+ apps - combine AFAS with HubSpot, banking, ecommerce, or any source

SOC 2 Type II certified – enterprise-grade security

Type

All-in-one ERP, HR, payroll and CRM platform

Customers

14,000+ organisations across the Benelux

Website

One MCP server. Read, write, and join across 250+ sources.

Peliqan syncs your AFAS data into a built-in Postgres warehouse, exposes it via MCP for instant AI access, and routes writebacks through Peliqan’s connector layer so your live AFAS environment stays protected from rate limits and unsafe writes.

Full read + write across all AFAS modules

Where HRIS-scoped MCP wrappers stop at employee data, Peliqan covers HR, payroll, finance, CRM, projects, and workflow with full writeback. Update employees, post invoices, create CRM records, manage projects - all from Claude, ChatGPT, or n8n.

Cached warehouse, never the live API

Your AI queries a Postgres warehouse, not AFAS REST API directly. No need to define a Get Connector for every new question, no slowdowns during month-end payroll. Sync runs incrementally on your schedule (every 15 minutes by default).

Cross-source queries in one SQL statement

Join AFAS payroll data with HubSpot CRM, Exact Online accounting, or banking data in a single query. Federated via Trino, all in Peliqan's shared warehouse.

SQL + RAG on AFAS documents

Combine structured SQL queries with semantic search across employee contracts, invoice PDFs, workflow attachments, and free-text fields. The only AFAS MCP that answers questions about both your numbers and your documents.

Claude + AFAS MCP
Claude + AFAS MCP
What's our sick leave rate by department this quarter, and which teams are trending above 5%?
✓ Querying afas.employees and afas.absence...

Company average: 3.8% across 6 departments and 412 employees.
2 departments trending above the 5% threshold:
  • Logistics - 6.4% (87 employees)
  • Customer Service - 5.7% (54 employees)
  • Both up vs same quarter last year
Update Anna van Dijk's contract end date to 31 December and add a note for the HR business partner.
✓ Employee record updated in AFAS via writeback

Key AFAS data available via MCP

Peliqan syncs AFAS Get Connector data into structured warehouse tables that your AI can query directly across HR, payroll, finance, CRM, and projects.

Entity What your AI can answer Writeback
Employees / ContractsHeadcount, contract types, end dates, FTE, probation periods
Payroll / SalarySalary scales, payroll cost per period, gross-to-net, holiday pay
Absence / LeaveSick leave rate, leave balance, absence patterns, return-to-work
SalesInvoices / GLRevenue by customer, P&L by department, GL drill-down, invoice aging
Debtors / CreditorsReceivables and payables, debtor/creditor aging, payment terms
CRM / OrganisationsCustomer records, contact history, sales activity, segmentation
Projects / HoursProject profitability, billable vs non-billable hours, budget vs actuals
Workflow / ApprovalsOpen approvals, workflow status, bottlenecks, SLA tracking
Cost Centres / DepartmentsDepartment-level reporting, cost centre allocation, budget trackingRead
Documents / AttachmentsEmployee contracts, invoice PDFs, workflow attachments – queryable via RAGRead

What finance teams build with AFAS MCP

HR analytics

Workforce briefings on demand

"Pull this month's headcount, sick leave, and overtime by department - flag anything trending above last quarter and draft a board summary." Claude queries your AFAS warehouse and returns a Slack-ready summary in seconds.

Useful for: HR managers, CHROs

Payroll automation

Payroll anomaly checks

Build an AI agent that runs before each payroll close, scans AFAS payroll data for anomalies (overtime spikes, missing hours, contract changes), and drafts a checklist for the payroll team. Peliqan writeback updates AFAS notes automatically.

Powered by: n8n + Peliqan MCP

Finance and AR

Cash collection assistant

"Pull all overdue AFAS invoices over 30 days, group by customer, and draft personalised reminder emails - log each as a CRM note." Joins AFAS sales invoices, debtor records, and CRM organisations in one query.

Useful for: Controllers, AR specialists

Multi-entity reporting

Group-wide consolidation

For groups running multiple AFAS environments - ask Claude to consolidate revenue, headcount, and margin across entities. One query covers every entity without manual file-switching, and the warehouse handles currency and chart-of-accounts mapping.

Useful for: Group controllers, CFOs

Always-fresh copy, never the live API

Peliqan keeps a working copy of your AFAS data in a Postgres warehouse, refreshed on your schedule. AI queries the warehouse for speed and safety. When AI needs to make a change, Peliqan routes the writeback through its connector layer – never letting AI hit the live AFAS REST API directly.

 

AI never hits the AFAS API directly

All queries route through Peliqan's warehouse. Writebacks route through Peliqan's connector. Your live AFAS environment never sees a raw AI request.

No Get Connector sprawl

Heavy AI workloads don't mean defining a new Get Connector for every question. The warehouse exposes the full data model so your AI can answer anything via SQL.

Always fresh, on your schedule

Incremental syncs run as often as every 5 minutes. You decide the cadence based on how fresh your HR, finance, or controlling team needs the data.

Full data, every record

HR, payroll, finance, CRM, projects, workflow - not just employee data. Ready for cross-source joins, Text-to-SQL, and RAG on attached documents.

AI Clients
Claude
ChatGPT
AI Agents
MCP Protocol
Protocol Layer
Peliqan MCP Server
Query - Writeback - Cross-source joins
SQL Query
Cache Layer
Peliqan Data Warehouse
Full read-only copy - Always in sync
Postgres
Trino
SQL + RAG
ELT Sync
Source Apps
Exact Online
AFAS
Salesforce
250+
Live systems stay safe - AI only queries the read-only cache

How to set up the AFAS MCP server

1

Authenticate AFAS

Click the AFAS connector in Peliqan and enter your AFAS environment number and AppConnector token. Peliqan handles the REST API session lifecycle and Get Connector mapping. Setup guide →

2

Select and materialize tables

Choose which AFAS entities to sync – employees, contracts, payroll, sales invoices, GL, CRM organisations, projects. Peliqan materializes them into Postgres on your schedule (default: every 15 minutes). One sync covers data your AI would otherwise need dozens of Get Connectors for. Materializing tables →

3

Create your MCP API handler

Use Peliqan’s built-in MCP template to expose the AFAS tables and operations your AI agents need. Set role-based permissions for read, write, or both – column-level masking for sensitive payroll and personal data supporte. AI agents docs →

4

Connect Claude or ChatGPT

Run pip install mcp-server-peliqan, add your Peliqan API credentials, and start querying AFAS with natural language. Open source on  GitHub.

Peliqan vs other AFAS MCP options

A few AFAS MCP options exist – HRIS-scoped wrappers and DIY REST integrations. Here’s how they compare for full-platform AI use cases.

HRIS-scoped MCP wrappers DIY REST wrapper Peliqan MCP
Module coverageHR onlyCustom build✓ HR + finance + CRM + projects
Writeback to AFASLimitedCustom code✓ Audited writeback
Cached warehouse✗ Live API✗ Live API✓ Postgres + Trino
Cross-source queries✓ 250+ sources
RAG on documents✓ SQL + RAG combined
Setup timeHoursWeeks✓ Under 30 minutes
EU data residencyVariesSelf-hosted✓ EU-hosted
BI + ETL + reverse ETL✗ MCP only✗ MCP only✓ Full data platform

Enable MCP for AFAS

Learn how to enable the MCP server for AFAS in Peliqan. See how to connect AI assistants like Claude to your live AFAS employees, payroll, invoices, and CRM data in just a few steps.

The full Peliqan AFAS integration

MCP is one part of what Peliqan offers for AFAS. The full integration gives you a complete data platform for HR analytics, finance reporting, and AI-powered automation.

Connect your favourite BI tool, write data transformations in SQL or Python, and set up data quality checks – all on the same platform.

ELT connector

Full sync into built-in warehouse

MCP server

Claude, ChatGPT, n8n, Make

Text-to-SQL

Plain English financial queries

Reverse ETL

Push data back to AFAS

RAG + Graph RAG

Semantic search on documents

Data quality

SQL checks + Slack/email alerts

AFAS MCP, answered

What is the AFAS MCP server?

The AFAS MCP server is a Model Context Protocol endpoint that exposes your AFAS Profit data to AI agents like Claude, ChatGPT, and Cursor. Peliqan’s AFAS MCP server lets AI query employees, payroll, invoices, GL, CRM, and projects in plain English, and write updates back to AFAS – without writing custom REST integrations or defining a Get Connector for every question.

Authenticate AFAS in Peliqan with your AFAS environment number and AppConnector token, pick the entities to sync, and add the Peliqan MCP endpoint to Claude Desktop, ChatGPT, Cursor, or n8n. Most teams go from AFAS authentication to first AI query in under 30 minutes. Full setup steps are in the guide above.

Peliqan’s AFAS MCP covers all the modules AFAS Profit users care about – HR, payroll, absence, finance (sales invoices, GL, debtors, creditors), CRM, projects, and workflow. Most generic HRIS-scoped MCP wrappers only expose employee and payroll data, which limits the questions your AI can answer.

Peliqan supports both read and write through AFAS Update Connectors. Your AI agent can query AFAS data and also update employee records, post invoices, create CRM entries, and trigger other AFAS actions, with full audit logging. Writebacks route through Peliqan’s connector layer for safety – so AI never accidentally posts malformed updates to your live AFAS environment.

No. Peliqan syncs your AFAS data into a built-in Postgres warehouse once, and your AI queries the warehouse via SQL. You don’t need to go back to AFAS to define a new Get Connector every time someone asks a different question. The warehouse exposes the full data model, so AI can answer anything covered by the entities you’ve synced.

Peliqan is EU-hosted, SOC 2 Type II certified, and GDPR-compliant. Row-level and column-level access control let you mask or exclude sensitive fields (BSN numbers, salary amounts, bank details, contract terms) from AI agents while still allowing operational queries. Every AI query and writeback is logged with full audit trail.

Yes. Peliqan handles multi-environment AFAS automatically – one Peliqan workspace can sync several AFAS environments, and your AI agent can run queries across them. Useful for groups with separate AFAS instances per legal entity, or for accounting and HR partners running AFAS for multiple clients.

No. Peliqan includes a built-in Postgres + Trino warehouse. Your AFAS data lands there automatically – no Snowflake, BigQuery, or dbt project required. If you already have a warehouse, Peliqan can sync to it as well, so your existing BI dashboards and reporting stay intact.

Unify, Automate & Activate Your Data 

Connect all your SaaS apps, databases, and spreadsheets into one workspace. Build automations, analytics pipelines, and data apps – all in one place.

G2 Badges

Peliqan is secure

Security, compliance, trust, privacy and availability are our highest priority. If you want more details, if you require a certificate or a copy of Peliqan’s operating procedures, contact us now.

SOC 2 Type II

SOC 2 Type 2 validates our security controls, ensuring your data is protected by independently audited security measures.

ISO 27001

ISO 27001 certification ensures enterprise-grade information security, protecting your business with globally recognized standards.

GDPR-compliant

GDPR compliance guarantees EU data protection compliance, keeping PII data secure within EU boundaries.

Skip the REST wrapper. Skip Get Connector sprawl. Start writing back from day one.

Connect AFAS, publish your MCP server, and let Claude (or ChatGPT, or n8n) answer HR, payroll, finance, and CRM questions and update records – in minutes.

No credit card required  ·  SOC 2 Type II certified · 2 weeks custom connector SLA