sql-gen

SQL Generator

Describe what you want, get the SQL. Works with any database.

Quick Start

npx ai-sql "get all users who signed up this month and made a purchase"

What It Does

• Converts English to SQL
• Handles complex JOINs
• Adds proper WHERE clauses
• Optimizes for performance

Usage Examples

# Generate query
npx ai-sql "top 10 products by revenue last quarter"

# With schema context
npx ai-sql "users without orders" --schema ./schema.sql

# Specific dialect
npx ai-sql "monthly active users" --dialect postgres

Dialects Supported

• PostgreSQL
• MySQL
• SQLite
• SQL Server
• Oracle

Output Example

SELECT u.id, u.email, COUNT(o.id) as order_count
FROM users u
LEFT JOIN orders o ON u.id = o.user_id
WHERE u.created_at >= DATE_TRUNC('month', CURRENT_DATE)
GROUP BY u.id, u.email
HAVING COUNT(o.id) > 0;

Requirements

Node.js 18+. OPENAI_API_KEY required.

License

MIT. Free forever.

Built by LXGIC Studios

• GitHub: github.com/lxgicstudios/ai-sql
• Twitter: @lxgicstudios