Agent skill · data analytics · aiskillstore
database-schema-design
Design and optimize database schemas for SQL and NoSQL databases. Use when creating new databases, designing tables, defining relationships, indexing strategies, or database migrations. Handles PostgreSQL, MySQL, MongoDB, normalization, and performance optimization.
Why this skill is useful
Provides specific strategies for designing and optimizing database schemas that the AI wouldn't reliably generate on its own.
What it needs
About 10k tokens when loaded. Last updated 2026-08-07. 405 stars on the source repository.
What this skill does
Database Schema Design When to use this skill Lists specific situations where this skill should be triggered: New Project: Database schema design for a new application Schema Refactoring: Redesigning an existing schema for performance or scalability Relationship Definition: Implementing 1:1, 1:N, N:M relationships between tables Migration: Safely applying schema changes Performance Issues: Index and schema optimization to resolve slow queries Input Format The required and optional input information to collect from the user: Required Information Database Type: PostgreSQL, MySQL, MongoDB, SQLite, etc. Domain Description: What data will be stored (e.g., e-commerce, blog, social media) Key Entities: Core data objects (e.g., User, Product, Order) Optional Information Expected Data Volume: Small (<10K rows), Medium (10K-1M), Large (>1M) (default: Medium) Read/Write Ratio: Read-heavy, Write-heavy, Balanced (default: Balanced) Transaction Requirements: Whether ACID is required (default: true) Sharding/Partitioning: Whether large data distribution is needed (default: false) Input Example Instructions Specifies the step-by-step task sequence to follow precisely. Step 1: Define Entities and Attributes Identify core data objects and their attributes. Tasks: Extract nouns from business requirements → entities List each entity's attributes (columns) Determine data types (VARCHAR, INTEGER, TIMESTAMP, JSON, etc.) Designate Primary Keys (UUID vs Auto-increment ID) Example (E-commerce): Step 2: Design Relationships and Normalization Define relationships between tables and apply normalization. …
How to use it
Reference it in AdaL, Claude Code, Cursor or any coding agent — nothing to install:
@skills aiskillstore/database-schema-design