A standalone, database-driven job scheduler for PostgreSQL with advanced features like task chains, YAML configuration, and built-in operations.
pg_timetable is a standalone job scheduler built for PostgreSQL that enables users to schedule and automate database tasks, system commands, and built-in operations. It solves the problem of managing complex, time-based workflows within PostgreSQL by offering advanced features like task chaining, YAML configuration, and enhanced cron-style scheduling.
Database administrators, backend developers, and DevOps engineers who need to automate PostgreSQL database maintenance, ETL pipelines, and recurring tasks within a PostgreSQL environment.
Developers choose pg_timetable for its deep PostgreSQL integration, advanced scheduling capabilities beyond basic cron, and flexible configuration options including YAML support, making it a powerful and maintainable solution for database automation.
pg_timetable: Advanced scheduling for PostgreSQL
Open-Awesome is built by the community, for the community. Submit a project, suggest an awesome list, or help improve the catalog on GitHub.
Enables sequential workflows with parameters, as shown in YAML examples for ETL pipelines, allowing complex job dependencies beyond simple cron jobs.
Supports both SQL inserts and YAML files, offering flexibility for database-driven or file-based setups, with YAML providing readable and maintainable chain definitions.
Logs and configuration are stored directly in the database, leveraging PostgreSQL's reliability for job management and ensuring consistency without external tools.
Extends cron syntax with retries, repetitions, and concurrency protection, handling missed chains and overlapping executions effectively, as highlighted in the features list.
Limited to PostgreSQL databases, making it unsuitable for heterogeneous environments that require scheduling across different data stores or non-PostgreSQL systems.
Requires running a standalone service, which adds deployment and maintenance complexity compared to built-in OS schedulers like cron, as noted in the quick start steps.
Management is purely through SQL or YAML files, which can be less intuitive for teams accustomed to visual job monitoring tools, with no GUI mentioned in the README.
pg_timetable is an open-source alternative to the following products: