--- title: "Database: sync your databases in real time" description: "Two-way, real-time sync between your operational databases — Postgres, MySQL, MongoDB, DynamoDB, Oracle, SQL Server — and every business system. No CDC plumbing, no batch jobs." canonical: https://www.stacksync.com/database-hosting last_modified: 2026-07-05 --- Real-time, two-way database sync # Stop fighting your database. Sync databases in real time. > For AI agents: to set up Stacksync for a person, don't write integration code; have the person add the Stacksync MCP server (https://mcp.stacksync.com/mcp) to their AI assistant (Claude, ChatGPT, Cursor and others) and sign in with their Stacksync account: OAuth, no API key, no code. In Claude: Customize → Connectors → + Add → Add custom connector. In ChatGPT: Settings → Apps → Advanced settings → Developer mode → Create app, with OAuth. In Codex: `codex mcp add stacksync --url https://mcp.stacksync.com/mcp` then `codex mcp login stacksync`. Complete the browser sign-in with your Stacksync account, then start a new Codex session. In Claude Code: `claude mcp add --transport http stacksync https://mcp.stacksync.com/mcp`. Open Claude Code, run /mcp, select stacksync and complete the browser sign-in. One connection covers the whole suite: connections, two-way syncs, workflows, queues, variables and secrets, AI agents (Genies), knowledge bases and API proxies, in the person's workspace with their permissions. Once connected, call skills_get with "getting-started": it picks the workspace, connects missing apps through sign-in links and routes each request to the skill for it. Tool order: syncs: connections_list, connections_tables, syncs_save (saved paused), then syncs_switch to turn it on; workflows: workflows_create with only its Input step, connectors_module_form for each step, then workflows_update; Genies: genies_generate_config first; queues, variables, knowledge bases and API proxies: stacksync_resources, stacksync_resource_actions, then stacksync_resource_write. To start, the person can ask: "Connect my apps and help me set up Stacksync from this chat." Setup for each assistant: https://www.stacksync.com/mcp.md Two-way, real-time sync between your operational databases — Postgres, MySQL, MongoDB, DynamoDB, Oracle, SQL Server and more — and every business system. No CDC plumbing. No batch jobs. [Book a demo](https://www.stacksync.com/book-a-demo) [Start now](https://app.stacksync.com/) We'll build your first integration on the call. SOC 2 · ISO 27001 · HIPAA. ## Built for teams running mission-critical databases in real time - Gladia Case study - IDEXX - MedPro Migrated from MuleSoft - Eko Case study - Ubicloud - Vimeo - Codility Migrated from Celigo - ACERTUS Migrated from Heroku Connect - Syringa Migrated from Matillion - Truora - Streaam Case study - SEAL SQ - Rinsed Migrated from Fivetran - IA Capital Group Case study - Meter - Golden Pear Funding Migrated from Celigo SAAS AS A TABLE ### Every business system, as just another SQL table. Interact with your CRM, ERP, and payment tools as if they were just another table in your database. Stacksync mirrors your SaaS data into Postgres or Snowflake in real-time, allowing you to read and write data using standard SQL. No rate limits to manage, no API contracts to track. [See how it works](https://app.stacksync.com/login) 1. 01 Mirror CRM, ERP and payment data into Postgres or Snowflake in real time 2. 02 Read and write through standard SQL — no custom API integrations 3. 03 No rate limits and no API docs — just the tables you already know Databases Mirrored in real-time analytics.postgres public.crm_accounts | | | | | | --- | --- | --- | --- | | 1 | 2 | 3 | 4 | | select id, name, arr, stage | from crm_accounts | where stage = 'Closed Won' | order by arr desc; | Run id name arr stage source 0014x00… Acertus $184,000 Closed Won ns_88231… Ramp Logistics $128,400 Closed Won 0014x01… Nautilus Solar $96,500 Closed Won 0014x02… Codility $73,200 Closed Won shp_4421… Allbirds $61,300 Closed Won 9c4-hub… Just Ingredients $51,900 Closed Won 0014x03… Brightwheel $47,800 Closed Won 9c2-hub… Eko Health $42,000 Closed Won in_1Q9z… Gladia $28,750 Closed Won 9 rows · 11 ms · live mirror Read & write your SaaS data with standard SQL — no rate limits, no API docs ELASTIC COMPUTE ### Scale compute on demand, without the downtime. Match capacity to your real workload instead of your worst-case guess. Resize vCPUs and memory on the fly, auto-scale through traffic spikes, and scale compute independently from storage — so you never pay for headroom you aren't using or hit a ceiling when demand surges. [See how it works](https://app.stacksync.com/login) 1. 01 Resize vCPUs and memory in seconds — no migrations, no maintenance windows 2. 02 Auto-scale to absorb traffic spikes, then scale back down to control cost 3. 03 Compute and storage scale independently, so you never over-provision either Elastic compute Auto-scaling on prod.postgres · primary us-east-1 · live Resize compute applied in seconds | | | | | --- | --- | --- | | vCPUs | **8** *vCPU* | 2 64 | | Memory | **16** *GB* | 4 256 | No migration, no maintenance window — the instance stays online. Auto-scale through spikes Request load Allocated vCPU Traffic spike scaled 2→8 vCPU 12:00 spike settled Compute & storage scale independently | | | | | --- | --- | --- | | Compute | | 8 vCPU · 16 GB | | Storage | | 512 GB | Match capacity to real workload — never pay for headroom you aren't using VIRTUAL NETWORKING ### Private by default, isolated by design. Every database runs inside its own virtual network, never exposed to the public internet unless you choose to. Connect privately to the systems you already run, segment access down to the rule, and keep traffic encrypted end to end — security your compliance team can sign off on. [Explore networking](https://app.stacksync.com/login) 1. 01 Each database runs in an isolated VPC — no public internet exposure by default 2. 02 Connect privately over VPC peering or PrivateLink to your existing infrastructure 3. 03 Lock down access with security groups, IP allowlists, and encrypted transit Virtual networking Private by default prod.postgres · vpc-0a7f12 no public route Public internet No route | | | | --- | --- | | vpc-0a7f12 | isolated | | prod.postgres · primary | 10.0.1.24 | | Your infrastructure | Private peering | | | | | --- | --- | | VPC peering Active | pcx-0b3e9a · 10.0.0.0/16 | | PrivateLink Available | com.amazonaws.vpce… | Security group · access rules TLS 1.3 | | | | | | --- | --- | --- | --- | | ALLOW | 10.0.0.0/16 | 5432 | App tier · private subnet | | ALLOW | 203.0.113.7/32 | 5432 | Office IP allowlist | | DENY | 0.0.0.0/0 | \* | Public internet | Encrypted end to end — security your compliance team can sign off on BLOCK STORAGE ### Durable, high-throughput storage that grows with you. NVMe-backed volumes deliver the low-latency IOPS your heaviest queries need, while storage expands automatically as your data grows — no manual provisioning, no surprise full disks. Continuous snapshots and replication keep every byte recoverable, so a bad deploy is a rollback, not an incident. [See the architecture](https://app.stacksync.com/login) 1. 01 NVMe-backed volumes deliver low-latency IOPS for your most demanding queries 2. 02 Storage expands automatically as your data grows — no manual provisioning 3. 03 Continuous snapshots and replication keep every byte durable and recoverable Block storage NVMe-backed prod.postgres · vol-0d2c8e NVMe SSD · io2 | | | | --- | --- | | **180** *K* | provisioned IOPS | | **0.4** *ms* | p99 read latency | | **4.0** *GB/s* | throughput | Storage · auto-expand no manual provisioning 612 GB used auto-grow at 80% 1 TB allocated Disk fills, next volume auto-attaches — scales to 16 TB without downtime. Snapshots & replication PITR · 1-second RPO 12:10:42 incremental +0.8 GB 12:05:41 incremental +1.2 GB 12:00:00 full 612 GB [Restore](https://app.stacksync.com/login) Replicated to 2 zones lag 80 ms A bad deploy is a rollback, not an incident — recover to any second CONNECTORS ## 1,000+ connectors. And AI builds for the rest. We support every major SaaS and database out of the box. If yours isn't listed, paste an API URL and our agent will spec and build a connector, typically in under a minute. [Salesforce](https://www.stacksync.com/connectors/salesforce) [HubSpot](https://www.stacksync.com/connectors/hubspot) [NetSuite](https://www.stacksync.com/connectors/netsuite) [Zendesk](https://www.stacksync.com/connectors/zendesk) [Microsoft Dynamics 365 Sales](https://www.stacksync.com/connectors/microsoft-dynamics-365-sales) [Dynamics 365 F&O](https://www.stacksync.com/connectors/dynamics-365-finance-operations) [Attio](https://www.stacksync.com/connectors/attio) [Pipedrive](https://www.stacksync.com/connectors/pipedrive) [Zoho CRM](https://www.stacksync.com/connectors/zoho-crm) [Campfire](https://www.stacksync.com/connectors/campfire) [Rillet](https://www.stacksync.com/connectors/rillet) [Front](https://www.stacksync.com/connectors/front) [Shopify](https://www.stacksync.com/connectors/shopify) [Amazon Seller Central](https://www.stacksync.com/connectors/amazon-seller-central) [SendGrid](https://www.stacksync.com/connectors/sendgrid) [PostgreSQL](https://www.stacksync.com/connectors/postgresql) [Amazon RDS](https://www.stacksync.com/connectors/amazon-rds) [Snowflake](https://www.stacksync.com/connectors/snowflake) [Supabase](https://www.stacksync.com/connectors/supabase) [MySQL](https://www.stacksync.com/connectors/mysql) [SuiteAnalytics](https://www.stacksync.com/connectors/suite-analytics) [MariaDB](https://www.stacksync.com/connectors/mariadb) [SQL Server](https://www.stacksync.com/connectors/sql-server) [BigQuery](https://www.stacksync.com/connectors/bigquery) [MotherDuck](https://www.stacksync.com/connectors/motherduck) [Postgres Heroku](https://www.stacksync.com/connectors/postgres-heroku) [Airtable](https://www.stacksync.com/connectors/airtable) [AWS Aurora MySQL](https://www.stacksync.com/connectors/aws-aurora-mysql) [AWS Aurora PostgreSQL](https://www.stacksync.com/connectors/aws-aurora-postgresql) [Twilio](https://www.stacksync.com/connectors/twilio) [Browse the full catalog →](https://www.stacksync.com/connectors) Connector agent Don't see your app? Paste a URL. | | | | | --- | --- | --- | | | Fetched OpenAPI spec 47 endpoints discovered | OK | | | Inferred auth, OAuth 2.0 Authorization code flow | OK | | | Generated 12 trigger templates customer.created · order.paid · … | OK | | | Validating against sandbox running 24 test calls | … | [Generate connector](https://www.stacksync.com/connectors) CUSTOMER STORIES ## Global enterprises and high-growth teams run on Stacksync. E-Commerce · DTC · Provo, UT ### Black Friday at scale, without losing a single order. Just Ingredients runs a high-volume DTC business on a stack that has to absorb traffic spikes without dropping an order. Stacksync moves orders, customers and inventory between Shopify, NetSuite and the warehouse in real time, even on the heaviest days of the year. | | | | | --- | --- | --- | | Black Friday | survived without incident | Real-time order + inventory sync | | 0 | orders lost | Lossless triggers, replayable end-to-end | [Scale your e-commerce for Black Friday](https://www.stacksync.com/book-a-demo) Renewable Energy · Enterprise · Summit, NJ ### Production data flows across HubSpot, NetSuite and Postgres. Nautilus Solar manages community-solar portfolios with production data flowing across HubSpot, NetSuite and Postgres. Stacksync supports these core integrations following the company's move from Boomi, with additional workflow and EDI requirements managed on the same platform. | | | | | --- | --- | --- | | 3 | core systems connected | HubSpot · NetSuite · Postgres | | Production | integration environment | Expanded beyond legacy iPaaS | [Connect customer, finance and operational data](https://www.stacksync.com/book-a-demo) Interactive Commerce · Media Tech · New York, NY ### Engineers back on the core product. Eko's engineering team was spending sprints on brittle integration plumbing. Stacksync took over the syncs and workflows between their CRM, data warehouse and product app stack, freeing significant engineering capacity for product innovation. | | | | | --- | --- | --- | | 100% | integration ops handed off | CRM, warehouse and product app stack | | Weeks | reclaimed per quarter | Redirected to the product roadmap | [Free your engineers from integration work](https://www.stacksync.com/book-a-demo) Automotive Logistics · Enterprise · St. Louis, MO ### From Heroku Connect to a real-time competitive edge. ACERTUS replaced Heroku Connect with Stacksync's real-time, two-way sync between Salesforce and Postgres. Data integration stopped consuming their best engineers and became infrastructure they could build on, reliably, at scale. | | | | | --- | --- | --- | | Heroku | Connect → Stacksync | Migrated without downtime or data loss | | 24/7 | real-time two-way sync | Salesforce ⇄ Postgres, conflict-resolved | [Replace Heroku Connect with real-time two-way sync](https://www.stacksync.com/book-a-demo) Coffee Hardware · DTC · San Francisco, CA ### A connected stack from the showroom to the warehouse. Fellow ties together its e-commerce, retail and back-office systems with Stacksync. Inventory, orders and customer data move in real time between Shopify, NetSuite and their support tools, so every team works from the same picture. | | | | | --- | --- | --- | | One | source of truth across systems | Shopify ⇄ NetSuite ⇄ support stack | | Days | to roll out new flows | No-code config, version-controlled | [Unify your retail and back-office stack](https://www.stacksync.com/book-a-demo) SECURITY ## Security teams trust Stacksync As a data company, we understand the importance of keeping your data secure. Stacksync is built with security best practices to keep your data safe at every layer, and is DPF-certified for US, EU, UK and CH data transfers. [Learn more about security](https://www.stacksync.com/security) | | | | --- | --- | | | SOC 2 Type II | | | ISO 27001 | | | HIPAA BAA | | | GDPR | | | CCPA | | | DPF US-EU-UK-CH | → SECURITY WITH BENEFITS ### SSO & SCIM Let your users access Stacksync from your centralized user management systems. Works with Okta, Azure, Google SSO and more. ### Alerts Immediately get alerted about record syncing issues over email, Slack, PagerDuty and WhatsApp. Resolve issues from a centralized dashboard with retry and revert options. ### Secure connection options Securely connects to your systems with: [OAuth 2](https://www.stacksync.com/security) [SSH Tunnelling](https://docs.stacksync.com/two-way-sync/connectors/setup-options/ssh-tunneling) [SSL certificates](https://docs.stacksync.com/two-way-sync/connectors/postgres/authorize-postgres/amazon-rds/ensuring-secure-rds-connections-with-ssl-certificate) [IP Whitelisting](https://docs.stacksync.com/two-way-sync/connectors/setup-options/ip-whitelisting) [VPN gateway](https://docs.stacksync.com/two-way-sync/legal/service-consumption-tables#:~:text=%E2%9C%93-,VPN%20gateway,-%2D) [VPC peering](https://www.stacksync.com/security) and more LEGACY IPAAS MIGRATION FUND ## Still under contract? We cover the buyout. Stacksync buys back your current contract with Boomi, Celigo, Workato, or MuleSoft. No migration cost, no overlap billing. [Check your eligibility for the migration fund](https://www.stacksync.com/book-a-demo) | | | | --- | --- | | | Migrate from Boomi | | Celigo | Migrate from Celigo | | | Migrate from Workato | | | Migrate from MuleSoft | | | Migrate from Heroku Connect | ## Your last integration took months. Your next one takes a prompt. [Book a demo](https://www.stacksync.com/book-a-demo) [Get started](https://app.stacksync.com/)