/sql-alerts

Get notifications about new rows in your database

Primary LanguageGoMIT LicenseMIT

SQL New rows monitoring

sqlal

About

Just check new rows by specified queries and send notification to ntfy

Now support MySQL only

Installation

brew tap yendefrr/tap
brew install sql-alerts

For linux use install.sh or download from latest release

Configuration

sqlal config # or edit `.config/sqlal/config.json

All queries must be SELECT type and query only one column that should be unique ID

For disable query provide "disabled": true parameter

Usage

After configuration run

sqlal start

or

sqlal start --config <path-to-config>

To stop service

sqlal stop

TODO

  • Other SQL drivers
  • DB configuration
  • Validation
  • Run in background