Today we're releasing Foreign Data Wrappers for Cal.com so that you can create event bookings directly from Postgres.

This is especially useful for signup forms where you create an event in your database and schedule an event simultaneously: now you can do all this in a single Postgres transaction.

Cal.com is an open-source scheduling platform that allows individuals and businesses to book and manage appointments. It is designed to work with a variety of use cases, from personal calendars to enterprise-grade scheduling systems. They have a great developer toolkit.

Creating event bookings with Postgres#

Cal.com offers various scheduling features. One of the most common scenarios for developers is creating a new event in a calendar (for example, after someone has purchased a flight).

Let's use your Supabase database to create an event in Cal.com, using Postgres Foreign Data Wrappers.

Set up a Cal.com account#

Set up a Supabase account#

Create Wasm wrapper and a foreign server#

Visit Supabase SQL Editor, use below SQL to create the Wasm foreign data wrapper:


_10

create foreign data wrapper wasm_wrapper

_10

handler wasm_fdw_handler

_10

validator wasm_fdw_validator;

And then create a foreign server for Cal.com connection with your API Key:


_10

create server cal_server

_10

foreign data wrapper wasm_wrapper

_10

options (

_10

fdw_package_url 'https://github.com/supabase/wrappers/releases/download/wasm_cal_fdw_v0.1.0/cal_fdw.wasm',

_10

fdw_package_name 'supabase:cal-fdw',

_10

fdw_package_version '0.1.0',

_10

fdw_package_checksum '4afe4fac8c51f2caa1de8483b3817d2cec3a14cd8a65a3942c8b4ff6c430f08a',

_10

api_key '<your Cal.com API key>'

_10

);

Set up foreign tables#

Now let's setup the foreign tables. First of all, create a dedicate schema for the foreign tables:


_10

create schema if not exists cal;

And then create a foreign table for Event Types:


_10

create foreign table cal.event_types (

_10

attrs jsonb

_10

)

_10

server cal_server

_10

options (

_10

object 'event-types'

_10

);

And another foreign table for Bookings:


_10

create foreign table cal.bookings (

_10

attrs jsonb

_10

)

_10

server cal_server

_10

options (

_10

object 'bookings',

_10

rowid_column 'attrs'

_10

);

Note the rowid_column option which is required to insert data into cal.bookings table, we will see it later.

Query Event Types and Bookings from Cal.com#

Great, now we are all set, it's time to query some juicy data from Cal.com! Let's start query from Event Types first:


_10

-- extract event types

_10

select

_10

etg->'profile'->>'name' as profile,

_10

et->>'id' as id,

_10

et->>'title' as title

_10

from cal.event_types t

_10

cross join json_array_elements((attrs->'eventTypeGroups')::json) etg

_10

cross join json_array_elements((etg->'eventTypes')::json) et;

Note all the scheduling information returned from Cal.com API are stored in the JSON column attrs , from which we can extract any fields of that object. For example, we can extract id, title, name and etc., from Bookings object:


_10

-- extract bookings

_10

select

_10

bk->>'id' as id,

_10

bk->>'title' as title,

_10

bk->'responses'->>'name' as name,

_10

bk->>'startTime' as start_time

_10

from cal.bookings t

_10

cross join json_array_elements((attrs->'bookings')::json) bk;

Oops, it looks like we haven't booked any meetings with anybody yet. Now it's the fun part, let's make a booking on Cal.com from Supabase!

Make a bookings on Cal.com from Supabase#

To make a booking directly from Postgres, all we need to do is to insert a record to cal.bookings foreign table, with the booking details in JSON format. For example,


_13

-- make a 15 minutes meeting with Elon Musk

_13

insert into cal.bookings(attrs)

_13

values (

_13

'{

_13

"start": "2025-01-01T23:30:00.000Z",

_13

"eventTypeId": 1398027,

_13

"attendee": {

_13

"name": "Elon Musk",

_13

"email": "[email protected]",

_13

"timeZone": "America/New_York"

_13

}

_13

}'::jsonb

_13

);

Here you can see we made a 15 minutes meeting booking with Elon, just to give him a happy new year greeting 😄. Note the eventTypeId , “1398027”, is our 15 Min Meeting event type ID, you can find yours by querying the cal.event_types foreign table using above example SQL.

After inserting the booking record, we can verify it appears on our upcoming list in Cal.com.

When we query cal.bookings again using the previous SQL, we can see our new booking record is in the results as well.

That wraps up our tutorial! We've covered how to interact with Cal.com in Supabase using foreign wrapper and tables. For more information about available objects and fields, refer to the Cal.com API v2 reference and the Wrappers Cal.com Wasm Wrapper documentation.

The Cal.com FDW is built with Wrappers, a framework for Postgres Foreign Data Wrappers (FDW). Our latest release supports Wasm (WebAssembly) to simplify development for API-based services.

We've built a variety of wrappers available on fdw.dev, ranging from popular tools like Stripe and Notion to databases like ClickHouse and BigQuery. Check out the full catalog and get started with Supabase today:

database.new