Agent skill

sql-gen

Generate SQL queries from natural language

Stars 163
Forks 31

Install this agent skill to your Project

npx add-skill https://github.com/majiayu000/claude-skill-registry/tree/main/skills/other/ai-sql

SKILL.md

SQL Generator

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

Quick Start

bash
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

bash
# 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

sql
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

Expand your agent's capabilities with these related and highly-rated skills.

Didn't find tool you were looking for?

Be as detailed as possible for better results