Powers:

SQL-centric API integration
for modern teams

Use familiar open technologies to own, control, and scale your integrations — no black boxes, no SaaS lock-in.

Sequor fuses API execution with SQL logic to provide an unified, open platform for all your data and app integrations.

~ pip install sequor

The core of modern API integration
reimagined for data engineers

HTTP-database engine

Connects any API to your databases: iterate over input records, execute dynamic HTTP calls, and map responses back to tables. Like Postman with database superpowers — made for automation.

SQL-powered business logic

Use standard SQL to prepare data for APIs, transform responses, and implement aggregations — all with clear lineage and zero learning curve.

Procedural flow control

Orchestrate with explicit controls if-then-else logic, for-each loops, and do-until suitable for app and data integration. Powerful, readable, and maintainable flows.

Code-powered API shaping

Inject variables with Jinja templates. Use Python for response mapping and advanced expressions. Mix configuration and code to achieve the precision UI tools can not reach.

Code-first architecture

Create YAML workflows for version control, CI/CD, local devel, and collaboration — bringing modern software practices to integration.

Unified iPaaS & ETL engine

Combine API calls and SQL transformations in a single execution model.
Break down silos between data and integration teams — and own the full flow from extraction to action.

Command your flow with simple precision

Write flows in intuitive YAML using just two core operations: transform for SQL-based data processing and http_request for API interactions. Use Jinja for embedding environment and source level variables. Use Python snippets in HTTP body construction and response-to-database mapping — just a few lines of code with full flexibility. Add control operations like loops and conditionals for advanced orchestration when needed.

Fetch API into database

Load BigCommerce customers into table. Jinja for source-level variables. Python for one-line response navigation

Update API from database

Iterate over input table to update Mailchimp with customer metrics. Python used for advanced URL construction and body formation.

Flexible complex data handling

Load Shopify customers and addresses into tables. Flatten nested JSON objects. Split into multiple tables with reference columns.

Process data with SQL

Implement business logic in SQL. Prepare data for API input. Process API responses. Create analytics tables.

Orchestrate execution

Add high-level dynamism and handling of edge cases to your flows.

Loading syntax highlighter...

Built for every integration challenge

Fill the gaps in your stack with tailored integrations — or build end-to-end solutions fine-tuned to your needs. Cut tool sprawl and lower your SaaS costs.

API → DB

Data acquisition

Pull data from apps into your warehouse for analytics.

DB → API → DB

Data enrichment

Enhance your internal records with data from third-party APIs — for enrichment, validation, or compliance.

DB → API

Data activation (Reverse ETL)

Push enriched data from your database back into sales, marketing, and ops apps.

API → API

Cross-app workflows (iPaaS automation)

Automate business processes across multiple apps — sync orders, onboard employees, automate billing.

Multi-API → Unified DB

API aggregation (Unified data layers)

Combine multiple APIs into a single normalized source of truth.

Learn from prebuilt integrationsDiscover a growing library of production-ready templates and workflows for Salesforce, Mailchimp, BigCommerce, and more. Learn real patterns. Start faster.

Supercharge your integrations