How sg-madhavan/sql-based---ids works
This SQL-based IDS records login attempts and uses an after-attempt trigger to count failures by IP; at five or more, it records a block and generates an alert. Security teams review the resulting records. The README documents the schema and workflow, but no SQL source excerpt was provided, so implementation details beyond those documented are not inferred.
Main entry points: sqlproject.sql Login Trigger
Components 7
Identity and Login
- User Accounts
sqlproject.sql - Login Records
sqlproject.sql
Attack Detection
- Login Trigger
sqlproject.sql
Security Response
- Blocked IPs
sqlproject.sql - Security Alerts
sqlproject.sql
Other components
- Login User
- Security Team
Connections 8
- Login User → Login Records: submits attempt
README.md - Login Records → User Accounts: references user
README.md - Login Records → Login Trigger: fires after attempt
README.md - Login Trigger → Login Records: counts failures
README.md - Login Trigger → Blocked IPs: records blocked IP
README.md - Login Trigger → Security Alerts: generates alert
README.md - Security Team → Blocked IPs: reviews
README.md - Security Team → Security Alerts: reviews
README.md