skills.rest
bennie-ng
bennie-ngCOMMUNITY
Explore all skills by this author →
GitHub

database-engineer

Design database schemas, optimize SQL and NoSQL queries, and manage data migrations.

Updated Aug 23, 2026
Search Tags:#query optimization#SQL#schema design#database#NoSQL#migrations
One-click install
npx skills add https://github.com/bennie-ng/AgCel --skill database-engineer-bennie-ng
Or copy as Structured Prompt for Agent▼
Please help me install this Agent Skill.
Skill: database-engineer
Source: https://github.com/bennie-ng/AgCel/tree/main/skills/database-engineer
Command: npx skills add https://github.com/bennie-ng/AgCel --skill database-engineer-bennie-ng

SYSTEM DOCUMENTATION & REQUIREMENTS

💡 This Skill includes references (resource) components.

What problem does it solve?

This Skill addresses the complexities of designing efficient database schemas, optimizing query performance, and managing the evolution of database structures through migrations.

Core Features & Use Cases

  • Schema Design: Create robust and scalable database schemas for both SQL and NoSQL databases.
  • Query Optimization: Analyze and improve the performance of slow-running database queries.
  • Data Migration: Plan and execute safe and reliable data migrations between different database versions or structures.
  • Use Case: When building a new application, use this Skill to design the initial database schema, ensuring it aligns with the application's data access patterns and can scale with user growth.

Quick Start

Design a PostgreSQL schema for a blog with users, posts, and comments tables.

Frequently Asked Questions about database-engineer

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

FAQPage Schema
How do I design a database schema for a new application?▼

Database schema design structures data into tables or collections aligned with application access patterns, ensuring normalization principles and indexing best practices for a scalable, transactional data foundation.

What is the best way to optimize slow SQL queries?▼

Query optimization analyzes slow-running SQL queries to improve performance by applying indexing best practices and transactional integrity tuning, resulting in faster database response times for application workloads.

How do I manage data migrations between different database versions?▼

Data migration strategies plan and execute safe structural transitions between database versions, maintaining transactional integrity to reliably evolve database structures without data loss during application development.

Does this database design approach work for NoSQL databases?▼

Schema design and query optimization apply to both SQL and NoSQL databases, structuring data collections and improving query performance based on specific data access patterns and scalability requirements.

When do I need to apply normalization principles during schema design?▼

Normalization principles are required during database schema design to reduce data redundancy and maintain transactional integrity when structuring relational data for application development or data warehousing.

Related Skills

Explore More Software Engineering Skills→
TorbenMerraldTorbenMerrald
1

Backend Models

Define and enforce database models and entity schemas across ORM and migration scripts.

Community
Advanced
scanadyscanady

tech-database-optimizer

Analyze PostgreSQL and MySQL EXPLAIN ANALYZE outputs to diagnose database bottlenecks.

Community
Advanced
jeremylongshorejeremylongshore
2.6k

generating-orm-code

Generate ORM models and database schemas across multiple frameworks.

Community
Intermediate
ZpankzZpankz
7

data-schema-knowledge-modeling

Design data schemas and knowledge models for relational, document, and graph domains.

Community
Advanced