Tech Stack
Node.js
express.js
MySQL
Description
Gogimail Server is a Node.js + Express backend that turns natural-language requests into safe, parameterized SQL queries via OpenAI. It then runs those queries on a MySQL customer catalog and crafts a user-facing answer or marketing message.
- POST /api/query: accepts text prompts, generates and validates SQL queries, executes allowed queries, summarizes results, and expands into human-readable responses.
- GET /api/health: checks DB connection status.
- GET /api/catalog: returns allowed table/column catalog.
- AI-powered natural-language access to SQL data
- Built-in SQL allowlisting + injection-safe query validation
- Limits queries to SELECT + LIMIT <= 50 + column allowlist
- Maintains structured logging for /api/* requests
- Modular design: planner, validator, writer, routes