SQL Receive

Secure Inbound Gateway

Secure inbound gateway for files, APIs, and emails. Malware scanning, data integrity checks, data leak prevention, and SQL injection detection before data enters your database.

Supported Input Sources

📁

File Uploads

CSV, Excel, JSON, XML

🔗

API Webhooks

REST endpoints

📥

Email Inbox

IMAP/POP3 polling

🔒

SFTP/FTP

Secure file transfer

Security Pipeline

Every inbound item passes through multiple security checks before reaching your database

INBOUND SECURITY PIPELINE
═══════════════════════════════════════════════════════════════

   Incoming Data
        │
        ▼
┌───────────────────────────────────────────────────────────┐
│  1. MALWARE SCAN                                          │
│  • ClamAV integration                                     │
│  • Virus signature detection                              │
│  • Macro/script detection in files                        │
│  • ✓ Pass / ✗ Quarantine                                 │
└───────────────────────────────────────────────────────────┘
        │
        ▼
┌───────────────────────────────────────────────────────────┐
│  2. DATA INTEGRITY CHECK                                  │
│  • File format validation                                 │
│  • Schema compliance                                      │
│  • Required field verification                            │
│  • Encoding detection (UTF-8, etc.)                       │
└───────────────────────────────────────────────────────────┘
        │
        ▼
┌───────────────────────────────────────────────────────────┐
│  3. DATA LEAK DETECTION                                   │
│  • Presidio PII scanning                                  │
│  • Secret/credential detection                            │
│  • Policy violation alerts                                │
│  • Redaction or rejection                                 │
└───────────────────────────────────────────────────────────┘
        │
        ▼
┌───────────────────────────────────────────────────────────┐
│  4. SQL INJECTION PREVENTION                              │
│  • Pattern matching for SQL commands                      │
│  • Comment injection detection                            │
│  • Union/batch attack prevention                          │
│  • Parameterized insert preparation                       │
└───────────────────────────────────────────────────────────┘
        │
        ▼
   ✓ Safe to Insert

Threat Detection Examples

SCAN RESULTS: customer_import.csv
════════════════════════════════════════════════════════════

✓ Malware Scan:     Clean (ClamAV 1.2.0)
✓ Format Valid:     CSV with 1,234 rows
⚠ Integrity Issues: 23 rows with missing email

SECURITY THREATS DETECTED:
┌─────────┬───────────────────────────────────────────────────┐
│ Row 47  │ SQL INJECTION ATTEMPT                             │
│         │ Value: "'; DROP TABLE Customers;--"               │
│         │ Action: Row rejected, logged, alert sent          │
├─────────┼───────────────────────────────────────────────────┤
│ Row 156 │ PII IN NOTES FIELD                                │
│         │ Found: SSN (confidence: 98%)                      │
│         │ Action: Redacted to "XXX-XX-XXXX"                 │
├─────────┼───────────────────────────────────────────────────┤
│ Row 892 │ POTENTIAL DATA LEAK                               │
│         │ Found: API key pattern in description             │
│         │ Action: Row quarantined for review                │
└─────────┴───────────────────────────────────────────────────┘

RESULT: 1,210 rows ready for import
        23 rows need review (missing data)
        1 row rejected (SQL injection)

Configuration

# sql2ai-receive.yaml
security:
  malware:
    enabled: true
    engine: clamav
    quarantine_path: /secure/quarantine/

  pii_detection:
    enabled: true
    action: redact  # or 'reject', 'flag'
    entities:
      - SSN
      - CREDIT_CARD
      - EMAIL_ADDRESS

  sql_injection:
    enabled: true
    action: reject
    log_attempts: true
    alert_on_detection: true

  integrity:
    validate_schema: true
    required_fields: [id, email, created_at]
    encoding: utf-8

sources:
  file_upload:
    endpoint: /api/receive/files
    max_size: 100MB
    allowed_types: [csv, xlsx, json]

  webhook:
    endpoint: /api/receive/webhook
    auth: hmac_signature
    secret: ${WEBHOOK_SECRET}

  email:
    imap_server: imap.company.com
    poll_interval: 5m
    allowed_senders: ["*@partner.com"]

Security Dashboard

╔══════════════════════════════════════════════════════════════════╗
║                    SQL RECEIVE SECURITY                           ║
╠══════════════════════════════════════════════════════════════════╣
║ LAST 24 HOURS                                                     ║
║ ─────────────────────────────────────────────────────────────── ║
║ Items Processed:  4,721                                           ║
║ Clean:            4,683 (99.2%)                                   ║
║ Threats Blocked:  38                                              ║
╠══════════════════════════════════════════════════════════════════╣
║ THREAT BREAKDOWN                                                  ║
║ ─────────────────────────────────────────────────────────────── ║
║ Malware:              2                                           ║
║ SQL Injection:        8                                           ║
║ PII Detected:         23 (redacted)                              ║
║ Data Leaks:           5 (quarantined)                            ║
╠══════════════════════════════════════════════════════════════════╣
║ BY SOURCE                                                         ║
║ ─────────────────────────────────────────────────────────────── ║
║ File Upload:      2,341 | 3 threats                              ║
║ API Webhook:      1,892 | 4 threats                              ║
║ Email Inbox:      488   | 31 threats                             ║
╚══════════════════════════════════════════════════════════════════╝

Secure Your Inbound Data

Multi-layer security scanning for all data entering your database.

Start Free Trial View All Features

No credit card required • Free for individual developers