SQL Assistant

AI-powered SQL generation, analysis, and optimization from your terminal. Supports SQLite, PostgreSQL, and MySQL. This skill never connects to or executes against any database — it only generates and analyzes SQL text.

Powered by Evolink.ai

When to Use

• User says "write me a query that..." or "generate SQL for..."
• User has a SQL file and asks "what does this query do?"
• User says "this query is slow" or "optimize this SQL"
• User wants a security review of SQL before running it
• User needs to generate a database migration
• User needs quick SQL reference for a specific database

Quick Start

1. Set your EvoLink API key

export EVOLINK_API_KEY="your-key-here"

Get a free key: evolink.ai/signup

2. Generate SQL from natural language

bash scripts/sql.sh query "find all users who signed up last month with more than 5 orders" --db postgres

3. Analyze existing SQL

bash scripts/sql.sh explain slow-query.sql

bash scripts/sql.sh optimize report.sql --db postgres

Capabilities

AI Commands (require EVOLINK_API_KEY)

Info Commands (no API key needed)

Supported Databases

Cheatsheet Topics

Examples

Generate SQL from natural language

bash scripts/sql.sh query "monthly revenue by product category for the last 6 months" --db postgres

Output:

SELECT
  c.name AS category,
  DATE_TRUNC('month', o.created_at) AS month,
  SUM(oi.quantity * oi.unit_price) AS revenue
FROM order_items oi
JOIN orders o ON o.id = oi.order_id
JOIN products p ON p.id = oi.product_id
JOIN categories c ON c.id = p.category_id
WHERE o.created_at >= NOW() - INTERVAL '6 months'
GROUP BY c.name, DATE_TRUNC('month', o.created_at)
ORDER BY month DESC, revenue DESC;

Security review

bash scripts/sql.sh review migration.sql

Generate migration

bash scripts/sql.sh migrate "add soft delete to users and orders tables" --db postgres

Configuration

Required binaries: python3, curl

Security

Data Transmission

AI commands send user-provided SQL text or natural language descriptions to api.evolink.ai for analysis by Claude. By setting EVOLINK_API_KEY and using these commands, you consent to this transmission. Data is not stored after the response is returned. The databases and cheatsheet commands run entirely locally and never transmit data.

No Database Access

This skill never connects to, reads from, or writes to any database. It only generates and analyzes SQL text. All generated SQL must be reviewed and executed by the user.

Network Access

• api.evolink.ai — AI SQL analysis (AI commands only)

Persistence & Privilege

This skill creates temporary files for API payload construction which are cleaned up automatically. No credentials or persistent data are stored. The skill only reads files explicitly passed as arguments.

Links

• GitHub
• EvoLink API
• Community
• Support