hilan-mcp
An MCP server for Hilan (Hilanet / חילן, חילנט) — pull your payslips and Form 106 into any AI assistant, for any Hilan tenant.
There's no official Hilan API. hilan-mcp drives a real (headless) Chromium
browser via Playwright to log in, then reuses
that same authenticated session to call Hilan's internal endpoints and
download PDFs — no fragile hand-rolled cookie replay, and no plaintext
secrets stored anywhere.
Table of contents
- Features
- How it works
- Setup
- For AI agents setting this up on a user's behalf
- MCP tools
- Scope
- Reliability notes
- Security model
- Development
- License
Features
- 📄 Payslips — structured Bruto/Neto/salary-parts data, plus the PDF, for any month in the tenant's history.
- 🧾 Form 106 — annual tax summary PDFs, per year.
- 🔐 Encrypted local storage — SQLCipher-encrypted SQLite, key never written to disk in plaintext; OS-native credential store (Keychain/DPAPI/Secret Service) support.
- 🏢 Any Hilan tenant — login form fields are detected per-tenant instead of hardcoded to one employer.
- 💬 Answers, not raw JSON — tools like
queryanswer "how much did I earn in June?" straight from local data, no network round-trip. - 🔄 Self-updating awareness — the server checks for newer versions and lets your AI agent offer to update you, without needing its own UI.
How it works
This server drives a real (headless) Chromium browser via
Playwright to log in, then reuses that same
authenticated browser context's HTTP client (context.request) to call
Hilan's internal .asmx JSON endpoints and download PDFs — so it
automatically inherits whatever cookies/headers a real page load would
have set up, instead of a fragile hand-rolled cookie replay.
Login form fields differ per Hilan tenant (some have 2 fields, some 3), so the login form is inspected fresh for each tenant the first time you ingest credentials, rather than hardcoded to one company.
Setup
1. Register a tenant and enter credentials
Run this yourself, directly in your own terminal — never paste real
credentials into an AI chat. It installs the Chromium browser Playwright
needs (one-time), launches a headless browser, detects your tenant's actual
login fields, and prompts you for each one (passwords are masked). No local
clone or npm install needed — npx fetches the package on the fly:
npx hilan-mcp setup --tenant amdocs # tenant subdomain
# or
npx hilan-mcp setup --tenant 5227 # numeric org code, resolved automatically
If you already have the package installed some other way, the equivalent lower-level command is
npx hilan-mcp ingest-creds --tenant <...>—setupjust also handles the one-time Chromium install first.
The first time you run this you'll be asked to set an encryption key for the local database (min 6 characters) — this key is never written to disk in plaintext.
For the MCP server to open the database on its own (without a human present to respond to a prompt every time), it looks for the key in this order:
- OS credential store (recommended) — run
npx hilan-mcp setup-keyonce, yourself, in your own terminal. You'll be asked to type a key (or press Enter to generate a strong random one), and it's stored in your OS's native secure storage: macOS Keychain (verified — same file that holds your Wi-Fi/browser passwords, silent, no dialogs), Windows (DPAPI, tied to your Windows user account), or Linux (Secret Service /secret-tool, needs a keyring daemon like GNOME Keyring or KWallet). Nothing ends up in any config file at all. HILAN_DB_KEYenv var — set it in the server'senvblock (see step 2). Same trust model as any other API key/secret configured for an MCP server inmcp.json(local file, not committed to git).- Desktop notification (last resort) — the server falls back to asking via a system notification (with a plain terminal prompt as a further fallback), but that requires a human to respond within ~30s of every tool call that needs the database, so it's not recommended for normal use.
2. Add the server to your MCP client config
Running the package with no arguments starts the MCP server itself (stdio transport) — that's what your MCP client's config actually invokes:
{
"mcpServers": {
"hilan": {
"command": "npx",
"args": ["-y", "hilan-mcp"]
}
}
}
Single-employer setup — skip passing tenant on every tool call
If you only ever use this for one employer, you can set a default
tenant in the server's env block. Only the first of these that's set
is used, in this order — COMPANY_URL → COMPANY_TENANT → COMPANY_CODE:
{
"mcpServers": {
"hilan": {
"command": "npx",
"args": ["-y", "hilan-mcp"],
"env": {
"COMPANY_TENANT": "amdocs",
"HILAN_DB_KEY": "the-encryption-key-you-set-during-ingest-creds",
"NODE_EXTRA_CA_CERTS": "/path/to/your-corporate-ca-bundle.pem"
}
}
}
}
HILAN_DB_KEY is only needed if you didn't run npx hilan-mcp setup-key
(see step 1) — the OS credential store takes priority when both are
present. NODE_EXTRA_CA_CERTS is only needed on networks with a
TLS-intercepting corporate proxy (see Reliability notes) — omit it otherwise.
| Env var | Example | Notes |
|---|---|---|
COMPANY_URL | https://amdocs.net.hilan.co.il | Highest priority. |
COMPANY_TENANT | amdocs | Bare subdomain. Used only if COMPANY_URL isn't set. |
COMPANY_CODE | 5227 | Numeric org code. Used only if neither above is set — requires an extra lookup round-trip. |
This same fallback also applies to npx hilan-mcp ingest-creds —
--tenant is optional if one of these env vars is set. An explicit
tenant argument (or --tenant flag) always overrides the env vars.
Running from a local clone instead of the published package
Use "command": "node", "args": ["/absolute/path/to/hilan-mcp/dist/cli/index.js"]
(after npm install && npm run build in that clone) instead of the npx
form above.
3. Use it
Ask your assistant things like "sync my last 3 payslips from Hilan",
"download my Form 106 for 2025", or "how much net/gross did I earn in June
2026?" (answered instantly from the local database via the query tool,
no network round-trip, once that month has been synced at least once) — see
the full tool list below.
For AI agents (e.g. Claude) setting this up on a user's behalf
If a user asks you to set up hilan-mcp for them:
- You must not run
ingest-creds/setup/setup-keyyourself via a shell tool — they prompt for a password and/or an encryption key interactively, and your shell tool's transcript could capture what the user types. Tell the user to open their own terminal and runnpx hilan-mcp setup --tenant <their-org-code-or-subdomain>themselves, then (recommended)npx hilan-mcp setup-key. - Once that's done, you can safely add the MCP server entry to the
client's config file (the JSON blocks above) — that part has no secrets
in it as long as the user used
setup-key(OS credential store) rather than theHILAN_DB_KEYenv var fallback. - After the config is added, the user (or their client) needs to reload/ restart the MCP connection for the new tools to appear.
- Don't enable
HILAN_ENABLE_DEBUG_TOOLSunless the user explicitly asks for the raw.asmx/PDF exploration tools — they're an intentional escape hatch (see Security model), not needed for normal use. - If a tool response includes an
_updateNoticefield, tell the user and ask if they'd like to update; if they decline, calldismissUpdateNoticewith that version (see MCP tools).
MCP tools
| Tool | Summary |
|---|---|
listTenants | List configured tenants — no secrets. |
syncPayslips | Fetch structured payslip data + PDFs for the last N months. |
resyncPayslipMonth | Re-fetch one specific month, overwriting what's stored. |
syncForm106 | Download the Form 106 PDF for a given year. |
downloadCombinedPayslipsPdf | One PDF covering a whole month range. |
getSalaryTrends | Yearly averages, YoY %, CAGR, and notable raises — computed locally. |
listTables / describeTable | Inspect the queryable local schema. |
query | Run read-only SQL against local payslip/Form106 data. |
getPersonalDetails | Live lookup of personal details (not persisted). |
dismissUpdateNotice | Suppress a specific version's update notice. |
debugCallAsmx / debugDownloadPdf | Raw API exploration — off by default. |
Full tool reference (arguments, behavior, notes)
listTenants()
Configured tenants (subdomain, capability, whether login has succeeded before) — no secrets.
syncPayslips(tenant?, monthsBack?, skipPdf?)
Logs in (reusing a saved session if it still works), fetches structured Bruto/Neto/salary-parts data for the last N months (default 3), and downloads each payslip PDF. Set skipPdf: true for a much faster numbers-only sync (e.g. "what did I earn this year"). tenant is optional if COMPANY_URL/COMPANY_TENANT/COMPANY_CODE is set. The tenant's own archive length caps how far back this can actually go — no need to guess a start date.
resyncPayslipMonth(tenant?, period, skipPdf?)
Re-fetches one specific month (e.g. "10_2019" or "10/2019"), overwriting whatever's stored. Use this instead of re-running syncPayslips over the whole history just to retry one bad/truncated PDF or to answer a one-off "how much did I make in month X" question.
syncForm106(tenant?, year?)
Logs in and downloads the Form 106 PDF for a given year (or the tenant's default year). Same tenant fallback as above.
downloadCombinedPayslipsPdf(tenant?, fromMonth, toMonth, destDir?)
Downloads one PDF covering a whole month range (e.g. all of 2015–2024) instead of one file per month. Automatically splits into multiple files if the range would otherwise exceed the server's URL length limit (see Reliability notes) — practical ceiling is roughly 10–15 years per chunk.
getSalaryTrends(tenant?, fromYear?, toYear?)
Computes salary growth trends from locally-synced payslips only — no live login, no network call. Returns yearly average Bruto/Neto, year-over-year % change between adjacent years, CAGR between the first and last full (12-month) calendar year, overall growth (first vs. last synced month), and "notable jumps" (≥10% YoY change in Bruto). Optional fromYear/toYear scope the calendar years considered. Prefer this over hand-rolling aggregation with query — grouping/sorting by plain period text gets cross-year chronology wrong (e.g. "01_2011" sorts before "02_2010"); this tool sorts by actual calendar month internally.
listTables() / describeTable(table)
Lists queryable tables (payslips, form106 only) and their columns/indexes.
query(sql)
SELECT-only SQL against payslips/form106. credentials, sessions, and tenants are hard-blocked — see Security model. Good for quick questions like "how much net/gross did I earn in June 2026" without touching the network at all.
getPersonalDetails(tenant?)
Logs in and returns personal details (name, national ID, birthdate, address, phone, email, work start date, job type). Live lookup only — not persisted to the local database.
dismissUpdateNotice(version)
Call this if the user declines an update you offered them (see below), so that exact version isn't mentioned again.
debugCallAsmx(tenant?, servicePath, body?) / debugDownloadPdf(tenant?, relativeUrl, fileName)
Debug/exploration only, disabled by default — raw pass-through to any .asmx endpoint, or download of an arbitrary relative PDF URL, on a logged-in session. Requires HILAN_ENABLE_DEBUG_TOOLS=1 in the server's env block; not registered otherwise. Filenames are sanitized (no path traversal) and URLs are restricted to the tenant's own origin (no SSRF).
Update notifications: this server has no UI of its own, so update
checks piggyback on whatever tool the agent happens to call next. At most
once a day, a successful tool response may include an extra
_updateNotice field with a message like "A new hilan-mcp version is
available: 0.1.0 -> 0.2.0..." — if you're the AI agent reading this, tell
the user and ask if they'd like to update; if they say no, call
dismissUpdateNotice with that version so it isn't raised again (a newer
version will still be announced later). The check itself hits the npm
registry with a 3s timeout and silently no-ops if it's unreachable (e.g.
offline, corporate proxy) — it never fails a tool call.
Concurrency note: every tool call for a given tenant is automatically
queued and run one-at-a-time internally (see TenantService.runExclusive)
— Hilan's site (and/or the network path to it) doesn't handle concurrent
requests from one session well and everything times out otherwise. You
don't need to serialize calls yourself; different tenants still run fully
in parallel.
Scope (v1)
- ✅ Payslips (list, structured Bruto/Neto/parts, PDF)
- ✅ Form 106 (PDF, per year)
- ⛔ General file archive, Form 101 — not built (v1.1+)
- ⛔ One-time-code / 2FA login — tenants that require it return a clear "unsupported" error instead of hanging
Tenants whose internal API response doesn't match the structured shape seen
on the reference tenant (Amdocs) are marked pdf_only: payslip syncs still
work and still save a PDF, just without the parsed Bruto/Neto numbers.
Reliability notes (learned from a real end-to-end run)
Corporate TLS-intercepting proxies, PDF URL quirks, truncation retries, URL-length limits, and OTP false positives
- Corporate TLS-intercepting proxies (e.g. Amdocs's network) break
Playwright's Node-side
context.requestfor the internal API/PDF calls withself-signed certificate in certificate chain. SetNODE_EXTRA_CA_CERTSto your organization's exported CA bundle in the server'senvblock if you hit this. - Direct PDF download URLs are relative to
/Hilannetv2, not the domain root — a URL returned by the JSON API likePersonalFile/PdfPaySlip.aspx/...actually lives at<tenant>/Hilannetv2/PersonalFile/PdfPaySlip.aspx/.... Confirmed via a live browser network capture. - PDF downloads go through an in-page
fetch()(same-origin, raw URL) rather thancontext.request, which silently re-encodes literal/in query strings to%2Fand gets 404'd by some endpoints. - The same corporate proxy occasionally truncates a PDF response
mid-stream (observed: suspiciously round 32768-byte cutoffs) without
the fetch itself erroring.
downloadPdfchecks the whole buffer for the standard%%EOFPDF trailer (not just the tail — some genuine Hilan PDFs have tens/hundreds of KB of trailing null-byte padding after a valid%%EOF) and retries up to 3 times before giving up. - Combined multi-month PDFs (
PaySlipApiapi.asmx/GetMultiplePaySlipData, one file covering a date range instead of one per month) hit a hard HTTP 404 once the URL exceeds ~2048 characters — that's IIS's defaultrequestFiltering maxQueryStringlimit, not a Hilan-specific cap (each month adds ~11 chars to the URL). Verified working at 120 months (10 years, ~1.4KB URL); verified failing at 194 months (~16 years, 2.2KB URL) — so a ~15-year request is the realistic practical ceiling per combined PDF. Not an issue for per-month syncing (syncPayslips), which never builds one huge URL. - A tenant's regular login page can unconditionally show a "log in with a one-time code" button/link even when normal username+password login is fully supported and working — don't treat that text alone as proof OTP is required. Only genuinely new OTP-input fields (or navigating to an OTP-specific route) after a failed login count as OTP being required.
Security model
- The whole SQLite database (
~/Library/Application Support/HilanMcp/hilan.dbon macOS, XDG/AppData equivalents elsewhere) is encrypted at rest via SQLCipher (better-sqlite3-multiple-ciphers), keyed by a passphrase you choose that is never persisted to disk. PDFs live alongside it under.../HilanMcp/pdfs/<tenant>/, and rolling log files under.../HilanMcp/logs/(redacted — see below). App-data, PDF, and log directories are created with0700permissions; the DB and PDF files themselves with0600. credentials(your login fields) andsessions(saved browser cookies) are ordinary tables inside that encrypted database, but they are never reachable through thequery/listTables/describeTabletools — those are hard-allowlisted topayslipsandform106only, validated via a full SQL AST parse (not a regex) soJOINs, subqueries, and quoted identifiers can't be used to sneak past the allowlist (seesrc/utils/sqlValidation.tsandsrc/tests/sqlValidation.test.ts).- Cookies and auth headers are redacted from log files and from any error
message a tool call returns, so a Playwright error can't leak your
session into your chat history (see
src/utils/redact.ts). - Credential entry (
ingest-creds) must be run directly by you in your own terminal — never through an assistant's shell tool, whose transcript could capture what you typed. debugCallAsmxis an intentional escape hatch: it lets a logged-in session call any.asmxendpoint with any body, bypassing the curated tools above. It was added for API exploration during development and is one-employee-scoped (same session, same permissions you already have on the site) — it can't reach other employees' data or other tenants — but it could in principle call a write endpoint (Hilan generally gates writes behind approval flows, but this hasn't been audited). Off by default (HILAN_ENABLE_DEBUG_TOOLS); treat it likequery's SQL escape hatch — fine for an AI assistant you trust to explore with, not something to expose to untrusted input.
Development
Clone this repo to work on the code itself (not needed just to use the server — see Setup above for that):
npm install
npm run typecheck
npm test # unit tests (SQL allowlist, path-traversal, redaction, update checks, ...)
npm run build # compile TypeScript -> dist/
npm run start:mcp # run the server directly from source (stdio transport)
npm run setup # local equivalent of `npx hilan-mcp setup`
npm run ingest-creds # register a tenant + credentials (interactive, run yourself)
npm run setup-key # store the DB encryption key in your OS credential store (interactive, run yourself)
npm publish ships only dist/, README.md, and LICENSE (see the
files field in package.json) — source, tests, and local research
artifacts are excluded. prepublishOnly runs typecheck + tests + build
first, so a broken build can't be published. The published bin entry
(dist/cli/index.js) is what npx hilan-mcp and npx hilan-mcp <subcommand>
both invoke.