Build integrations using select, insert,

update, delete

Build integrations using select, insert, update, delete

Build integrations using select, insert, update, delete

insert into
salesforce.contact (first_name, last_name, email)
values (
'Andrea'
,
'Palladio'
,
'andrea@palladiodesigns.com'
)
returning id;
(
1
row
)
=> ['0038b00002iOFd9AAG']

Salesforce

New Contact ‘Paul Atreides’ created just now

Watch Sequin in action

Watch Sequin in action

Demo (2 min)

Watch us work with our API

without touching http

Search collections

Sort by:

Date modified

Status

Collection

Destination

Latest Activity

4s

Accounts

_accounts_

3 mins ago

4s

Accounts

_accounts_

3 mins ago

4s

Accounts

_accounts_

3 mins ago

4s

Accounts

_accounts_

3 mins ago

4s

Accounts

_accounts_

3 mins ago

4s

Accounts

_accounts_

3 mins ago

4s

Accounts

_accounts_

3 mins ago

All Syncs

Project Tracker

Sales CRM

Airtable

Sequin hosted

salesforce.com/aoinsdoin112

Status

Healthy

Destination

RDS Production

Database:

‘db1898sdf91’

Schema:

‘public’

Activity

Created Feb 21, 2019

Sync edited Mar 15, 2022

Latest activity Mar 29, 2022

Collections

Backfills

Mapping

Settings

Connection instructions

Syncs

Users

Databases

Docs

Faster (0:31-1:05)

Get a real-time, bidirectional sync between APIs and your database in a few clicks

Simpler (1:06-1:28)

Skip query params, rate limits, and pagination. Build using all the power of SQL instead

Easier (1:29-2:16)

Rapidly solve new problems and deploy new features instead of debugging an API

Watch Sequin in action

Demo (2 min)

Watch us work with our API

without touching http

Search collections

Sort by:

Date modified

Status

Collection

Destination

Latest Activity

4s

Accounts

_accounts_

3 mins ago

4s

Accounts

_accounts_

3 mins ago

4s

Accounts

_accounts_

3 mins ago

4s

Accounts

_accounts_

3 mins ago

4s

Accounts

_accounts_

3 mins ago

4s

Accounts

_accounts_

3 mins ago

4s

Accounts

_accounts_

3 mins ago

All Syncs

Project Tracker

Sales CRM

Airtable

Sequin hosted

salesforce.com/aoinsdoin112

Status

Healthy

Destination

RDS Production

Database:

‘db1898sdf91’

Schema:

‘public’

Activity

Created Feb 21, 2019

Sync edited Mar 15, 2022

Latest activity Mar 29, 2022

Collections

Backfills

Mapping

Settings

Connection instructions

Syncs

Users

Databases

Docs

Faster (0:31-1:05)

Get a real-time, bidirectional sync between APIs and your database in a few clicks

Simpler (1:06-1:28)

Skip query params, rate limits, and pagination. Build using all the power of SQL instead

Easier (1:29-2:16)

Rapidly solve new problems and deploy new features instead of debugging an API

Trusted by engineering teams

Trusted by engineering teams

Trusted by engineering teams

Bob Lauer

Principal Engineer, Bloomtech

Sequin gave us the interface we always tried to build ourselves - a database. I only wish we found Sequin sooner. We waisted time on every developer tool offered by Salesforce: APEX triggers. SOQL. Salesforce events. The streaming API…but we always hit errors and limitations.

Just SQL.

Build using the database, query language, and tools you already know

Reads

Skip the API docs and query params. Just SELECT and JOIN data using SQL. Queries return 100X faster than the API and can be optimized with indexes.

select sum(total_price), product_id from airtable.order

where status = ‘pending_fulfillment’

group by product_id;

(7 rows)

=> [[857281, ‘prod_8sju’, ... ]]

Writes

INSERT, UPDATE, and DELETE work just as you’d expect. Mutations are validated with the data source at execution, guaranteeing consistency.

update salesforce.subscription_usage

set quantity = quantity + $1

where account_id = $2

returning quantity;

(1 row)

=> [34758]

Salesforce

Subscription usage updated

Errors

Errors return in a standard Postgres format so you can handle them in-line. No more digging through outdated forums to decipher cryptic responses.

insert into hubspot.company (name, industry)

values ('Palladio Designs', 'Scriptorium');

ERROR: [hubspot]: Property values were not valid: Industry `Scriptorium` is invalid.

Hubspot

Validation error — `industry` is invalid

Postgres

CREATE views, generated columns, and triggers. ADD pg extensions, and write functions to build your app.

create view salesforce.order_summary as

select order.id, order.account_id, order.status,

contact.email as contact_email

from salesforce.order order

inner join salesforce.company company

on order.account_id = company.id

inner join salesforce.contact contact

on company.primary_contact_id = contact.id;

Just SQL.

Build using the database, query language, and tools you already know

Reads

Skip the API docs and query params. Just SELECT and JOIN data using SQL. Queries return 100X faster than the API and can be optimized with indexes.

select sum(total_price), product_id from airtable.order

where status = ‘pending_fulfillment’

group by product_id;

(7 rows)

=> [[857281, ‘prod_8sju’, ... ]]

Writes

INSERT, UPDATE, and DELETE work just as you’d expect. Mutations are validated with the data source at execution, guaranteeing consistency.

update salesforce.subscription_usage

set quantity = quantity + $1

where account_id = $2

returning quantity;

(1 row)

=> [34758]

Salesforce

Subscription usage updated

Errors

Errors return in a standard Postgres format so you can handle them in-line. No more digging through outdated forums to decipher cryptic responses.

insert into hubspot.company (name, industry)

values ('Palladio Designs', 'Scriptorium');

ERROR: [hubspot]: Property values were not valid: Industry `Scriptorium` is invalid.

Hubspot

Validation error — `industry` is invalid

Postgres

CREATE views, generated columns, and triggers. ADD pg extensions, and write functions to build your app.

create view salesforce.order_summary as

select order.id, order.account_id, order.status,

contact.email as contact_email

from salesforce.order order

inner join salesforce.company company

on order.account_id = company.id

inner join salesforce.contact contact

on company.primary_contact_id = contact.id;

Just SQL.

Build using the database, query language, and tools you already know

Reads

Skip the API docs and query params. Just SELECT and JOIN data using SQL. Queries return 100X faster than the API and can be optimized with indexes.

select sum(total_price), product_id from airtable.order

where status = ‘pending_fulfillment’

group by product_id;

(7 rows)

=> [[857281, ‘prod_8sju’, ... ]]

Writes

INSERT, UPDATE, and DELETE work just as you’d expect. Mutations are validated with the data source at execution, guaranteeing consistency.