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
xray-orchestrator
Main orchestration skill for xray agents. Provides commands to coordinate agent work and invoke xray APIs through the local HTTP API server.
ui-ux-design
User interface and user experience design with mobile-first approach, cognitive simplicity, and accessibility-first principles
testing-strategy
Design comprehensive testing strategies and optimize test coverage
testing-best-practices
Testing best practices and quality assurance
tech-writer
Documentation writer for API docs, READMEs, ADRs, changelogs, and developer experience
strategist
Strategic guidance and complex problem-solving with architectural decision-making and risk analysis