skills.rest
bingo2gether
bingo2getherCOMMUNITY
Explore all skills by this author →
GitHub

database-design

Guide PostgreSQL and MySQL schema design, indexing, and migrations.

Updated Aug 23, 2026
Search Tags:#schema design#database#postgresql#optimization#migration#sql
One-click install
npx skills add https://github.com/bingo2gether/BingotwoGether --skill database-design-bingo2gether
Or copy as Structured Prompt for Agent▼
Please help me install this Agent Skill.
Skill: database-design
Source: https://github.com/bingo2gether/BingotwoGether/tree/main/.agent/skills/database-design
Command: npx skills add https://github.com/bingo2gether/BingotwoGether --skill database-design-bingo2gether

SYSTEM DOCUMENTATION & REQUIREMENTS

💡 This Skill includes references (resource) components.

What problem does it solve?

This Skill helps you design robust database schemas, optimize query performance, and manage database migrations effectively across various database systems.

Core Features & Use Cases

  • Schema Design: Provides guidelines for normalization, denormalization, and constraint implementation.
  • Index Optimization: Offers strategies for creating and analyzing indexes to speed up data retrieval.
  • Migration Management: Outlines patterns for safe and zero-downtime database migrations.
  • Query Tuning: Assists in analyzing query execution plans and applying common optimization techniques.
  • Use Case: You need to design a new PostgreSQL schema for an e-commerce platform, ensuring efficient querying for product searches and order processing.

Quick Start

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

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 database schema for a new application in PostgreSQL?▼

Database schema design in PostgreSQL involves guidelines for normalization, denormalization, and constraint implementation. This Skill helps structure data efficiently, ensuring robust querying for use cases like e-commerce product searches and order processing.

What's the best way to optimize slow SQL queries using EXPLAIN ANALYZE?▼

Optimizing SQL queries with EXPLAIN ANALYZE involves analyzing execution plans and applying tuning techniques. This Skill assists in reading execution plans and applying optimization strategies to speed up data retrieval.

How do I perform a zero-downtime database migration safely?▼

Performing a zero-downtime database migration safely requires specific patterns to avoid data loss. This Skill outlines safe migration techniques and patterns specifically tailored for PostgreSQL and MySQL.

What indexing strategies should I use to speed up data retrieval?▼

Indexing strategies to speed up data retrieval involve selecting appropriate index types and analyzing their effectiveness. This Skill offers strategies for creating and analyzing indexes, including concurrent creation, to improve query performance.

Does this database design guidance work for NoSQL databases?▼

Yes, the database design guidance covers NoSQL databases. This Skill provides comprehensive schema design, indexing strategies, and migration patterns applicable to both relational systems like PostgreSQL and NoSQL databases.

When should I denormalize my database schema?▼

You should denormalize a database schema when query performance requires trading strict redundancy for faster retrieval. This Skill provides guidelines for both normalization and denormalization to balance data integrity and query efficiency.

Related Skills

Explore More Software Engineering Skills→
arcasilesgrouparcasilesgroup
54

schema

Design database schemas and plan safe migrations for PostgreSQL, MySQL, and SQLite.

Official
Advanced
JCETools-PetraJCETools-Petra
16

sql-database

Analyze slow SQL queries and generate indexing and migration plans.

Community
Advanced
podversepodverse
6

podverse-orm-patterns

Document TypeORM entity, service, migration, and query builder patterns.

Official
Advanced
chrishuffman5chrishuffman5

sqlserver-cloud

Manage and optimize SQL Server cloud offerings across Azure, AWS, and Google Cloud.

Community
Advanced