An AI-powered assistant for generating, explaining, and optimizing SQL queries directly from your terminal.
Install & Download
1. ClawHub CLI
The fastest way to install a skill directly from the registry.
npx clawhub@latest install ai-sql-assistant
2. Manual Installation
Copy the skill folder to one of these locations
~/.openclaw/skills/ <project>/skills/ Priority: Workspace > Local > Bundled
3. Prompt Installation
Copy this prompt to OpenClaw to install it automatically.
Help me install ai-sql-assistant using Clawhub. If Clawhub is not installed, install it first (npm i -g clawhub).
Prefer to download?
Get the raw skill files in a ZIP archive.
What is SQL Assistant?
SQL Assistant is a professional-grade developer tool designed to bridge the gap between natural language and complex database logic. Built as part of the Openclaw Skills library, it leverages the Evolink.ai engine to provide intelligent SQL generation, performance tuning, and security audits for major database systems including SQLite, PostgreSQL, and MySQL.
This utility prioritizes security and developer control by focusing exclusively on SQL text analysis. It never connects to or executes commands against your live databases, ensuring that every generated query or optimization suggestion can be reviewed before implementation. It is an essential asset for developers looking to accelerate their schema design and query writing processes.
SQL Assistant Use Cases
- Converting natural language descriptions into production-ready SQL queries.
- Explaining legacy or complex SQL scripts to understand logic and data flow.
- Identifying performance bottlenecks and receiving specific indexing recommendations.
- Performing security audits on SQL files to prevent injection and data exposure.
- Generating structured database migration files with corresponding up and down logic.
How SQL Assistant Works
- The user inputs a command or natural language prompt via the Openclaw Skills interface.
- For AI-driven tasks, the skill sends the query text or description to the Evolink.ai API using a secure connection.
- The AI model processes the request based on the specified database dialect (PostgreSQL, MySQL, or SQLite).
- The processed SQL, explanation, or optimization report is returned to the user's terminal.
- For local reference tasks, the skill instantly retrieves database-specific cheatsheets without requiring network access.
SQL Assistant Setup
To get started, ensure you have python3 and curl installed. You will also need an API key from the provider.
export EVOLINK_API_KEY="your-key-here"
You can then run the skill using the provided bash script:
bash scripts/sql.sh query "find users with most orders" --db postgres
SQL Assistant Data Schema & Taxonomy
The skill organizes its operations around the following data structures:
| Component | Type | Description |
|---|---|---|
| Input Source | String/File | Natural language prompts or existing .sql file paths |
| Database Dialect | Parameter | Targets specific syntax for sqlite, postgres, or mysql |
| Output Format | Text/SQL | Formatted SQL blocks, step-by-step explanations, or security tables |
| Configuration | Env Var | Uses EVOLINK_API_KEY for authentication and optional EVOLINK_MODEL selection |
SQL Assistant Advanced Features
- Support for complex SQL patterns including CTEs, window functions, and recursive queries.
- Context-aware security reviews that flag high-risk operations and privilege issues.
- Automated migration generation that handles schema changes for both forward and rollback states.
- Deep integration with Openclaw Skills for seamless CLI-based database research and development.
- Built-in local documentation for psql commands, WAL mode, and common database patterns.
SKILL.md
Loading
Related Openclaw Skills
Wanjie Video Skill
A high-performance Veo video generation skill for AI agents that supports full automation and natural language prompt processing.
wanjie-video-skill
A high-performance Veo video generation skill featuring autonomous monitoring and natural language triggers.
Shopify App Recommendations
A data-driven advisor for building and optimizing your Shopify app stack based on growth stage and performance.
Shopify Email Flows
An expert strategic skill for designing, auditing, and implementing high-conversion email automation workflows for Shopify stores.
Weibo Hotspot Consumer
A specialized tool for fetching, grouping, and automating the retrieval of real-time trending topics from Weibo using the Openclaw Skills framework.
boxed-fetch
A secure WebAssembly-based tool for fetching URL content and extracting readable text in a sandboxed environment.
Featured*
