OpenSkillIndex← back to search
claude-codeopenclaw

Awesome-openclaw-skills sql-gen

Generate SQL queries from natural language

install
source · Clone the upstream repo
git clone https://github.com/sundial-org/awesome-openclaw-skills
Claude Code · Install into ~/.claude/skills/
T=$(mktemp -d) && git clone --depth=1 https://github.com/sundial-org/awesome-openclaw-skills "$T" && mkdir -p ~/.claude/skills && cp -r "$T/skills/sql-gen" ~/.claude/skills/sundial-org-awesome-openclaw-skills-sql-gen && rm -rf "$T"
OpenClaw · Install into ~/.openclaw/skills/
T=$(mktemp -d) && git clone --depth=1 https://github.com/sundial-org/awesome-openclaw-skills "$T" && mkdir -p ~/.openclaw/skills && cp -r "$T/skills/sql-gen" ~/.openclaw/skills/sundial-org-awesome-openclaw-skills-sql-gen && rm -rf "$T"
manifest: skills/sql-gen/SKILL.md
source content

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