skills.rest
vekzz-dev
vekzz-devCOMMUNITY
Explore all skills by this author →
GitHub

database-design

Guide relational database schema design, normalization, indexing, and migrations across PostgreSQL, MySQL, MariaDB, and SQLite.

3|Updated Mar 28, 2026
Search Tags:#indexing#database#migrations#schema#sql#normalization#modeling
One-click install
npx skills add https://github.com/vekzz-dev/opencode-skills --skill database-design-vekzz-dev
Or copy as Structured Prompt for Agent▼
Please help me install this Agent Skill.
Skill: database-design
Source: https://github.com/vekzz-dev/opencode-skills/tree/main/database-design
Command: npx skills add https://github.com/vekzz-dev/opencode-skills --skill database-design-vekzz-dev

SYSTEM DOCUMENTATION & REQUIREMENTS

💡 This Skill includes references (resource) components.

What problem does it solve?

This Skill addresses the complexity of designing and maintaining relational database schemas, helping you avoid common pitfalls like poor normalization, inefficient indexing, and unmanageable migration paths.

Core Features & Use Cases

  • Schema Modeling: Provides a structured approach to move from conceptual business entities to physical database implementations.
  • Optimization & Maintenance: Offers best practices for indexing, query performance, and migration versioning to ensure long-term system health.
  • Use Case: When starting a new project or refactoring a legacy system, use this Skill to define naming conventions, select appropriate data types, and establish a reliable migration workflow that prevents production data loss.

Quick Start

Use the database-design skill to review my current schema and suggest improvements for indexing and normalization.

Frequently Asked Questions about database-design

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

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

Designing a scalable database schema involves moving from conceptual entity-relationship mapping to physical implementation. This skill provides structured approaches for normalization, data type selection, and indexing strategies to ensure robust schema modeling and ACID compliance.

What is the best way to normalize a relational database schema?▼

Normalizing a relational database schema organizes tables to reduce redundancy and improve data integrity. This skill offers comprehensive guidance on normalization techniques, helping you move from conceptual business entities to efficient physical database implementations.

Does this database design approach work with PostgreSQL and MySQL?▼

Yes, this database design approach supports dialect-specific best practices across PostgreSQL, MySQL, MariaDB, and SQLite. It ensures your schema modeling, indexing, and migration management align with the specific requirements of each relational database platform.

How do I manage database migrations without losing production data?▼

Managing database migrations safely requires establishing a reliable migration versioning workflow. This skill helps you define naming conventions and migration paths that prevent production data loss during schema refactoring and maintenance.

When do I need to add indexing strategies to my SQL schema?▼

Adding indexing strategies to an SQL schema is needed for query optimization and performance tuning. This skill provides best practices for implementing efficient indexes that support long-term system health and ensure fast data retrieval.

Can this skill help refactor a legacy database schema?▼

Yes, you can use this skill to review and refactor a legacy database schema. It helps identify poor normalization, inefficient indexing, and unmanageable migration paths, then suggests improvements for query performance and reliability.

Related Skills

Explore More Software Engineering Skills→
SSiertsemaSSiertsema

conceptual-data-modeling

Define domain entities, relationships, and business rules in plain language.

Community
Intermediate
microwindmicrowind
65

SQL优化器

Analyze SQL execution plans and provide index optimization suggestions for multiple databases.

Official
Advanced
shynlee04shynlee04

Backend Migrations

Create and apply reversible database schema migrations with zero-downtime deployment strategies.

Community
Intermediate
HouseGarofaloHouseGarofalo
3

database-architect-agent

Guide database architecture, data modeling, schema optimization, and query performance tuning.

Official
Advanced