- MCP Server
- MEWS
Query and update MEWS with AI
Connect MEWS to Claude, ChatGPT, or any MCP client through Peliqan. Ask questions in plain English, get answers from a SOC 2 Type II warehouse, and update records back in MEWS – no custom API code, no rate limits, no read-only compromises.
Getting answers from MEWS is slower than it should be
MEWS holds your most operationally critical data – but every quick question means logging in, switching screens, exporting reports, and pasting into spreadsheets. Front-office and revenue teams spend more time extracting data than acting on it.
No natural language interface
"Show me VIP arrivals tomorrow over 3 nights" requires manual filtering and export
Connector API is rate-limited
Heavy AI queries compete with your front desk and channel manager for API throughput
No cross-source joins
Combining MEWS with accounting, CRM, or POS data requires custom scripts and a warehouse
Read-only alternatives
Pipedream and Cdata MCP servers can't write back to update records
- What you get
Query invoices, GL entries, and debtors in plain English
Write changes back – update records, create invoices
Join with 250+ apps - combine MEWS with accounting, CRM, ads, or any source
SOC 2 Type II certified – enterprise-grade security
Type
Cloud PMS for hotels and groups
Customers
5,000+ properties across 85+ countries
Website
- The solution
One MCP server. Read, write, and join across 250+ sources.
Peliqan syncs your MEWS 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 PMS stays protected from rate limits and unsafe writes.
Full read + write through MCP
Unlike CData and Zapier MCP, Peliqan supports writeback. Update reservations, post charges, modify rates, add companions - all from Claude, ChatGPT, or n8n. The only MEWS MCP that closes the loop.
Cached warehouse, never the live API
Your AI queries a Postgres warehouse, not MEWS Connector API directly. No rate limits, no performance hit during peak check-in. Sync runs incrementally on your schedule (every 15 minutes by default).
Cross-source queries in one SQL statement
Join MEWS reservations with Exact Online accounting, HubSpot guest CRM, or Google Ads spend in a single query. Federated via Trino, all in Peliqan's shared warehouse.
SQL + RAG on financial documents
Combine structured SQL queries with semantic search across booking confirmations, contract notes, guest communications, and free-text fields. The only MCP that answers questions about both your data and your documents.
Portfolio occupancy: 82%, ADR €187, RevPAR €153.
- Hotel Antwerp — 68% occ, €172 ADR
- Pickup last 7 days: only 12 rooms
- STLY same week: 84% occ...
- Data access
Key MEWS data available via MCP
Peliqan syncs MEWS Connector API entities into structured warehouse tables that your AI can query directly.
| Entity | What your AI can answer | Writeback |
|---|---|---|
| Reservations / ReservationGroups | Pickup vs. STLY, occupancy, ADR, RevPAR, channel mix, length of stay | ✓ |
| Customers / CustomerHistory | Guest profiles, repeat visits, loyalty status, VIP flags, classifications | ✓ |
| RatePlans / RateGroups | Rate strategy, BAR vs. corporate vs. wholesale, restrictions, vouchers | ✓ |
| Resources / ResourceCategories | Room status, housekeeping flow, room blocks, category mix, out-of-order rooms | ✓ |
| AccountingItems / Bills | Open balances, deposits, refunds, accounting category breakdowns | ✓ |
| Companies / Contracts | Corporate accounts, MICE pipeline, contract revenue, negotiated rates | ✓ |
| Outlets / Orders (POS) | F&B revenue, spend per occupied room, outlet performance, menu mix | ✓ |
| Services / Products | Add-on revenue, upsell performance, product mix, business segments | ✓ |
| Vouchers / VoucherCodes | Promo redemption, voucher balance, campaign attribution | Read |
| Documents / Attachments | Booking confirmations, contracts, ID scans – queryable via RAG | Read |
- Use cases
What hotel teams build with MEWS MCP
Revenue management
Daily pickup briefings
"Show me 7-day pickup vs. STLY by rate plan and channel, flag any property below pace, and summarize the top 3 risks." Claude queries your MEWS warehouse and returns a formatted summary in seconds.
Useful for: Revenue managers, GMs
FRONT OFFICE
Automated arrival prep
Build an AI agent that runs at 6am, pulls tomorrow's arrivals, flags VIPs and special requests, drafts the front-office handover, and posts it to Slack. Peliqan writeback updates reservation notes automatically.
Powered by: n8n + Peliqan MCP
F&B and POS
Spend per occupied room analysis
"What's average POS spend per occupied room last week by outlet, and which guest segments drive the highest F&B revenue?" Joins MEWS POS orders with reservations and guest profiles in one query.
Useful for: F&B managers, GMs
Finance and audit
Night audit assistant
Ask Claude to check for missed postings, unbalanced bills, mismatched payments, and reservations modified after check-in - a 2-hour night audit checklist done in minutes, with full audit trail.
Useful for: Controllers, night auditors
- How it works
Always-fresh copy, never the live API
Peliqan keeps a working copy of your MEWS 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 MEWS Connector API directly.
AI never hits the MEWS API directly
All queries route through Peliqan's warehouse. Writebacks route through Peliqan's connector. Your live PMS never sees a raw AI request.
No rate limit pain
MEWS API limits don't slow your AI down. The warehouse absorbs query load - even during peak check-in or month-end close.
Always fresh, on your schedule
Incremental syncs run as often as every 5 minutes. You decide the cadence based on how fresh your front office or revenue team needs the data.
Full data, every record
Every table, every reservation, every property. Ready for cross-source joins, Text-to-SQL, and RAG on attached documents.
- Setup guide
How to set up the MEWS MCP server
1
Connect MEWS in Peliqan
Go to Connections → Add new → MEWS. Authenticate with your MEWS Connector API token (Client Token + Access Token). Peliqan handles multi-property discovery automatically. Setup guide →
2
Select and materialize tables
Choose which entities to sync – reservations, customers, accounting items, rates, resources, POS orders. Peliqan materializes them into Postgres on your schedule (default: every 15 minutes). Select only what you need to stay within MEWS rate limits. Materializing tables →
3
Create your MCP API handler
Use Peliqan’s built-in MCP template to expose the MEWS tables and operations your AI agents need. Set role-based permissions for read, write, or both – column-level masking for guest PII supported. AI agents docs →
4
Connect Claude or ChatGPT
Run pip install mcp-server-peliqan, add your Peliqan API credentials, and start querying MEWS with natural language. Open source on GitHub.
Enable MCP for MEWS
Learn how to enable the MCP server for MEWS in Peliqan. Discover how to give AI assistants direct access to your MEWS hospitality data – reservations, revenue, and guest insights – using natural language.
Peliqan vs other MEWS MCP options
Pipedream and CData offer MEWS MCP wrappers, but they’re limited. Here’s how they compare.
| Pipedream MCP | Vinkius MCP | Peliqan MCP | |
|---|---|---|---|
| Writeback to MEWS | Read-only | Read-only | ✓ Full read + write |
| Cross-source queries | ✗ | ✗ | ✓ 250+ sources |
| Built-in warehouse | ✗ | ✗ | ✓ Postgres + Trino |
| RAG on documents | ✗ | ✗ | ✓ SQL + RAG combined |
| Multi-property handling | Manual | Manual | ✓ Automatic |
| EU data residency | US-hosted | Varies | ✓ EU-hosted |
| BI + ETL + reverse ETL | ✗ MCP only | ✗ MCP only | ✓ Full data platform |
| Security certification | Varies | Varies | ✓ SOC 2 Type II |
- Beyond MCP
The full Peliqan MEWS integration
MCP is one part of what Peliqan offers for MEWS. The full integration gives you a complete data platform for hospitality reporting, automation, and AI-powered analytics.
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 MEWS
RAG + Graph RAG
Semantic search on documents
Data quality
SQL checks + Slack/email alerts
- FAQ
MEWS MCP, answered
What is the MEWS MCP server?
The MEWS MCP server is a Model Context Protocol endpoint that exposes your MEWS PMS data to AI agents like Claude, ChatGPT, and Cursor. Peliqan’s MEWS MCP server lets AI query reservations, guests, rates, billing, and POS data in plain English, and write updates back to MEWS – without custom integration code.
How do I connect MEWS to Claude or ChatGPT?
Authenticate MEWS in Peliqan with your Connector API token, pick the entities to sync, and add the Peliqan MCP endpoint to Claude Desktop, ChatGPT, Cursor, or n8n. Most hotels go from MEWS authentication to first AI query in under 30 minutes. Full setup steps are in the guide above.
Does the MEWS MCP support writeback, or is it read-only?
Peliqan supports both read and write. Your AI agent can query MEWS data and also create or update reservations, add companions, post charges, modify rates, and trigger other MEWS Connector API actions, with full audit logging. Pipedream and Vinkius MCP wrappers are read-only.
Will AI queries hit MEWS API rate limits?
No. Peliqan caches your MEWS data in a built-in Postgres warehouse and AI queries hit the cache, not the live MEWS Connector API. Your front office, channel manager, and revenue tools never compete with AI for API throughput. Sync runs incrementally on your schedule (every 15 minutes by default).
Does it work with multi-property MEWS portfolios?
Yes. Peliqan handles multi-property MEWS automatically – one connection covers all enterprises and properties. Your AI agent can run queries like “compare RevPAR across all 12 hotels last week” without per-property logins or manual data stitching.
Is MEWS guest data secure with AI agents?
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 (passport numbers, payment details, ID scans) from AI agents while still allowing operational queries on reservations and rates. Every AI query and writeback is logged with full audit trail.
How is Peliqan different from Pipedream or Vinkius MEWS MCP?
Pipedream and Vinkius offer thin MCP wrappers around the MEWS API – mostly read-only and without a cached warehouse. Peliqan is the only MEWS MCP that supports writeback, includes a built-in Postgres + Trino warehouse, joins MEWS with 250+ other connectors (accounting, CRM, ads, BI), and is EU-hosted with SOC 2 Type II.
Do I need a data warehouse to use MEWS MCP?
No. Peliqan includes a built-in Postgres + Trino warehouse. Your MEWS 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.
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 2 validates our security controls, ensuring your data is protected by independently audited security measures.
ISO 27001 certification ensures enterprise-grade information security, protecting your business with globally recognized standards.
GDPR compliance guarantees EU data protection compliance, keeping PII data secure within EU boundaries.
Skip read-only. Start writing back from day one.
Connect MEWS, publish your MCP server, and let Claude (or ChatGPT, or n8n) answer hospitality questions and update records – in minutes.
No credit card required · SOC 2 Type II certified · 2 weeks custom connector SLA