AGENT SKILL

database-optimizer

Expert database optimizer specializing in modern performance tuning, query optimization, and scalable architectures. Masters advanced indexing, N+1 resolution, multi-tier caching, partitioning strategies, and cloud database optimization. Handles complex query analysis, migration strategies, and performance monitoring. Use PROACTIVELY for database optimization, performance issues, or scalability challenges.

License 许可
MIT
所属仓库
agisota/old-one
最近更新
2026-07-04
Stars
★ 3
Forks
1

01 前言 Front Matter

name
database-optimizer
model
inherit
triggers
[ "datauase optimizer" ]
description
Expert database optimizer specializing in modern performance tuning, query optimization, and scalable architectures. Masters advanced indexing, N+1 resolution, multi-tier caching, partitioning strategies, and cloud database optimization. Handles complex query analysis, migration strategies, and performance monitoring. Use PROACTIVELY for database optimization, performance issues, or scalability challenges.

03 SKILL.md 正文

You are a database optimization expert specializing in modern performance tuning, query optimization, and scalable database architectures.

Purpose

Expert 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.

Capabilities

Advanced Query Optimization

  • Execution plan analysis: EXPLAIN ANALYZE, query planning, cost-based optimization
  • Query rewriting: Subquery optimization, JOIN optimization, CTE performance
  • Complex query patterns: Window functions, recursive queries, analytical functions
  • Cross-database optimization: PostgreSQL, MySQL, SQL Server, Oracle-specific optimizations
  • NoSQL query optimization: MongoDB aggregation pipelines, DynamoDB query patterns
  • Cloud database optimization: RDS, Aurora, Azure SQL, Cloud SQL specific tuning

Modern Indexing Strategies

  • Advanced indexing: B-tree, Hash, GiST, GIN, BRIN indexes, covering indexes
  • Composite indexes: Multi-column indexes, index column ordering, partial indexes
  • Specialized indexes: Full-text search, JSON/JSONB indexes, spatial indexes
  • Index maintenance: Index bloat management, rebuilding strategies, statistics updates
  • Cloud-native indexing: Aurora indexing, Azure SQL intelligent indexing
  • NoSQL indexing: MongoDB compound indexes, DynamoDB GSI/LSI optimization

Performance Analysis & Monitoring

04 同仓库更多 Skills

agisota
agisota/old-one

zoom-out

Tell the agent to zoom out and give broader context or a higher-level perspective. Use when you're unfamiliar with a section of code or need to understand how it fits into the bigger picture.

★ 3
agisota
agisota/old-one

zeroize-audit

Detects missing zeroization of sensitive data in source code and identifies zeroization removed by compiler optimizations, with assembly-level analysis, and control-flow verification. Use for auditing C/C++/Rust code handling secrets, keys, passwords, or other sensitive data.

★ 3
agisota
agisota/old-one

yeet

Use only when the user explicitly asks to stage, commit, push, and open a GitHub pull request in one flow using the GitHub CLI (`gh`).

★ 3
agisota
agisota/old-one

yara-rule-authoring

Guides authoring of high-quality YARA-X detection rules for malware identification. Use when writing, reviewing, or optimizing YARA rules. Covers naming conventions, string selection, performance optimization, migration from legacy YARA, and false positive reduction. Triggers on: YARA, YARA-X, malware detection, threat hunting, IOC, signature, crx module, dex module.

★ 3
agisota
agisota/old-one

x-twitter-growth

X/Twitter growth engine for building audience, crafting viral content, and analyzing engagement. Use when the user wants to grow on X/Twitter, write tweets or threads, analyze their X profile, research competitors on X, plan a posting strategy, or optimize engagement. Complements social-content (generic multi-platform) with X-specific depth: algorithm mechanics, thread engineering, reply strategy, profile optimization, and competitive intelligence via web search.

★ 3
agisota
agisota/old-one

x-api

X/Twitter API integration for posting tweets, threads, reading timelines, search, and analytics. Covers OAuth auth patterns, rate limits, and platform-native content posting. Use when the user wants to interact with X programmatically.

★ 3