搵技能.../

Database Optimization Guru | Skills Pool

技能檔案

Database Optimization Guru

Database expert for query optimization, indexing, schema design, and performance tuning

majiayu000200 星標2026年1月22日

職業
分類: SQL 數據庫

技能內容

Status: ✅ Research complete Last validated: 2025-11-08 Confidence: 🟡 Medium — Research-backed tuning playbook – audit semi-annually

How to use this skill

Start with modules/core-guidance.md to classify workload, risks, and timelines.
Run baselines via modules/workload-profiling.md.
Adjust physical design using modules/indexing-and-schema-design.md.
Tune queries with modules/query-tuning.md.

相關技能

快速安裝

Database Optimization Guru

npx skills add majiayu000/claude-skill-registry

下載 Skill 打開源碼倉庫

作者: majiayu000
星標: 200
更新時間: 2026年1月22日
職業

本頁內容

01How to use this skill

Apply operational practices from modules/operations-and-observability.md.

Track open research or platform-specific follow-ups in modules/known-gaps.md and refresh quarterly with modules/research-checklist.md.

Module overview

Core guidance — triage checklist, workload classification, stakeholder alignment.
Workload profiling — baseline metrics, tooling, sampling approaches.
Indexing & schema design — normalization, partitioning, indexing strategies.
Query tuning — execution plans, rewrite patterns, optimizer hints.
Operations & observability — capacity planning, caching, incident response.
Known gaps — targeted research backlog.
Research checklist — semi-annual refresh workflow.

Research status

Content reflects current PostgreSQL, MySQL, Aurora, and Spanner guidance (2024–2025).
Schedule next validation for 2026-05-01 or sooner if major engine releases occur.
Known gaps highlight distributed SQL deep dives and automated tuning comparisons still pending.

02

Module overview

03Research status

資料庫管理員

Postgres Patterns

PostgreSQL database patterns for query optimization, schema design, indexing, and security. Based on Supabase best practices.

Postgres Patterns

PostgreSQL database patterns for query optimization, schema design, indexing, and security. Quick reference for common patterns, index types, data types, and anti-pattern detection. Based on Supabase best practices.

Database Migrations

Database migration best practices for schema changes, data migrations, rollbacks, and zero-downtime deployments across PostgreSQL, MySQL, and common ORMs (Prisma, Drizzle, Django, TypeORM, golang-migrate). Use when planning or implementing database schema changes.

Postgres Patterns

쿼리 최적화, 스키마 설계, 인덱싱, 보안을 위한 PostgreSQL 데이터베이스 패턴. Supabase 모범 사례 기반.

Postgres Patterns

PostgreSQL database patterns for query optimization, schema design, indexing, and security. Based on Supabase best practices.

Jpa Patterns

Spring Boot中的JPA/Hibernate模式，用于实体设计、关系处理、查询优化、事务管理、审计、索引、分页和连接池。

資料庫管理員