We built Sequor to solve a recurring problem: choosing between two bad options for API/app integration:
1. Proprietary black-box SaaS connectors with vendor lock-in
2. Custom scripts that are brittle, opaque, and hard to maintain
Sequor is a SQL-centric workflow framework for building reliable API integrations in modern data stacks — code-first, declarative, and version-controlled. It’s an open source alternative to SaaS connectors, giving data teams full control over their integration pipelines.
Sequor combines SQL with HTTP request handling — think dbt for API integration, but with explicit flow control:
• Iterate over input tables to make parameterized API calls
• Parse and map JSON responses back into database tables
• Use SQL for logic, YAML for flows, and Jinja/Python for dynamic behavior
• Works equally well for data extraction, reverse ETL, and iPaaS-style end-to-end automation
• Git-friendly, no drag-and-drop UIs
Our goal was to bring software engineering best practices to integration workflows — without proprietary environments or vendor lock-in.
Think of Sequor as your integration foundation, not your ceiling. We provide the proven patterns — you build the custom connectors that match your data flows and business logic.
We’d love your feedback, ideas, and contributions.
Website: https://sequor.dev — with code examples
Quickstart: https://docs.sequor.dev/getting-started/quickstart
GitHub: https://github.com/paloaltodatabases/sequor
Prebuilt integrations: https://github.com/paloaltodatabases/sequor-integrations