Skill

database-schema

Designs relational database schemas with tables, constraints, relationships, indexes, and generates CREATE TABLE SQL plus optimizations. For PostgreSQL, MySQL, MongoDB, Supabase.

PostgreSQL

MySQL

npx claudepluginhub sunnypatneedi/claude-starter-kit

Tool Access

This skill uses the workspace's default tool permissions.

Preview

Help me design a database schema:

SKILL.md

Similar Skills

designing-database-schemas

1.9k

Designs normalized relational database schemas for PostgreSQL and MySQL from requirements, generating DDL, constraints, indexes, relationships, and migrations.

3 files8 tools

database-schema-designer

schema-design

Database schema design with normalization, relationships, constraints, and data integrity.

database-engineering

flux-schema

Designs database schemas—tables, columns, types, indexes, constraints, relationships—from domain descriptions. Outputs DDL, ORM configs, migrations; detects stack like Prisma/Drizzle or defaults to PostgreSQL SQL.

11 tools

tonone

Stats

Stars5

Forks1

Last CommitJan 23, 2026

Actions

View Source View Plugin View on GitHub View README

Help us improve

Share bugs, ideas, or general feedback.

Database Schema Design

Help me design a database schema:

Requirements

What are we storing? Describe the data.
Relationships: How do entities relate?
Access patterns: How will data be queried?
Scale: Expected data volume?
Database: PostgreSQL, MySQL, MongoDB, etc.?

Entity Design

For each entity, define:

Table Structure

Table name (plural, snake_case)
Columns with types
Primary key
Timestamps (created_at, updated_at)
Soft delete (deleted_at) if needed

Constraints

NOT NULL where required
UNIQUE constraints
CHECK constraints for validation
DEFAULT values

Relationships

Foreign keys
ON DELETE behavior
Junction tables for many-to-many

Indexes

Primary key index
Foreign key indexes
Query-specific indexes
Composite indexes where needed

Schema Generation

Generate:

CREATE TABLE statements
Index creation
RLS policies (if using Supabase)
Sample seed data

Optimization Review

Check for:

Normalization level appropriate
Index strategy sound
Query patterns supported
Future scaling considerations

Generate the complete schema with comments explaining decisions.