Building a Contract Expiration Tracker with Paradime Bolt and OpenClaw SDK

This article explains how to build an automated contract expiration monitoring system using Paradime Bolt for scheduling and orchestration and the OpenClaw SDK for AI-powered agent notifications.

What is Paradime?

Paradime is an all-in-one AI-powered platform for analytics engineering, built on top of dbt™ (data build tool). Described as "Cursor for Data," it replaces dbt Cloud with a more user-friendly, efficient experience. Key components include:

• Code IDE — A cloud-based, purpose-built IDE for dbt™ and Python development with AI assistance (DinoAI), inline lineage, data preview, and git-ops.

• Bolt Scheduler — A production-grade orchestration engine for running dbt™ commands, Python scripts, and custom workflows on cron schedules with Slack/email notifications, SLA monitoring, and CI/CD integration.

• Radar — FinOps tooling for Snowflake and BigQuery cost optimization.

• Lineage — End-to-end data lineage across dbt™, Looker, and Tableau.

Bolt supports YAML-based schedule definitions (paradime_schedules.yml), Python script execution via Poetry, environment variable management (including secrets), and a GraphQL API for programmatic triggering.

What is OpenClaw SDK?

The OpenClaw SDK (pip install openclaw-sdk) is a Python library that provides a programmatic interface to the OpenClaw AI agent framework. OpenClaw is an open-source personal AI assistant that runs on your own devices and connects to messaging channels like WhatsApp, Telegram, Slack, and Discord. The SDK (Python 3.11+) supports:

• Agent execution — Send queries and receive results synchronously, asynchronously, or via streaming.

• Cron scheduling — Create and manage recurring tasks on the OpenClaw Gateway.

• Structured output — Parse LLM responses into validated Pydantic models.

• Pipelines — Chain multiple agents where each step feeds the next.

• Cost tracking — Monitor token usage and USD cost across runs.

• FastAPI integration — Drop-in routers for agent, channel, and admin endpoints.

• Channel management — Check status and send messages to connected channels.

Architecture Overview

The contract expiration tracker works as follows:

1. Paradime Bolt runs a scheduled Python script on a cron schedule (e.g., daily at 8 AM UTC).

2. The Python script reads contract data from a data source (e.g., Google Sheets via gspread, or a data warehouse query).

3. The script identifies contracts expiring within a configurable threshold (e.g., 30 days).

4. For each expiring contract, the script uses the OpenClaw SDK to trigger an AI agent that sends notification summaries to Slack, Telegram, or other channels.

5. Optionally, the script also sends a direct Slack webhook notification with a formatted summary.

Step 1: Set Up the dbt™ Project with Python Dependencies

Create a pyproject.toml in your dbt project root:

Step 2: Write the Contract Expiration Checker Script

Create scripts/check_contracts.py in your dbt project:

Step 3: Configure Environment Variables in Paradime

In Paradime Settings → Workspaces → Environment Variables → Bolt Schedules:

You can also bulk upload these via CSV.

Step 4: Define the Bolt Schedule

Add to paradime_schedules.yml in your dbt project root:

This runs the contract checker every day at 8:00 AM UTC. The first command (poetry install) sets up the Python virtual environment and installs dependencies from pyproject.toml. The second command runs the actual script.

Step 5: Monitor and Debug

After the schedule is deployed (auto-refreshed every 10 minutes or manually via "Parse Schedules" in Bolt):

• Run History — View all executions with status, trigger type, branch, duration, and run ID.

• Run Logs — Three levels of detail:

• Manual Trigger — Use the Bolt GraphQL API to trigger on-demand:

Optional: OpenClaw Cron Job for AI-Powered Follow-ups

You can also set up a recurring OpenClaw cron job to have the AI agent proactively check and follow up:

This creates a weekly Monday 9 AM cron job on the OpenClaw Gateway that triggers an isolated agent session, summarizes expiring contracts, and announces results to a Slack channel.

Summary

By combining Paradime Bolt (production-grade scheduling, Python execution, environment variable management, monitoring) with the OpenClaw SDK (AI agent execution, multi-channel notifications, structured output), you can build a fully automated contract expiration monitoring system that not only alerts your team but also provides AI-generated renewal recommendations and action plans. The YAML-based schedule configuration keeps everything version-controlled alongside your dbt project, while OpenClaw's agent framework enables intelligent, context-aware notifications across any messaging channel.