SQL Send

Database Messaging

Send emails and SMS directly from SQL Server and PostgreSQL via SendGrid, Resend, and Twilio. Transactional outbox pattern ensures guaranteed delivery with no lost messages.

Supported Providers

📧

SendGrid

✉️

Resend

📱

Twilio

SMS

🔧

Custom SMTP

Transactional Outbox Pattern

Messages are written to an outbox table in the same transaction as your data changes. No messages are ever lost, even during failures.

┌─────────────────────────────────────────────────────────────────┐
│  1. Application Transaction                                      │
│  ─────────────────────────────────────────────────────────────  │
│  BEGIN TRANSACTION                                               │
│    INSERT INTO Orders (CustomerId, Total) VALUES (1, 99.99);    │
│    INSERT INTO sql2ai.Outbox (Type, Payload) VALUES             │
│      ('order_confirmation', '{"orderId": 123, "email": "..."}');│
│  COMMIT                                                          │
└─────────────────────────────────────────────────────────────────┘
                            │
                            ▼
┌─────────────────────────────────────────────────────────────────┐
│  2. SQL Send Agent (polls Outbox)                                │
│  ─────────────────────────────────────────────────────────────  │
│  • Reads pending messages                                        │
│  • Sends via configured provider                                 │
│  • Marks as sent (or retries on failure)                        │
│  • Moves to archive after success                                │
└─────────────────────────────────────────────────────────────────┘
                            │
                            ▼
┌─────────────────────────────────────────────────────────────────┐
│  3. Provider Delivery                                            │
│  ─────────────────────────────────────────────────────────────  │
│  SendGrid / Resend / Twilio → Customer                          │
└─────────────────────────────────────────────────────────────────┘

Simple SQL Interface

-- Send an email
EXEC sql2ai.SendEmail
    @To = 'customer@example.com',
    @Subject = 'Order Confirmation',
    @Body = '<h1>Thank you for your order!</h1>',
    @Provider = 'sendgrid';  -- or 'resend'

-- Send an SMS
EXEC sql2ai.SendSMS
    @To = '+1234567890',
    @Message = 'Your order has shipped!',
    @Provider = 'twilio';

-- Send with template
EXEC sql2ai.SendEmail
    @To = 'customer@example.com',
    @Template = 'order_confirmation',
    @TemplateData = '{"orderId": 12345, "total": 99.99}';

-- Bulk send (queued efficiently)
EXEC sql2ai.SendBulkEmail
    @Recipients = '[
        {"email": "a@x.com", "data": {"name": "Alice"}},
        {"email": "b@x.com", "data": {"name": "Bob"}}
    ]',
    @Template = 'newsletter';

Features

Guaranteed Delivery

Outbox pattern ensures no messages are ever lost

Retry Logic

Automatic retries with exponential backoff

Template Engine

Handlebars templates with data binding

Tracking

Delivery status, opens, clicks tracked

Rate Limiting

Respect provider rate limits automatically

Audit Trail

Complete history of all sent messages

Delivery Dashboard

╔══════════════════════════════════════════════════════════════════╗
║                    SQL SEND DASHBOARD                             ║
╠══════════════════════════════════════════════════════════════════╣
║ LAST 24 HOURS                                                     ║
║ ─────────────────────────────────────────────────────────────── ║
║ Emails Sent:      12,847                                          ║
║ SMS Sent:         1,234                                           ║
║ Delivery Rate:    99.7%                                           ║
║ Open Rate:        34.2%                                           ║
╠══════════════════════════════════════════════════════════════════╣
║ OUTBOX STATUS                                                     ║
║ ─────────────────────────────────────────────────────────────── ║
║ Pending:          23                                              ║
║ Processing:       5                                               ║
║ Retry Queue:      2 (next retry in 5 min)                        ║
║ Failed (24h):     4                                               ║
╠══════════════════════════════════════════════════════════════════╣
║ BY PROVIDER                                                       ║
║ ─────────────────────────────────────────────────────────────── ║
║ SendGrid:         10,234 emails | 99.8% delivered                ║
║ Resend:           2,613 emails  | 99.5% delivered                ║
║ Twilio:           1,234 SMS     | 99.9% delivered                ║
╚══════════════════════════════════════════════════════════════════╝

Send Messages Reliably

Email and SMS from your database with guaranteed delivery and full tracking.

Start Free Trial View All Features

No credit card required • Free for individual developers