An AI-driven CLI tool designed to identify and fix performance bottlenecks in SQL and Prisma database queries.
Install & Download
1. ClawHub CLI
The fastest way to install a skill directly from the registry.
npx clawhub@latest install query-optimizer
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 query-optimizer 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 Query Optimizer?
Query Optimizer is a specialized utility within the Openclaw Skills ecosystem that leverages artificial intelligence to streamline database performance tuning. It serves developers who need to resolve slow-loading applications by providing instant, actionable feedback on query structure, indexing strategies, and ORM-specific antipatterns. By integrating this skill into your development environment, you can automate the traditionally manual process of query analysis and performance profiling.
This tool is particularly valuable for teams working with complex data layers where manual optimization is time-consuming. As part of the wider Openclaw Skills library, it emphasizes developer productivity by offering zero-config performance audits that help maintain high-speed applications without requiring deep database administration expertise.
Query Optimizer Use Cases
- Identifying bottlenecks when database queries appear as slow in Application Performance Monitoring (APM) logs.
- Auditing inherited codebases with complex or inefficient Prisma patterns to ensure scalability.
- Resolving user-reported latency by optimizing the specific queries triggered during page loads.
- Educational scenarios where developers want to learn advanced SQL optimization patterns through AI-generated explanations.
How Query Optimizer Works
- The developer provides a raw SQL string or a file path containing Prisma ORM code to the CLI.
- The skill parses the input to extract data access patterns and logical structures.
- It cross-references the code against database best practices to identify missing indexes, N+1 problems, or expensive operations.
- The tool outputs specific, human-readable recommendations, including optimized query rewrites and SQL index creation statements.
Query Optimizer Setup
Query Optimizer requires Node.js 18 or higher and an OpenAI API key. No permanent installation is necessary as it can be run via npx. Set your environment variable and execute the following commands:
export OPENAI_API_KEY=sk-...
npx ai-query-optimize --help
Query Optimizer Data Schema & Taxonomy
The skill processes incoming text or file buffers and produces structured performance insights. Below is the data handling overview:
| Data Type | Source | Analysis Focus |
|---|---|---|
| SQL Query | CLI Argument | Execution plan optimization and index creation |
| Prisma Code | .ts/.js Files | N+1 detection and ORM-to-SQL efficiency |
| Database Schema | .sql Files | Relationship analysis and constraint optimization |
Query Optimizer Advanced Features
- N+1 problem detection designed specifically for identifying inefficient loops in ORM-based API routes.
- Automatic generation of ready-to-use CREATE INDEX statements based on specific WHERE clause patterns.
- Support for multi-file analysis, allowing developers to scan entire directories for performance regressions.
- Deep contextual integration that explains the technical reasoning behind each suggested change to improve developer knowledge.
SKILL.md
Loading
Related Openclaw Skills
Progressive Memory
A token-efficient memory architecture that utilizes indexed progressive disclosure to minimize context rot and maximize agent relevance.
Prisma Generator
A command-line utility that transforms natural language descriptions into complete, syntactically correct Prisma database schemas.
Prisma Gen
Prisma Gen transforms natural language descriptions into fully formatted, production-ready Prisma database schemas in seconds.
Prefetch Advisor
Prefetch Advisor leverages AI to analyze application routing and user flows, recommending specific data and routes to prefetch for instantaneous navigation.
Queue Generator (queue-gen)
A command-line utility that instantly generates production-ready BullMQ queue configurations and worker code from a simple text description.
Queue Generator
Automatically generate BullMQ configurations, worker code, and job producers from a simple natural language description.
Featured*
