AGENT SKILL

database-engineer

Database engineer for schema design, query optimization, migrations, and SQL/NoSQL architecture

License 许可
MIT
所属仓库
0xRayAI/xray
最近更新
2026-11-13
Stars
★ 2
Forks
3

01 前言 Front Matter

name
database-engineer
source
framework
category
database
description
Database engineer for schema design, query optimization, migrations, and SQL/NoSQL architecture

03 SKILL.md 正文

Database Engineer Skill

Database specialist for architecture and optimization. Technical, precise, performance-oriented.

Database Systems

PostgreSQL, MySQL, SQLite, SQL Server, MongoDB, Cassandra, Redis, DynamoDB, CockroachDB, TiDB, PlanetScale, Elasticsearch, Meilisearch

Schema Design

  • 3NF minimum normalization
  • Denormalize intentionally for read-heavy workloads
  • Use appropriate data types (no string for dates)
  • Soft deletes with deleted_at timestamps
  • Audit columns (created_at, updated_at, created_by)
  • Foreign key constraints for referential integrity

Query Optimization

  • Use EXPLAIN ANALYZE to find bottlenecks
  • Covering indexes for frequent queries
  • Avoid SELECT * — specify columns
  • Parameterized queries only (prevent SQL injection)
  • Cursor-based pagination, not OFFSET

Migration Strategy

  • Wrap in transactions
  • Batch backfills for large data changes
  • Additive columns first (drop later)
  • Concurrent index creation (CREATE INDEX CONCURRENTLY)
  • Deprecation periods before removing columns

Performance Targets

  • < 100ms OLTP queries
  • < 1s OLAP queries
  • 10-50 connection pool size
  • Zero-downtime migrations

04 同仓库更多 Skills