skills.rest
0xRayAI
0xRayAIOFFICIAL
Explore all skills by this author →
GitHub

database-engineer

Design normalized schemas, optimize queries, and manage zero-downtime migrations for SQL and NoSQL systems.

Updated Jun 5, 2026
Search Tags:#architecture#database#optimization#schema#migration#sql
One-click install
npx skills add https://github.com/0xRayAI/xray --skill database-engineer-0xrayai
Or copy as Structured Prompt for Agent▼
Please help me install this Agent Skill.
Skill: database-engineer
Source: https://github.com/0xRayAI/xray/tree/main/src/skills/database-engineer
Command: npx skills add https://github.com/0xRayAI/xray --skill database-engineer-0xrayai

SYSTEM DOCUMENTATION & REQUIREMENTS

What problem does it solve?

This skill addresses the complexity of managing database performance, schema integrity, and migration safety, preventing common bottlenecks and data corruption issues.

Core Features & Use Cases

  • Schema Design: Enforces 3NF normalization, proper data typing, and referential integrity for robust data modeling.
  • Query Optimization: Identifies performance bottlenecks using EXPLAIN ANALYZE and implements covering indexes to ensure sub-100ms OLTP response times.
  • Safe Migrations: Manages zero-downtime schema changes through transactional batching and additive-first deployment strategies.

Quick Start

Ask the database engineer to analyze the current schema for potential performance bottlenecks and suggest an optimized indexing strategy.

Frequently Asked Questions about database-engineer

High-intent search queries and answers about installing and using this skill.

FAQPage Schema
How do I optimize slow SQL queries to achieve sub-100ms response times?▼

Query optimization involves identifying bottlenecks using EXPLAIN ANALYZE and implementing covering indexes. This approach ensures sub-100ms OLTP response times by rigorously adhering to indexing best practices and analyzing execution plans for high-performance data operations.

What is the best way to manage zero-downtime database schema migrations?▼

Zero-downtime schema migrations are managed through transactional batching and additive-first deployment strategies. This approach prevents data corruption and common bottlenecks by ensuring migration safety and maintaining schema integrity during complex deployments.

Can I use this approach for both SQL and NoSQL database architecture?▼

Yes, this approach supports expert-level database architecture for both SQL and NoSQL systems. It handles complex tasks including schema normalization, performance tuning, and high-performance data operations across diverse database platforms.

How do I design a database schema that enforces 3NF normalization and referential integrity?▼

Schema design enforces 3NF normalization, proper data typing, and referential integrity for robust data modeling. This process addresses the complexity of managing schema integrity and prevents common data corruption issues through strict architectural standards.

Why does my database experience performance bottlenecks during high-volume transactions?▼

Performance bottlenecks often occur due to missing covering indexes or unoptimized query execution plans. Identifying these issues requires analyzing transactional safety standards and applying indexing best practices to ensure high-performance data operations under load.

Related Skills

Explore More Software Engineering Skills→
summarybotngsummarybotng
2

database-testing

Automate validation of database schemas, data integrity, and migration scripts.

Official
Advanced
mbadozmbadoz
2

database-migrations

Plan zero-downtime database migrations across PostgreSQL, MySQL, and ORMs.

Community
Advanced
junaid-ali-rukjunaid-ali-ruk

prisma-expert

Diagnose and optimize Prisma ORM schemas, migrations, and queries.

Community
Advanced
wangx7wangx7

cloud-sql-basics

Provision and administer Cloud SQL instances for MySQL, PostgreSQL, and SQL Server.

Community
Intermediate