👋 Welcome
We're Sequin. Sequin lets you integrate with third-party platforms like Salesforce or Stripe using your Postgres database. Setup a real-time sync to your database in about 2 minutes.
With Sequin, you'll never need to worry about:
- Rate limits
- API queries and pagination
- Background jobs
- Cache invalidation
- Out-of-sync data
Select the objects and fields you want to work with, like Salesforce Contacts or Stripe Subscriptions. Then specify how you want these objects and fields to translate into tables and columns in your Postgres database.
Data flows one-way from the API to your database via our sync. When you want to mutate data, you'll use our Proxy to simultaneously create, update, or delete objects in the API and your database:
At the moment, we support HubSpot, Salesforce, Airtable, and Stripe with more platforms on the way.
Getting started​
Most developers are up and querying their data in no time. See our platform-specific guides to get a step-by-step walk-through:
Overview​
Connect​
Connect Sequin to the API you want to sync using OAuth or API keys. Then connect Sequin to your Postgres database.
Map​
Map the collections and fields from the API you're working with to tables and columns in your database. For example, you can map the collection Application__c from Salesforce to the application table in your database.
Learn more about mapping data.
Backfill​
After you setup your sync, Sequin will first backfill all the objects from the API you're syncing to your database. For example, say you're syncing Salesforce Contacts. During the backfill all the Contacts present in Salesforce will be loaded into the table you specified (e.g. contact).
Learn more about backfills.
Real-time sync​
After the backfill, Sequin runs a real-time sync process to ensure the data in the API and your database is kept in-sync.
For most syncs and most collections, changes in the API propagate to your database in less than a minute.
Learn more about our sync process.
Postgres databases​
We only sync with Postgres databases. Support for other databases coming soon. (Write us and let us know which you'd like to see!)
Separate schema​
Sequin syncs to a dedicated schema in your Postgres database. A schema in Postgres is a namespace for tables. This makes it clear which tables are for your API integration. For example, if you sync Salesforce to a salesforce schema, you'd interact with your Salesforce contact table like so:
select * from salesforce.contact;
Demo databases​
To get started as fast as possible, Sequin can provision you a private database on a shared AWS RDS instance. These databases have limited performance and should be considered for demonstration purposes only.
Our hosted databases are in the AWS us-west-2 region in Oregon, USA. Provisioning takes just a few seconds.
Proxy​
For writes, Sequin provides a proxy. Writes through the Sequin Proxy are committed to both the API and your database at the same time. This enables a read-after-write workflow: after you write to the API, you can safely read from your database.
In addition, writes through the Proxy share a rate limit with your sync. With the Proxy, you'll never hit a 429.
Proxy writes are usually as simple as prepending proxy.sequin.io to your API requests. For example, to create a record in Airtable, you'd POST to https://proxy.sequin.io/api.airtable.com/v0/{baseId}.
Learn more about writing through the proxy.
ORMs​
Sequin provides you with a Postgres database that works seamlessly with the entire Postgres ecosystem - including ORMs.
You'll simply configure your ORM to connect with your Sequin database using the connection URL we provide in the Sequin console.
Learn more about ORMs.
Questions and support​
Our docs won't be able to cover everything, so if you have any issues, don't hesitate to reach out. We'd love to hear what you're building.
