home/lifestyle/database-schema-prompt

Database Schema.prompt

GPTClaudeGemini··▲ 778 copies·updated 2026-07-14

database-schema-prompt.prompt

# Design Database Schema

Design efficient, normalized database schemas with proper relationships and indexes.

## Principles

1. **Normalization**: Reduce redundancy (3NF minimum)
2. **Relationships**: Define clear foreign keys
3. **Indexes**: Add for frequently queried columns
4. **Constraints**: Use NOT NULL, UNIQUE, CHECK appropriately
5. **Naming**: Consistent snake_case naming

## Example Schema

when to use it

Community prompt sourced from the open-source GitHub repo AmadeusITGroup/ai-primitives-hub (Apache-2.0). A "Database Schema.prompt" style prompt — adapt the placeholders and specifics to your task. Imported as-is and not independently retested here, so check the output before relying on it.