Contract Renewal and Expiry Agent

Agent Description:

The Contract Renewal and Expiry Agent automatically monitors contract end dates using SQL database queries. It identifies agreements nearing expiration (for example, within 30 days) by calculating the remaining duration. The agent then proactively sends chat notifications to users about upcoming renewals. If no contracts require attention, it confirms that all records are up to date, ensuring timely actions.

Purpose and Components
  • Purpose: To automatically monitor contract end dates, identify upcoming expirations, and alert users proactively to ensure timely renewals and prevent missed deadlines.
  • Components:

    • SQL Data Extractor for retrieving contract details and expiry dates from databases.

    • Date Evaluation Engine for calculating remaining days until contract expiry.

    • Alert Module for notifying users in chat about contracts nearing expiration.

    • Monitoring System for continuously tracking contract lifecycle and updating statuses.
Supported Capabilities

  • Connect to SQL databases and read contract metadata.

  • Extract contract IDs, names, end dates, renewal terms, and statuses.

  • Calculate remaining validity days for each active contract.

  • Identify contracts expiring within a defined time frame (example, 30 days).

  • Notify users directly in chat when contracts are near expiry.

  • Display all active and expiring contracts in tabular format.

  • Keep monitoring database for updated expiry statuses.

LLM Used

  • GPT-5 (Default, inherits capabilities from parent orchestration agent)

    Note: To learn more about the LLM and to modify its behavior, refer to the Configuring LLM settings section.

Sub-Agents

1. Contract Data Agent

  • Role:Data Extractor
  • Scope:Retrieve and identify contracts nearing expiry using SQL queries.
  • Description: This sub-agent connects to the contracts SQL database, retrieves contract details such as ContractID, ClientName, EndDate, RenewalTerms, and Status. It calculates the remaining days until expiry for each record and filters out contracts that are expiring soon (example, within 30 days). The results are sent to the notifier agent for alerting.
  • LLM Used: Default (inherits from parent).
  • Tools used: SQL Query Tool, Info SQL

2. Expiry Notifier Agent

  • Role:Chat Notifier
  • Scope:Notify user in chat if any contract is nearing expiry.
  • Description: This sub-agent receives contract data from ContractDataAgent and checks each record’s expiry status. If a contract is expiring within 30 days, it generates a chat alert such as:

    • Contract ‘ABC Corp Supply Agreement’ (Contract ID: C102) is expiring in 14 days.

      If all contracts are up-to-date, it responds with:

      “ All contracts are active and no renewals are due.”

      It ensures timely awareness and proactive renewal actions by users.

  • LLM Used: Default (inherits from parent).
Tools Used:

  • SQL Query Tool: Executes queries to fetch and analyze contract expiry data.

  • Info SQL Tool: Retrieves metadata and schema structure of contract tables.

Note: For details on modifying the Tools, refer Tools Library section.
Agent Workflow Behavior Summary

  1. ContractDataAgent connects to the SQL database and retrieves contract records.

  2. It calculates remaining days until contract expiry.

  3. Contracts expiring within 30 days are filtered and passed to ExpiryNotifierAgent.

  4. ExpiryNotifierAgent sends a clear message in chat with expiry warnings.

  5. If no contract is due soon, it confirms that all are up-to-date.
Sample Questions:

  • Which contracts are expiring this month?

  • Show all contracts that need renewal soon.

  • Is any client contract expiring within 15 days?

  • List contracts that are currently active.

  • Alert me if any contract expires in the next 30 days.