{"id":"f9a3a847-6979-446c-9cc9-7de9b2ef5910","shortId":"YphSpA","kind":"skill","title":"database-optimizer","tagline":"Expert database optimizer specializing in modern performance tuning, query optimization, and scalable architectures.","description":"## Use this skill when\n\n- Working on database optimizer tasks or workflows\n- Needing guidance, best practices, or checklists for database optimizer\n\n## Do not use this skill when\n\n- The task is unrelated to database optimizer\n- You need a different domain or tool outside this scope\n\n## Instructions\n\n- Clarify goals, constraints, and required inputs.\n- Apply relevant best practices and validate outcomes.\n- Provide actionable steps and verification.\n- If detailed examples are required, open `resources/implementation-playbook.md`.\n\nYou are a database optimization expert specializing in modern performance tuning, query optimization, and scalable database architectures.\n\n## Purpose\nExpert database optimizer with comprehensive knowledge of modern database performance tuning, query optimization, and scalable architecture design. Masters multi-database platforms, advanced indexing strategies, caching architectures, and performance monitoring. Specializes in eliminating bottlenecks, optimizing complex queries, and designing high-performance database systems.\n\n## Capabilities\n\n### Advanced Query Optimization\n- **Execution plan analysis**: EXPLAIN ANALYZE, query planning, cost-based optimization\n- **Query rewriting**: Subquery optimization, JOIN optimization, CTE performance\n- **Complex query patterns**: Window functions, recursive queries, analytical functions\n- **Cross-database optimization**: PostgreSQL, MySQL, SQL Server, Oracle-specific optimizations\n- **NoSQL query optimization**: MongoDB aggregation pipelines, DynamoDB query patterns\n- **Cloud database optimization**: RDS, Aurora, Azure SQL, Cloud SQL specific tuning\n\n### Modern Indexing Strategies\n- **Advanced indexing**: B-tree, Hash, GiST, GIN, BRIN indexes, covering indexes\n- **Composite indexes**: Multi-column indexes, index column ordering, partial indexes\n- **Specialized indexes**: Full-text search, JSON/JSONB indexes, spatial indexes\n- **Index maintenance**: Index bloat management, rebuilding strategies, statistics updates\n- **Cloud-native indexing**: Aurora indexing, Azure SQL intelligent indexing\n- **NoSQL indexing**: MongoDB compound indexes, DynamoDB GSI/LSI optimization\n\n### Performance Analysis & Monitoring\n- **Query performance**: pg_stat_statements, MySQL Performance Schema, SQL Server DMVs\n- **Real-time monitoring**: Active query analysis, blocking query detection\n- **Performance baselines**: Historical performance tracking, regression detection\n- **APM integration**: DataDog, New Relic, Application Insights database monitoring\n- **Custom metrics**: Database-specific KPIs, SLA monitoring, performance dashboards\n- **Automated analysis**: Performance regression detection, optimization recommendations\n\n### N+1 Query Resolution\n- **Detection techniques**: ORM query analysis, application profiling, query pattern analysis\n- **Resolution strategies**: Eager loading, batch queries, JOIN optimization\n- **ORM optimization**: Django ORM, SQLAlchemy, Entity Framework, ActiveRecord optimization\n- **GraphQL N+1**: DataLoader patterns, query batching, field-level caching\n- **Microservices patterns**: Database-per-service, event sourcing, CQRS optimization\n\n### Advanced Caching Architectures\n- **Multi-tier caching**: L1 (application), L2 (Redis/Memcached), L3 (database buffer pool)\n- **Cache strategies**: Write-through, write-behind, cache-aside, refresh-ahead\n- **Distributed caching**: Redis Cluster, Memcached scaling, cloud cache services\n- **Application-level caching**: Query result caching, object caching, session caching\n- **Cache invalidation**: TTL strategies, event-driven invalidation, cache warming\n- **CDN integration**: Static content caching, API response caching, edge caching\n\n### Database Scaling & Partitioning\n- **Horizontal partitioning**: Table partitioning, range/hash/list partitioning\n- **Vertical partitioning**: Column store optimization, data archiving strategies\n- **Sharding strategies**: Application-level sharding, database sharding, shard key design\n- **Read scaling**: Read replicas, load balancing, eventual consistency management\n- **Write scaling**: Write optimization, batch processing, asynchronous writes\n- **Cloud scaling**: Auto-scaling databases, serverless databases, elastic pools\n\n### Schema Design & Migration\n- **Schema optimization**: Normalization vs denormalization, data modeling best practices\n- **Migration strategies**: Zero-downtime migrations, large table migrations, rollback procedures\n- **Version control**: Database schema versioning, change management, CI/CD integration\n- **Data type optimization**: Storage efficiency, performance implications, cloud-specific types\n- **Constraint optimization**: Foreign keys, check constraints, unique constraints performance\n\n### Modern Database Technologies\n- **NewSQL databases**: CockroachDB, TiDB, Google Spanner optimization\n- **Time-series optimization**: InfluxDB, TimescaleDB, time-series query patterns\n- **Graph database optimization**: Neo4j, Amazon Neptune, graph query optimization\n- **Search optimization**: Elasticsearch, OpenSearch, full-text search performance\n- **Columnar databases**: ClickHouse, Amazon Redshift, analytical query optimization\n\n### Cloud Database Optimization\n- **AWS optimization**: RDS performance insights, Aurora optimization, DynamoDB optimization\n- **Azure optimization**: SQL Database intelligent performance, Cosmos DB optimization\n- **GCP optimization**: Cloud SQL insights, BigQuery optimization, Firestore optimization\n- **Serverless databases**: Aurora Serverless, Azure SQL Serverless optimization patterns\n- **Multi-cloud patterns**: Cross-cloud replication optimization, data consistency\n\n### Application Integration\n- **ORM optimization**: Query analysis, lazy loading strategies, connection pooling\n- **Connection management**: Pool sizing, connection lifecycle, timeout optimization\n- **Transaction optimization**: Isolation levels, deadlock prevention, long-running transactions\n- **Batch processing**: Bulk operations, ETL optimization, data pipeline performance\n- **Real-time processing**: Streaming data optimization, event-driven architectures\n\n### Performance Testing & Benchmarking\n- **Load testing**: Database load simulation, concurrent user testing, stress testing\n- **Benchmark tools**: pgbench, sysbench, HammerDB, cloud-specific benchmarking\n- **Performance regression testing**: Automated performance testing, CI/CD integration\n- **Capacity planning**: Resource utilization forecasting, scaling recommendations\n- **A/B testing**: Query optimization validation, performance comparison\n\n### Cost Optimization\n- **Resource optimization**: CPU, memory, I/O optimization for cost efficiency\n- **Storage optimization**: Storage tiering, compression, archival strategies\n- **Cloud cost optimization**: Reserved capacity, spot instances, serverless patterns\n- **Query cost analysis**: Expensive query identification, resource usage optimization\n- **Multi-cloud cost**: Cross-cloud cost comparison, workload placement optimization\n\n## Behavioral Traits\n- Measures performance first using appropriate profiling tools before making optimizations\n- Designs indexes strategically based on query patterns rather than indexing every column\n- Considers denormalization when justified by read patterns and performance requirements\n- Implements comprehensive caching for expensive computations and frequently accessed data\n- Monitors slow query logs and performance metrics continuously for proactive optimization\n- Values empirical evidence and benchmarking over theoretical optimizations\n- Considers the entire system architecture when optimizing database performance\n- Balances performance, maintainability, and cost in optimization decisions\n- Plans for scalability and future growth in optimization strategies\n- Documents optimization decisions with clear rationale and performance impact\n\n## Knowledge Base\n- Database internals and query execution engines\n- Modern database technologies and their optimization characteristics\n- Caching strategies and distributed system performance patterns\n- Cloud database services and their specific optimization opportunities\n- Application-database integration patterns and optimization techniques\n- Performance monitoring tools and methodologies\n- Scalability patterns and architectural trade-offs\n- Cost optimization strategies for database workloads\n\n## Response Approach\n1. **Analyze current performance** using appropriate profiling and monitoring tools\n2. **Identify bottlenecks** through systematic analysis of queries, indexes, and resources\n3. **Design optimization strategy** considering both immediate and long-term performance goals\n4. **Implement optimizations** with careful testing and performance validation\n5. **Set up monitoring** for continuous performance tracking and regression detection\n6. **Plan for scalability** with appropriate caching and scaling strategies\n7. **Document optimizations** with clear rationale and performance impact metrics\n8. **Validate improvements** through comprehensive benchmarking and testing\n9. **Consider cost implications** of optimization strategies and resource utilization\n\n## Example Interactions\n- \"Analyze and optimize complex analytical query with multiple JOINs and aggregations\"\n- \"Design comprehensive indexing strategy for high-traffic e-commerce application\"\n- \"Eliminate N+1 queries in GraphQL API with efficient data loading patterns\"\n- \"Implement multi-tier caching architecture with Redis and application-level caching\"\n- \"Optimize database performance for microservices architecture with event sourcing\"\n- \"Design zero-downtime database migration strategy for large production table\"\n- \"Create performance monitoring and alerting system for database optimization\"\n- \"Implement database sharding strategy for horizontally scaling write-heavy workload\"\n\n## Limitations\n- Use this skill only when the task clearly matches the scope described above.\n- Do not treat the output as a substitute for environment-specific validation, testing, or expert review.\n- Stop and ask for clarification if required inputs, permissions, safety boundaries, or success criteria are missing.","tags":["database","optimizer","antigravity","awesome","skills","sickn33","agent-skills","agentic-skills","ai-agent-skills","ai-agents","ai-coding","ai-workflows"],"capabilities":["skill","source-sickn33","skill-database-optimizer","topic-agent-skills","topic-agentic-skills","topic-ai-agent-skills","topic-ai-agents","topic-ai-coding","topic-ai-workflows","topic-antigravity","topic-antigravity-skills","topic-claude-code","topic-claude-code-skills","topic-codex-cli","topic-codex-skills"],"categories":["antigravity-awesome-skills"],"synonyms":[],"warnings":[],"endpointUrl":"https://skills.sh/sickn33/antigravity-awesome-skills/database-optimizer","protocol":"skill","transport":"skills-sh","auth":{"type":"none","details":{"cli":"npx skills add sickn33/antigravity-awesome-skills","source_repo":"https://github.com/sickn33/antigravity-awesome-skills","install_from":"skills.sh"}},"qualityScore":"0.700","qualityRationale":"deterministic score 0.70 from registry signals: · indexed on github topic:agent-skills · 34831 github stars · SKILL.md body (10,143 chars)","verified":false,"liveness":"unknown","lastLivenessCheck":null,"agentReviews":{"count":0,"score_avg":null,"cost_usd_avg":null,"success_rate":null,"latency_p50_ms":null,"narrative_summary":null,"summary_updated_at":null},"enrichmentModel":"deterministic:skill-github:v1","enrichmentVersion":1,"enrichedAt":"2026-04-24T06:51:01.389Z","embedding":null,"createdAt":"2026-04-18T21:35:42.241Z","updatedAt":"2026-04-24T06:51:01.389Z","lastSeenAt":"2026-04-24T06:51:01.389Z","tsv":"'+1':333,365,1073 '1':954 '2':964 '3':975 '4':988 '5':997 '6':1008 '7':1018 '8':1028 '9':1036 'a/b':743 'access':840 'action':75 'activ':293 'activerecord':361 'advanc':126,149,215,384 'aggreg':196,1058 'ahead':412 'alert':1120 'amazon':585,602 'analysi':154,276,295,326,340,345,662,779,969 'analyt':178,604,1052 'analyz':156,955,1048 'api':448,1077 'apm':306 'appli':67 'applic':311,341,392,423,473,657,927,1070,1093 'application-databas':926 'application-level':422,472,1092 'approach':953 'appropri':804,959,1013 'architectur':16,102,119,130,386,705,865,942,1088,1101 'archiv':468,766 'asid':409 'ask':1169 'asynchron':496 'aurora':205,261,615,639 'auto':501 'auto-sc':500 'autom':325,731 'aw':610 'azur':206,263,619,641 'b':218 'b-tree':217 'balanc':486,870 'base':161,813,897 'baselin':300 'batch':350,369,494,686 'behavior':798 'behind':406 'benchmark':708,719,727,857,1033 'best':30,69,518 'bigqueri':633 'bloat':251 'block':296 'bottleneck':137,966 'boundari':1177 'brin':223 'buffer':397 'bulk':688 'cach':129,373,385,390,399,408,414,420,425,428,430,432,433,441,447,450,452,834,911,1014,1087,1095 'cache-asid':407 'capabl':148 'capac':736,772 'care':992 'cdn':443 'chang':536 'characterist':910 'check':555 'checklist':33 'ci/cd':538,734 'clarif':1171 'clarifi':61 'clear':891,1022,1144 'clickhous':601 'cloud':201,208,258,419,498,548,607,630,648,652,725,768,788,792,918 'cloud-nat':257 'cloud-specif':547,724 'cluster':416 'cockroachdb':565 'column':231,234,464,821 'columnar':599 'commerc':1069 'comparison':749,794 'complex':139,171,1051 'composit':227 'compound':270 'comprehens':108,833,1032,1060 'compress':765 'comput':837 'concurr':714 'connect':666,668,672 'consid':822,861,979,1037 'consist':488,656 'constraint':63,551,556,558 'content':446 'continu':849,1002 'control':532 'cosmos':625 'cost':160,750,759,769,778,789,793,874,946,1038 'cost-bas':159 'cover':225 'cpu':754 'cqrs':382 'creat':1116 'criteria':1180 'cross':181,651,791 'cross-cloud':650,790 'cross-databas':180 'cte':169 'current':956 'custom':315 'dashboard':324 'data':467,516,540,655,692,700,841,1080 'databas':2,5,23,35,48,89,101,105,112,124,146,182,202,313,318,377,396,453,476,503,505,533,561,564,582,600,608,622,638,711,868,898,905,919,928,950,1097,1109,1123,1126 'database-optim':1 'database-per-servic':376 'database-specif':317 'datadog':308 'dataload':366 'db':626 'deadlock':680 'decis':877,889 'denorm':515,823 'describ':1148 'design':120,142,480,509,810,976,1059,1105 'detail':80 'detect':298,305,329,336,1007 'differ':53 'distribut':413,914 'django':356 'dmvs':288 'document':887,1019 'domain':54 'downtim':524,1108 'driven':439,704 'dynamodb':198,272,617 'e':1068 'e-commerc':1067 'eager':348 'edg':451 'effici':544,760,1079 'elast':506 'elasticsearch':592 'elimin':136,1071 'empir':854 'engin':903 'entir':863 'entiti':359 'environ':1160 'environment-specif':1159 'etl':690 'event':380,438,703,1103 'event-driven':437,702 'eventu':487 'everi':820 'evid':855 'exampl':81,1046 'execut':152,902 'expens':780,836 'expert':4,91,104,1165 'explain':155 'field':371 'field-level':370 'firestor':635 'first':802 'forecast':740 'foreign':553 'framework':360 'frequent':839 'full':241,595 'full-text':240,594 'function':175,179 'futur':882 'gcp':628 'gin':222 'gist':221 'goal':62,987 'googl':567 'graph':581,587 'graphql':363,1076 'growth':883 'gsi/lsi':273 'guidanc':29 'hammerdb':723 'hash':220 'heavi':1134 'high':144,1065 'high-perform':143 'high-traff':1064 'histor':301 'horizont':456,1130 'i/o':756 'identif':782 'identifi':965 'immedi':981 'impact':895,1026 'implement':832,989,1083,1125 'implic':546,1039 'improv':1030 'index':127,213,216,224,226,228,232,233,237,239,245,247,248,250,260,262,266,268,271,811,819,972,1061 'influxdb':574 'input':66,1174 'insight':312,614,632 'instanc':774 'instruct':60 'integr':307,444,539,658,735,929 'intellig':265,623 'interact':1047 'intern':899 'invalid':434,440 'isol':678 'join':167,352,1056 'json/jsonb':244 'justifi':825 'key':479,554 'knowledg':109,896 'kpis':320 'l1':391 'l2':393 'l3':395 'larg':526,1113 'lazi':663 'level':372,424,474,679,1094 'lifecycl':673 'limit':1136 'load':349,485,664,709,712,1081 'log':845 'long':683,984 'long-run':682 'long-term':983 'maintain':872 'mainten':249 'make':808 'manag':252,489,537,669 'master':121 'match':1145 'measur':800 'memcach':417 'memori':755 'methodolog':938 'metric':316,848,1027 'microservic':374,1100 'migrat':510,520,525,528,1110 'miss':1182 'model':517 'modern':9,94,111,212,560,904 'mongodb':195,269 'monitor':133,277,292,314,322,842,935,962,1000,1118 'multi':123,230,388,647,787,1085 'multi-cloud':646,786 'multi-column':229 'multi-databas':122 'multi-ti':387,1084 'multipl':1055 'mysql':185,283 'n':332,364,1072 'nativ':259 'need':28,51 'neo4j':584 'neptun':586 'new':309 'newsql':563 'normal':513 'nosql':192,267 'object':429 'off':945 'open':84 'opensearch':593 'oper':689 'opportun':925 'optim':3,6,13,24,36,49,90,98,106,116,138,151,162,166,168,183,191,194,203,274,330,353,355,362,383,466,493,512,542,552,569,573,583,589,591,606,609,611,616,618,620,627,629,634,636,644,654,660,675,677,691,701,746,751,753,757,762,770,785,797,809,852,860,867,876,885,888,909,924,932,947,977,990,1020,1041,1050,1096,1124 'oracl':189 'oracle-specif':188 'order':235 'orm':338,354,357,659 'outcom':73 'output':1154 'outsid':57 'partial':236 'partit':455,457,459,461,463 'pattern':173,200,344,367,375,580,645,649,776,816,828,917,930,940,1082 'per':378 'perform':10,95,113,132,145,170,275,279,284,299,302,323,327,545,559,598,613,624,694,706,728,732,748,801,830,847,869,871,894,916,934,957,986,995,1003,1025,1098,1117 'permiss':1175 'pg':280 'pgbench':721 'pipelin':197,693 'placement':796 'plan':153,158,737,878,1009 'platform':125 'pool':398,507,667,670 'postgresql':184 'practic':31,70,519 'prevent':681 'proactiv':851 'procedur':530 'process':495,687,698 'product':1114 'profil':342,805,960 'provid':74 'purpos':103 'queri':12,97,115,140,150,157,163,172,177,193,199,278,294,297,334,339,343,351,368,426,579,588,605,661,745,777,781,815,844,901,971,1053,1074 'range/hash/list':460 'rather':817 'rational':892,1023 'rds':204,612 'read':481,483,827 'real':290,696 'real-tim':289,695 'rebuild':253 'recommend':331,742 'recurs':176 'redi':415,1090 'redis/memcached':394 'redshift':603 'refresh':411 'refresh-ahead':410 'regress':304,328,729,1006 'relev':68 'relic':310 'replic':653 'replica':484 'requir':65,83,831,1173 'reserv':771 'resolut':335,346 'resourc':738,752,783,974,1044 'resources/implementation-playbook.md':85 'respons':449,952 'result':427 'review':1166 'rewrit':164 'rollback':529 'run':684 'safeti':1176 'scalabl':15,100,118,880,939,1011 'scale':418,454,482,491,499,502,741,1016,1131 'schema':285,508,511,534 'scope':59,1147 'search':243,590,597 'seri':572,578 'server':187,287 'serverless':504,637,640,643,775 'servic':379,421,920 'session':431 'set':998 'shard':470,475,477,478,1127 'simul':713 'size':671 'skill':19,41,1139 'skill-database-optimizer' 'sla':321 'slow':843 'sourc':381,1104 'source-sickn33' 'spanner':568 'spatial':246 'special':7,92,134,238 'specif':190,210,319,549,726,923,1161 'spot':773 'sql':186,207,209,264,286,621,631,642 'sqlalchemi':358 'stat':281 'statement':282 'static':445 'statist':255 'step':76 'stop':1167 'storag':543,761,763 'store':465 'strateg':812 'strategi':128,214,254,347,400,436,469,471,521,665,767,886,912,948,978,1017,1042,1062,1111,1128 'stream':699 'stress':717 'subqueri':165 'substitut':1157 'success':1179 'sysbench':722 'system':147,864,915,1121 'systemat':968 'tabl':458,527,1115 'task':25,44,1143 'techniqu':337,933 'technolog':562,906 'term':985 'test':707,710,716,718,730,733,744,993,1035,1163 'text':242,596 'theoret':859 'tidb':566 'tier':389,764,1086 'time':291,571,577,697 'time-seri':570,576 'timeout':674 'timescaledb':575 'tool':56,720,806,936,963 'topic-agent-skills' 'topic-agentic-skills' 'topic-ai-agent-skills' 'topic-ai-agents' 'topic-ai-coding' 'topic-ai-workflows' 'topic-antigravity' 'topic-antigravity-skills' 'topic-claude-code' 'topic-claude-code-skills' 'topic-codex-cli' 'topic-codex-skills' 'track':303,1004 'trade':944 'trade-off':943 'traffic':1066 'trait':799 'transact':676,685 'treat':1152 'tree':219 'ttl':435 'tune':11,96,114,211 'type':541,550 'uniqu':557 'unrel':46 'updat':256 'usag':784 'use':17,39,803,958,1137 'user':715 'util':739,1045 'valid':72,747,996,1029,1162 'valu':853 'verif':78 'version':531,535 'vertic':462 'vs':514 'warm':442 'window':174 'work':21 'workflow':27 'workload':795,951,1135 'write':402,405,490,492,497,1133 'write-behind':404 'write-heavi':1132 'write-through':401 'zero':523,1107 'zero-downtim':522,1106","prices":[{"id":"f8be0d2e-3133-43ca-a42b-dc6e712815f3","listingId":"f9a3a847-6979-446c-9cc9-7de9b2ef5910","amountUsd":"0","unit":"free","nativeCurrency":null,"nativeAmount":null,"chain":null,"payTo":null,"paymentMethod":"skill-free","isPrimary":true,"details":{"org":"sickn33","category":"antigravity-awesome-skills","install_from":"skills.sh"},"createdAt":"2026-04-18T21:35:42.241Z"}],"sources":[{"listingId":"f9a3a847-6979-446c-9cc9-7de9b2ef5910","source":"github","sourceId":"sickn33/antigravity-awesome-skills/database-optimizer","sourceUrl":"https://github.com/sickn33/antigravity-awesome-skills/tree/main/skills/database-optimizer","isPrimary":false,"firstSeenAt":"2026-04-18T21:35:42.241Z","lastSeenAt":"2026-04-24T06:51:01.389Z"}],"details":{"listingId":"f9a3a847-6979-446c-9cc9-7de9b2ef5910","quickStartSnippet":null,"exampleRequest":null,"exampleResponse":null,"schema":null,"openapiUrl":null,"agentsTxtUrl":null,"citations":[],"useCases":[],"bestFor":[],"notFor":[],"kindDetails":{"org":"sickn33","slug":"database-optimizer","github":{"repo":"sickn33/antigravity-awesome-skills","stars":34831,"topics":["agent-skills","agentic-skills","ai-agent-skills","ai-agents","ai-coding","ai-workflows","antigravity","antigravity-skills","claude-code","claude-code-skills","codex-cli","codex-skills","cursor","cursor-skills","developer-tools","gemini-cli","gemini-skills","kiro","mcp","skill-library"],"license":"mit","html_url":"https://github.com/sickn33/antigravity-awesome-skills","pushed_at":"2026-04-24T06:41:17Z","description":"Installable GitHub library of 1,400+ agentic skills for Claude Code, Cursor, Codex CLI, Gemini CLI, Antigravity, and more. Includes installer CLI, bundles, workflows, and official/community skill collections.","skill_md_sha":"e283f5132611f931d9150ce3d6788fdb9e709d94","skill_md_path":"skills/database-optimizer/SKILL.md","default_branch":"main","skill_tree_url":"https://github.com/sickn33/antigravity-awesome-skills/tree/main/skills/database-optimizer"},"layout":"multi","source":"github","category":"antigravity-awesome-skills","frontmatter":{"name":"database-optimizer","description":"Expert database optimizer specializing in modern performance tuning, query optimization, and scalable architectures."},"skills_sh_url":"https://skills.sh/sickn33/antigravity-awesome-skills/database-optimizer"},"updatedAt":"2026-04-24T06:51:01.389Z"}}