Mews + PostgreSQL

Mews + PostgreSQL integrations

Create new rows in PostgreSQL for every new reservation event in Mews

Simplify your reservation management process by connecting Mews and PostgreSQL. With this workflow, any new reservation in Mews will directly add a new row in your PostgreSQL database. This saves you time and eliminates manual data entry. Perfect for venue managers, this automation ensures your PostgreSQL database is always updated with the latest reservation details.

When this happens...
New Reservation EventTriggers when the reservation event occurs such as a new booking, check in or check out.
TriggerPolling
automatically do this!
New RowTriggers when you add a new row.
ActionWrite

Start free with email

Start free with Google

Free forever for core features
14 day trial for premium features & apps

More things you can do with Mews and PostgreSQL

Discover other triggers and actions you can use with Mews and PostgreSQL

- Time Filter
  Required
Trigger
Polling
Try It
- Time Filter
  Required
Trigger
Polling
Try It
- Time Filter
  Required
- State
- Start Time Modifer
- End Time Modifer
Trigger
Polling
Try It
- Customer Id
  Required
- File Name
  Required
- File
  Required
Action
Write
- Reservation Id
  Required
- Customer Id
  Required
Action
Write

- Rate Id
  Required
- Value of the rate
  Required
- Resource Category Id
  Required
- Start UTC
  Required
- End UTC
  Required
- Released UTC
  Required
- Adjustment Value
  Required
- External Identifier
Action
Write
- Name
  Required
- Deadline
  Required
- Description
- Department
- Service Order Id
Action
Write

- Customer Id
  Required
- Service Id
  Required
- Unique identifier of the Product to be ordered.
- Product Quantity
- Add Items
- Consumption Time
- Notes
Action
Write
- Customer Id
  Required
- First Name
- Last Name
- Second Last Name
- Title
- Birth Date
- Birth Place
- Nationality Code
- Email
- Phone number
- Loyalty Code
- Notes
- Passport number
- Passport expiration date
- Passport issuance date
- Passport issuing country code
- Identity card number
- Identity card expiration date
- Identity card issuance date
- Identity card issuing country code
- Visa number
- Visa expiration date
- Visa issuance date
- Visa issuing country code
- Drivers license number
- Drivers license expiration date
- Drivers license issuance date
- Drivers license issuing country code
- First line of the address
- Second line of the address
- The City
- Postal code
- The Country
- Classifications
Action
Write
- Bill Id
  Required
Action
Search
- Rate Id
  Required
- Reservation start
  Required
- Reservation end
  Required
Action
Search
- Reservation Id
  Required
Action
Search
- Table/View
  Required
- Order_by
- Dedupe_key
Trigger
Polling
Try It
New Table
Triggers when you add a new table.
Trigger
Polling
Try It
- Table
  Required
Action
Write
- Table
  Required
- Lookup Column
  Required
- Lookup_value
  Required
Action
Search
- Query
  Required
Action
Search

New Closed Bill
Triggers when there is a new closed bill.
Trigger
Polling
Try It
- Time Filter
  Required
Trigger
Polling
Try It
- Time Filter
  Required
Trigger
Polling
Try It
- Group Id
- Reservable Service Id
  Required
- Check rate applicability
- Prevent Overbooking
- State
  Required
- Reservation start
  Required
- Reservation end
  Required
- Reservation release
- Number of adults
  Required
- Number of children
  Required
- Customer Id
  Required
- Requested Category Id
  Required
- Rate Id
  Required
- Travel Agency Id
- Notes
Action
Write
- Reservation Id
  Required
- Service Id
- Unique identifier of the Product to be ordered.
  Required
- Product Quantity
  Required
- Override product price
Action
Write
- Company name
  Required
- Telephone number
Action
Write
- Overwrite Existing
  Required
- First Name
- Last Name
  Required
- Second Last Name
- Title
- Birth Date
- Birth Place
- Nationality Code
- Email
- Phone number
- Loyalty Code
- Notes
- Passport number
- Passport expiration date
- Passport issuance date
- Passport issuing country code
- Identity card number
- Identity card expiration date
- Identity card issuance date
- Identity card issuing country code
- Visa number
- Visa expiration date
- Visa issuance date
- Visa issuing country code
- Drivers license number
- Drivers license expiration date
- Drivers license issuance date
- Drivers license issuing country code
- First line of the address
- Second line of the address
- The City
- Postal code
- The Country
- Classifications
Action
Write
- Company Id
  Required
- Company name
- Telephone number
Action
Write
- Reservation Id
  Required
- Reservation start
- Reservation end
- Charge Cancellation Fee
  Required
Action
Write
- Customer Data
  Required
Action
Search
- Customer Id
  Required
Action
Search
- Table/View
  Required
Trigger
Polling
Try It
- Query
  Required
Trigger
Polling
Try It
- Table/View
  Required
- Primary_key
  Required
- Order_by
  Required
- Trigger_column
Trigger
Polling
Try It
- Table
  Required
- ID Column
  Required
Action
Write
- Query
  Required
Action
Search

About Mews

Mews is an innovative hospitality cloud that empowers the modern hotelier to improve performance, maximize revenue, and provide remarkable guest experiences.

Learn moreLearn moreHelpHelp

Related categories

Product Management

About PostgreSQL

PostgreSQL is a powerful, open-source database engine with a uniquely advanced query optimizer and dozens of built in features, making it an easy choice for production databases.

Learn moreLearn moreHelpHelp

Related categories

Databases

Premium

Similar apps

MySQL

Databases

SQL Server

Databases

Amazon Relational Database Services (RDS)

Amazon, Databases