Skip to content

SKILL.md

Latest commit

 

History

History
68 lines (47 loc) · 1.18 KB

SKILL.md

File metadata and controls

68 lines (47 loc) · 1.18 KB
name sql-gen
description Generate SQL queries from natural language

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