sequor 0.2.0

SQL-centric API integration platform - unifying apps and data connectivity

Sequor

Sequor is a SQL-centric workflow platform for building reliable API integrations in modern data stacks. It's the open alternative to black-box SaaS connectors, giving data teams complete control over their integration pipelines. With Sequor, you can execute HTTP APIs and database operations in transparent, version-controlled workflows that you fully own and understand. Easily deploy on-premise to completely eliminate SaaS lock-in.

Sequor uniquely fuses API execution with your database, enabling bidirectional data circulation between API and database tables. By storing intermediate data in your database, you can leverage the full power of SQL for transformations, analytics, and business logic. This unified execution model eliminates the traditional boundary between iPaaS-style app integration and ETL-style data pipelines, giving you a single powerful platform for all your integration needs.

With a straightforward code-first approach (YAML for flow configuration, Jinja templates and Python for dynamic parameters, and SQL for logic), you can apply software engineering best practices to integrations — including version control, collaboration, CI/CD, and local development.

Own, control, and scale your integrations with transparent configuration, familiar open techs, and without vendor lock-in.

How Sequor works

Sequor is designed around an intuitive YAML-based workflow definition. Every integration flow is built from these powerful components:

• http_request - Execute API calls with database integration that iterates over input records, performs dynamic HTTP requests, and maps responses back to database tables. Use Jinja templates or Python snippets for dynamic parameterization.
• transform - Apply SQL queries to prepare data for API calls or process API results, leveraging the full power of your database for data manipulation.
• control statements - Build robust workflows with if-then-else conditionals, while loops, try-catch error handling, and more. These high-level orchestration capabilities ensure your integrations handle edge cases gracefully without custom code.

View examples of these operations in action, demonstrating how easy it is to build sophisticated integrations with Sequor.

Getting started

• Install Sequor
• Follow Quickstart
• Explore examples of real-life integrations
• Documentation

Community

• Discuss Sequor on GitHub - To get help and participate in discussions about best practices, or any other conversation that would benefit from being searchable

Stay connected

• Subsribe to our newsletter - updated on new releases and features, guides, and case studies.