skills.rest
an8079
an8079COMMUNITY
Explore all skills by this author →
GitHub

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
One-click install
npx skills add https://github.com/an8079/take-skills --skill database-design-an8079
Or copy as Structured Prompt for Agent▼
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.

Related Skills

Explore More Software Engineering Skills→
musujmusuj

phase-1-schema

Define project terminology, entities, relationships, and data structures.

Community
Intermediate
giosuetedeschi-specgiosuetedeschi-spec

neon-postgres

Configure Neon serverless Postgres connection pooling and ORM driver integration.

Community
Intermediate
devon87warren-afkdevon87warren-afk

database-design

Guide database and ORM selection, schema design, indexing, and query optimization.

Community
Intermediate
pluginagentmarketplacepluginagentmarketplace
1

mongodb

Model data and query MongoDB databases with CRUD, indexing, and aggregation pipelines.

Community
Intermediate