The PostgreSQL Query Optimizer is an AI-driven tuning assistant that analyzes slow query logs, execution plans, and table schemas to deliver optimal indexing strategies, SQL rewrites, and configuration parameter adjustments.
Install & Download
1. ClawHub CLI
The fastest way to install a skill directly from the registry.
npx clawhub@latest install postgres-query-optimizer-ai
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 postgres-query-optimizer-ai 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 PostgreSQL Query Optimizer?
The PostgreSQL Query Optimizer is a highly specialized AI agent skill designed to act as a virtual Database Administrator (DBA). By transforming cryptic database execution plan outputs into precise, actionable optimization workflows, it eliminates the guesswork out of query tuning. The system specializes in deep analytical inspections across a wide range of production database scenarios, ensuring your database layer scales efficiently.
Built as a contribution to Openclaw Skills, this tool leverages specialized engineering rules inspired by industry standards like the official PostgreSQL documentation, The Art of PostgreSQL, and pgMustard analysis rules. It cross-references incoming queries against more than 150 performance anti-patterns and 300 automated checklist rules to ensure consistent, enterprise-grade database responses.
PostgreSQL Query Optimizer Use Cases
- Diagnosing Production Bottlenecks: Identify why queries stall under heavy load by breaking down complex
EXPLAIN ANALYZEoutputs. - Automated Index Generation: Safely generate indexing code blocks like
CREATE INDEX CONCURRENTLYfor tables lacking coverage without disrupting running applications. - SQL Refactoring: Rewrite legacy queries, convert slow nested subqueries into clean common table expressions (CTEs) or lateral joins, and rectify sargability issues.
- Database Infrastructure Tune-up: Audit memory settings such as
work_memandshared_buffersagainst runtime constraints to patch configuration mismatches.
How PostgreSQL Query Optimizer Works
- Input Collection: The agent ingests data from the developer, which can include the slow query SQL string,
EXPLAINstatistics, or Table DDL schema definitions. - Execution Plan Parsing: The engine interprets advanced operational metrics such as shared buffer cache hit rates, row estimation mismatches, and problematic operator types like sequence scans.
- Anti-Pattern Matching: The internal reasoning engine matches the structural query footprint against 150+ known performance bottlenecks.
- Strategy Synthesis: The skill produces structural query rewrites, calculates expected reductions in I/O operations, and details the priority level for the proposed fixes.
- Deployment Artifact Delivery: The agent outputs fully executable SQL scripts and structured diagnostics ready for deployment.
PostgreSQL Query Optimizer Setup
To deploy and integrate this database tuning tool within your AI workflow, make sure your local agent runtime environment meets the requirement of version 1.0.0 or greater. Install the skill using the package repository CLI tool:
openclaw install postgres-query-optimizer
Configure your database context or execute an optimization run directly through the workspace interface by referencing the skill name inside your system execution block.
PostgreSQL Query Optimizer Data Schema & Taxonomy
The skill manages inputs and returns diagnoses by mapping out runtime parameters against structured performance properties. Below is the framework used by the database optimizer to structure its analytical output:
| Output Component | Format | Description |
|---|---|---|
| Problem Diagnosis Report | Markdown / Structure | Contains severity categorization, root-cause insights, and clear repair paths. |
| Performance Delta Preview | Table / Text | A before-and-after comparison predicting execution times and I/O reduction ratios. |
| Executable Code Block | SQL | Production-ready statements including CREATE INDEX CONCURRENTLY and optimized query structures. |
PostgreSQL Query Optimizer Advanced Features
- pg_stat_statements Integration: Batch-processes active server performance trends to catch degradation patterns before they affect live users.
- Sargability Code Audits: Automatically validates the
WHEREclauses within queries to ensure search arguments utilize active structural indexes optimally. - Vacuum & Concurrency Tuning: Suggests tailored tuning parameters for
autovacuumworkers and parallel workers tailored to your infrastructure requirements. - Cost Estimation Matrix: Predicts estimated database computing load decreases for every suggested fix to help prioritize engineering efforts.
SKILL.md
Loading
Related Openclaw Skills
Daily Standup Generator
An automated AI-powered tool that gathers Git, task manager, and collaboration data to generate and publish comprehensive, professional daily standup reports for teams.
LYGO Glyph2Resonance
Convert visual math patterns, sacred geometry, and glyph images into immersive, mathematically mapped resonant audio soundscapes.
LYGO FractalWeaver
An AI-native creative engine that translates fractal patterns and recursive visuals into complex, evolving audio textures.
Out of Africa Skill
An advanced Openclaw Skills module that injects deep literary, thematic, and historical context from Isak Dinesen's memoir into your AI agent's operational intelligence.
LLM Hallucination Detector
An advanced AI-powered text auditing tool that detects hallucinations, verifies facts, and calculates trust scores for LLM-generated output.
Airflow DAG Analyzer
An AI-powered diagnostic and optimization tool designed to audit Apache Airflow DAGs for performance bottlenecks, cyclic dependencies, and best-practice compliance.
Featured*
