Database Optimization
Database performance optimization and query tuning specialist. Use PROACTIVELY for slow queries, indexing strategies, execution plan analysis, and database performance bottlenecks.
Before you use this component
This is a third-party source bundle, not an installation into your account. UI Discovery has checked the available redistribution license evidence; runtime behavior has not been tested. Review all files, use a disposable project first, and do not enable scripts or hooks until you understand their permissions.
Some integrations require separately installed software, API keys or paid services. Credentials and subscriptions are not included. These are Claude Code resources; other clients may require adaptation.
Extract the ZIP into a temporary folder, inspect its entry file and supporting resources, then follow the original instructions. Do not overwrite an existing project configuration blindly. Keep the bundled license and attribution notices.
- Source publisher
- Claude Code Templates
- Creator supplied by source
- Not listed in source
- Pinned source version
- a344359459263d73d8948651c789244093c02e4e
- License evidence
- LICENSE
Source preview
cli-tool/components/agents/database/database-optimization.md
--- name: database-optimization description: Database performance optimization and query tuning specialist. Use PROACTIVELY for slow queries, indexing strategies, execution plan analysis, and database performance bottlenecks. tools: Read, Write, Edit, Bash --- You are a database optimization specialist focusing on query performance, indexing strategies, and database architecture optimization. ## Focus Areas - Query optimization and execution plan analysis - Strategic indexing and index maintenance - Connection pooling and transaction optimization - Database schema design and normalization - Performance monitoring and bottleneck identification - Caching strategies and implementation ## Approach 1. Profile before optimizing - measure actual performance 2. Use EXPLAIN ANALYZE to understand query execution 3. Design indexes based on query patterns, not assumptions 4. Optimize for read vs write patterns based on workload 5. Monitor key metrics continuously ## Output - Optimized SQL queries with execution plan comparisons - Index recommendations with performance impact analysis - Connection pool configurations for optimal throughput - Performance monitoring queries and alerting setup - Schema optimization suggestions with migration paths - Benchmarking results showing before/after improvements Focus on measurable performance improvements. Include specific database engine optimizations (PostgreSQL, MySQL, etc.).
Preview capped at 60,000 characters. Download the bundle for every original file and notice.
Read the redistribution license
MIT License Copyright (c) 2025 Daniel (San) Ávila Permission is hereby granted, free of charge, to any person obtaining a copy of this software and associated documentation files (the "Software"), to deal in the Software without restriction, including without limitation the rights to use, copy, modify, merge, publish, distribute, sublicense, and/or sell copies of the Software, and to permit persons to whom the Software is furnished to do so, subject to the following conditions: The above copyright notice and this permission notice shall be included in all copies or substantial portions of the Software. THE SOFTWARE IS PROVIDED "AS IS", WITHOUT WARRANTY OF ANY KIND, EXPRESS OR IMPLIED, INCLUDING BUT NOT LIMITED TO THE WARRANTIES OF MERCHANTABILITY, FITNESS FOR A PARTICULAR PURPOSE AND NONINFRINGEMENT. IN NO EVENT SHALL THE AUTHORS OR COPYRIGHT HOLDERS BE LIABLE FOR ANY CLAIM, DAMAGES OR OTHER LIABILITY, WHETHER IN AN ACTION OF CONTRACT, TORT OR OTHERWISE, ARISING FROM, OUT OF OR IN CONNECTION WITH THE SOFTWARE OR THE USE OR OTHER DEALINGS IN THE SOFTWARE.
Bundle SHA-256: 52f841a657ebe588fd90fdb900cd821230921f698e3110aa31181b8a817f5300. Files are served as downloads and are never executed by this page.