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)
| Command | Description |
|---|---|
query <description> --db <db> |
Generate SQL from natural language |
explain <sql-file> |
Explain what a query does step-by-step |
optimize <sql-file> --db <db> |
Performance optimization with index suggestions |
review <sql-file> |
Security audit — injection, privileges, data exposure |
migrate <description> --db <db> |
Generate UP/DOWN migration SQL |
Info Commands (no API key needed)
| Command | Description |
|---|---|
databases |
List supported databases |
cheatsheet [db|patterns] |
Quick SQL reference and common patterns |
Supported Databases
| Database | Cheatsheet | AI Generation |
|---|---|---|
sqlite |
Connection, import/export, PRAGMA, backup | SQLite-specific syntax |
postgres |
psql commands, types, JSONB, backup/restore | PG-specific (TIMESTAMPTZ, partial indexes, CTEs) |
mysql |
Connection, types, EXPLAIN, backup | MySQL-specific (AUTO_INCREMENT, ON DUPLICATE KEY) |
Cheatsheet Topics
| Topic | Content |
|---|---|
sqlite |
Zero-setup database, CSV import, WAL mode |
postgres |
psql shortcuts, common types, pg_dump |
mysql |
Connection, SHOW commands, mysqldump |
patterns |
Pagination, upsert, CTEs, window functions, recursive queries |
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
| Variable | Default | Required | Description |
|---|---|---|---|
EVOLINK_API_KEY |
— | Yes | Your EvoLink API key. Get one free |
EVOLINK_MODEL |
claude-opus-4-6 |
No | Model for AI analysis |
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.