PostgreSQL Change Notifier

Overview

Listens to PostgreSQL NOTIFY events from database triggers and analyzes each change for significance. The change analyzer classifies events by impact level and routes notifications to the appropriate team using trigger_agent to call the notification dispatcher. High-significance events are stored in the database for audit trailing. Includes SQL examples for setting up database triggers.

Use cases

Architecture

Main template files

Install these files with connic init my-project --templates=postgres-change-notifier. The CLI places agent definitions in a folder named after the template under agents/.

postgres-change-notifier/
  agents/
    change-analyzer.yaml
    notification-dispatcher.yaml
  tools/
    notification_tools.py
  schemas/
    change-analysis.json
  requirements.txt
  README.md

Get started

Install the template, create a Connic project, and deploy through a connected Git repository or the CLI.

1. 1

   Install and scaffold

   Install the SDK and create a project from this template.

   terminal

   Copy

   pip install connic-composer-sdk
   connic init my-project --templates=postgres-change-notifier

   Then cd my-project

2. 2

   Deploy

   Choose a deployment method. A connected Git repository deploys on push; use the CLI for projects without a connected Git repository.

   Git integration

   1. 1

      In Connic: Project Settings → Git & Environments, connect the GitHub repository

   2. 2

      On the same page, map a branch (e.g. main) to the Production environment

   3. 3

      Push the scaffolded project to that repository

   terminal

   Copy

   git add .
   git commit -m "Add PostgreSQL Change Notifier template"
   git push origin main

   CLI deploy

   1. 1

      In Connic: Project Settings → API Keys & MCP Auth, create an API key and copy project ID

   2. 2

      Run connic login in the project folder

   3. 3

      Use connic dev to try with hot-reload, connic test to run suites, or connic deploy for production

   terminal

   Copy

   connic login
   connic dev     # Ephemeral dev env with hot-reload
   connic test    # Run declarative test suites
   connic deploy  # Deploy to production

3. 3

   Connect and configure

   Add a PostgreSQL connector with the database credentials and LISTEN channel. Set up a trigger function to send NOTIFY events (see the README for SQL examples). Use a connic/* model, or add BYOK credentials under Project Settings → LLM Provider.

   Full connector setup guideQuickstart guideConnector docs