SQL New rows monitoring

About

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

Now support MySQL only

Installation

curl https://raw.githubusercontent.com/yendefrr/sql-alerts/refs/heads/main/install.sh | sh

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