database-design

Design and optimize relational database schemas for PostgreSQL and MySQL.

4|1|Updated Jan 7, 2026

Search Tags:#schema design #database #postgresql #optimization #sql #mysql

Ready to run

npx skills add https://github.com/an8079/take-skills --skill database-design-an8079

💬 Prompt for ChatGPT / Claude Chat▼

Please help me install this Agent Skill.
Skill: database-design
Source: https://github.com/an8079/take-skills/tree/main/skills/database-design
Command: npx skills add https://github.com/an8079/take-skills --skill database-design-an8079

SYSTEM DOCUMENTATION & REQUIREMENTS

💡 This Skill includes references (resource) components.

What problem does it solve?

This Skill streamlines the process of designing robust and efficient relational database schemas, optimizing table structures, and ensuring data integrity.

Core Features & Use Cases

Schema Design: Create well-structured tables, define relationships, and choose appropriate data types.
Index Optimization: Implement effective indexing strategies to improve query performance.
Use Case: Design a new database schema for an e-commerce platform, including tables for users, products, orders, and order items, with optimized indexing for common queries.

Quick Start

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

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 relational database schema for an e-commerce platform?▼

To design a relational database schema for an e-commerce platform, define table structures for users, products, and orders, choose appropriate SQL data types, and implement optimized indexing for common queries.

What is the best way to optimize SQL queries with indexing in PostgreSQL?▼

Optimizing SQL queries with indexing in PostgreSQL involves implementing effective indexing strategies on table structures to improve query performance and ensure data integrity across relational databases.

Can I generate ER diagrams and migration scripts for MySQL database designs?▼

Yes, you can generate ER diagrams and create migration scripts for MySQL database designs to visualize table relationships and manage structural changes efficiently.

Does this database schema design approach support connection pooling configuration?▼

Yes, this database schema design approach supports connection pooling configuration alongside table structure optimization, data type selection, and indexing strategies for SQL databases.

How do I choose appropriate data types when designing tables for a PostgreSQL blog?▼

Choosing appropriate data types when designing tables for a PostgreSQL blog requires defining structured tables for posts, users, and comments to ensure data integrity and query optimization.

What are the limitations of relying on schema design for database optimization?▼

Relying on schema design for database optimization focuses on table structures, indexing, and data types, meaning it does not inherently resolve external connection bottlenecks without specific pooling configuration.