Sequor

Sequor is a SQL-centric application integration platform designed to facilitate the creation of intelligent API-to-API workflows. The platform enables users to build complete API workflows using a combination of YAML for workflow structure and SQL for data transformation, allowing integration flows to be defined in a clear, version control-friendly format. Sequor uses the database as the processing engine, supporting data movement from APIs into databases, transformation with SQL, and pushing results to various destinations.

The tool emphasizes flexibility and customization through dynamic YAML configuration, including computed properties using Python expressions and Jinja templates for environment variable injection. Sequor features built-in reliability with data validation, retries, and task-level observability. Its database integration allows users to iterate over input tables to make API calls per record, mapping every HTTP response directly to database tables and enabling seamless data flow without the need for custom glue code.

Sequor supports a range of integration patterns, including data acquisition from APIs to databases, reverse ETL from databases to APIs, data enrichment by combining databases and APIs, and complex cross-application automation workflows. The platform provides production-ready templates for common services such as Salesforce, HubSpot, Mailchimp, Shopify, and Stripe, which can be copied, customized, and deployed to accelerate workflow development.

Sequor is delivered as a command-line tool, installable via pip, and is intended for users who prefer code-first principles and integration with their own IDEs and version control systems. The platform is developed by Palo Alto Databases, Inc.