# sg-madhavan/sql-based---ids architecture

> Architecture diagram of the GitHub repository sg-madhavan/sql-based---ids, generated by GitDiagram from its file tree, README and a sample of source files (last updated 2026-10-03). It is an AI-made overview: check details against the source.

- Interactive diagram: https://gitdiagram.com/sg-madhavan/sql-based---ids
- Repository: https://github.com/sg-madhavan/sql-based---ids

## Overview

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`](https://github.com/sg-madhavan/sql-based---ids/blob/main/sqlproject.sql) (Login Trigger)

## Diagram (Mermaid)

```mermaid
flowchart TD

subgraph group_identity["Identity and Login"]
  node_accounts[("User Accounts<br/>[sqlproject.sql]")]
  node_login_records[("Login Records<br/>[sqlproject.sql]")]
end

subgraph group_detection["Attack Detection"]
  node_trigger["Login Trigger<br/>[sqlproject.sql]"]
end

subgraph group_response["Security Response"]
  node_blocked_ips[("Blocked IPs<br/>[sqlproject.sql]")]
  node_alerts[("Security Alerts<br/>[sqlproject.sql]")]
end

node_user(("Login User"))
node_security_team(("Security Team"))

node_user -->|"submits attempt"| node_login_records
node_login_records -->|"references user"| node_accounts
node_login_records -->|"fires after attempt"| node_trigger
node_trigger -->|"counts failures"| node_login_records
node_trigger -->|"records blocked IP"| node_blocked_ips
node_trigger -->|"generates alert"| node_alerts
node_security_team -->|"reviews"| node_blocked_ips
node_security_team -->|"reviews"| node_alerts

click node_accounts "https://github.com/sg-madhavan/sql-based---ids/blob/main/sqlproject.sql"
click node_login_records "https://github.com/sg-madhavan/sql-based---ids/blob/main/sqlproject.sql"
click node_trigger "https://github.com/sg-madhavan/sql-based---ids/blob/main/sqlproject.sql"
click node_blocked_ips "https://github.com/sg-madhavan/sql-based---ids/blob/main/sqlproject.sql"
click node_alerts "https://github.com/sg-madhavan/sql-based---ids/blob/main/sqlproject.sql"

classDef toneNeutral fill:#f8fafc,stroke:#334155,stroke-width:1.5px,color:#0f172a
classDef toneBlue fill:#dbeafe,stroke:#2563eb,stroke-width:1.5px,color:#172554
classDef toneAmber fill:#fef3c7,stroke:#d97706,stroke-width:1.5px,color:#78350f
classDef toneMint fill:#dcfce7,stroke:#16a34a,stroke-width:1.5px,color:#14532d
classDef toneRose fill:#ffe4e6,stroke:#e11d48,stroke-width:1.5px,color:#881337
classDef toneIndigo fill:#e0e7ff,stroke:#4f46e5,stroke-width:1.5px,color:#312e81
classDef toneTeal fill:#ccfbf1,stroke:#0f766e,stroke-width:1.5px,color:#134e4a
class node_accounts,node_login_records,node_user toneBlue
class node_trigger toneAmber
class node_blocked_ips,node_alerts toneMint
class node_security_team toneIndigo
```

## Components

### Identity and Login

- [User Accounts](https://github.com/sg-madhavan/sql-based---ids/blob/main/sqlproject.sql): `sqlproject.sql`
- [Login Records](https://github.com/sg-madhavan/sql-based---ids/blob/main/sqlproject.sql): `sqlproject.sql`

### Attack Detection

- [Login Trigger](https://github.com/sg-madhavan/sql-based---ids/blob/main/sqlproject.sql): `sqlproject.sql`

### Security Response

- [Blocked IPs](https://github.com/sg-madhavan/sql-based---ids/blob/main/sqlproject.sql): `sqlproject.sql`
- [Security Alerts](https://github.com/sg-madhavan/sql-based---ids/blob/main/sqlproject.sql): `sqlproject.sql`

### Other components

- **Login User**
- **Security Team**

## Connections

- Login User → Login Records: submits attempt (evidence: `README.md`)
- Login Records → User Accounts: references user (evidence: `README.md`)
- Login Records → Login Trigger: fires after attempt (evidence: `README.md`)
- Login Trigger → Login Records: counts failures (evidence: `README.md`)
- Login Trigger → Blocked IPs: records blocked IP (evidence: `README.md`)
- Login Trigger → Security Alerts: generates alert (evidence: `README.md`)
- Security Team → Blocked IPs: reviews (evidence: `README.md`)
- Security Team → Security Alerts: reviews (evidence: `README.md`)
