An expert database companion for writing, debugging, and optimizing SQL queries across multiple dialects.
Install & Download
1. ClawHub CLI
The fastest way to install a skill directly from the registry.
npx clawhub@latest install 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 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 comprehensive skill designed to empower developers and data analysts with deep database expertise. It streamlines the process of interacting with relational databases by providing intelligent query construction, performance tuning, and schema design advice. By leveraging this tool within Openclaw Skills, users can handle everything from simple data retrieval to complex analytical window functions with ease.
This skill serves as a bridge between high-level requirements and technical implementation, supporting major dialects like MySQL, PostgreSQL, SQLite, and SQL Server. Whether you are building a new application or troubleshooting a legacy database, SQL Assistant ensures your SQL code is efficient, secure, and maintainable.
SQL Assistant Use Cases
- Generating complex SQL queries involving multiple joins, CTEs, and window functions.
- Debugging syntax errors and logical flaws in existing database queries.
- Optimizing slow-running queries through index recommendations and execution plan analysis.
- Designing normalized database schemas with proper primary and foreign key relationships.
- Translating SQL queries between different dialects like PostgreSQL and T-SQL.
How SQL Assistant Works
- The user provides a natural language description of the data they need or an existing query that requires attention.
- SQL Assistant analyzes the request, identifying the target database dialect and core logic required.
- The skill generates or modifies the SQL code, applying best practices for performance and readability.
- For optimization tasks, it evaluates the query structure and suggests indexing strategies or structural changes.
- The final output includes the SQL code along with a detailed explanation of how it functions and tips for implementation.
SQL Assistant Setup
To begin using the SQL Assistant within your environment, ensure your AI agent has access to the skill repository. No complex installation is required beyond configuring your preferred database dialect within the Openclaw Skills framework.
# Example: Accessing SQL Assistant help via CLI
openclaw-agent install sql-assistant
Once installed, you can trigger the skill by asking your agent to write a SQL query or optimize this database schema.
SQL Assistant Data Schema & Taxonomy
The skill utilizes a structured approach to categorize database knowledge and query patterns to ensure accuracy across Openclaw Skills.
| Component | Description |
|---|---|
| Dialect Support | Context-specific syntax for MySQL, PostgreSQL, SQLite, and T-SQL. |
| Query Library | A repository of common patterns like pagination, ranking, and conditional aggregation. |
| Optimization Rules | Heuristics for indexing, subquery-to-join conversion, and EXPLAIN analysis. |
| Schema Metadata | Templates for normalization, data types, and referential integrity. |
SQL Assistant Advanced Features
- Execution plan analysis using EXPLAIN to identify full table scans and performance bottlenecks.
- Support for advanced analytical tools like window functions (ROW_NUMBER, LAG, LEAD) and pivot tables.
- Dialect-specific optimization, including backtick vs. double quote handling and unique date functions.
- Security-focused query generation to prevent SQL injection and promote parameterized patterns.
SKILL.md
Loading
Related Openclaw Skills
Sora 2 Superhero Movie Generator
An AI skill for generating professional-grade 4K superhero cinematic sequences using OpenAI Sora 2.
Sora 2 Nature Documentary
A high-performance cinematic video generation skill designed to produce professional 4K wildlife and nature documentary footage using OpenAI Sora 2.
Sora 2 Futuristic Tech Showcase
A high-fidelity AI video generation skill for creating futuristic technology concepts and cinematic product showcases using OpenAI Sora 2.
Social Media Story Video
A professionally curated prompt template designed to generate high-converting 15-second vertical story videos for social media platforms.
Stable Diffusion Prompt Guide (Basic to Advanced)
A professional framework for specifying camera angles, perspectives, and subject engagement within Stable Diffusion prompts.
AI Game Prompt (TrueSlazac)
A specialized skill for accessing and utilizing AI game generation prompts sourced from social media influencers like TrueSlazac.
Featured*
