Database Optimizer
ListedOptimizes Anton Abyzov's databases for speed and efficiency through automated indexing and query tuning.
Install on your platform
database-optimizer. anton-abyzov/specweave has no skill named "database-optimizer" any more. It was renamed, moved or deleted upstream.We check each listing against its upstream repository with the rules the skills CLI uses, last on 2026-10-30. We don't show a command we know will fail.
What we know about this skill
Publisher
anton-abyzov
Taken from the source listing. We haven't verified who controls this account.
Install target
Live repository
Not pinned. Installing fetches whatever the repository holds at the time you run the command.
Automated safety checks
We could not read this skill's source, so none of the checks below were run.
About this skill
What it does
This skill optimizes databases to improve performance and efficiency. It analyzes database schemas, queries, and configurations to identify bottlenecks and suggest improvements. The tool aims to reduce query execution times and overall resource consumption within a database environment.
When to use it
- Slow Query Performance: When specific queries are taking an unexpectedly long time to execute.
- High Resource Consumption: If the database server is consistently experiencing high CPU or memory usage.
- Database Migration/Upgrade: Before and after migrating databases to ensure optimal performance on new infrastructure.
- Regular Maintenance: As part of a proactive strategy for maintaining database health and efficiency.
Key capabilities
- Schema analysis
- Query optimization suggestions
- Configuration tuning recommendations
- Performance bottleneck identification
Example prompts
- "Analyze this SQL query:
SELECT * FROM orders WHERE customer_id = 123and suggest optimizations." - "Identify performance bottlenecks in my PostgreSQL database."
- "Suggest configuration changes to improve the efficiency of my MySQL server."
Tips & gotchas
The skill requires access to the database schema and query logs. Ensure appropriate permissions are granted before running any optimization suggestions, as incorrect modifications can negatively impact data integrity or availability.