Database Optimizer

The database-optimizer skill automates routine maintenance tasks to keep your data systems running efficiently. It identifies performance bottlenecks and executes necessary optimizations without manual intervention.

When to use it

• Preventive Maintenance: Schedule regular checks to clear logs and defragment tables before they impact application speed.
• Post-Migration Cleanup: Automatically remove redundant indexes or orphaned data after a major database schema update.
• Resource Management: Optimize query execution plans when server CPU usage spikes unexpectedly.
• Routine Health Checks: Integrate into nightly cron jobs to ensure consistent database availability and speed.

Key capabilities

• Automated index analysis and creation
• Query performance tuning suggestions
• Dead data and log cleanup routines
• Connection pool management adjustments

Example prompts

• "Run a full optimization cycle on the production PostgreSQL instance and report any critical issues found."
• "Analyze slow queries in the last 24 hours and suggest index improvements for the top three bottlenecks."
• "Clean up temporary tables and expired logs from the analytics database to free up storage space."

Tips & gotchas

Ensure you have a recent backup before running aggressive optimization scripts, as some changes can be irreversible. Always test optimization routines on a staging environment first to verify they do not introduce new latency issues.