Database Schema Designer

Coding & Dev Prompts ChatGPT (GPT-4o) 5 views 0 copies

Design an optimized database schema with proper relationships, indexes, and migration scripts.

Prompt

Design a complete database schema for [Application Type] application. Use [MySQL/PostgreSQL/MongoDB]. Requirements:

[Describe your application requirements, main entities, and relationships]

Provide:
1. Entity-Relationship diagram (text format)
2. Complete table/collection definitions
3. Data types and constraints
4. Primary and foreign keys
5. Indexes (explain reasoning for each)
6. Normalization level (1NF/2NF/3NF) reasoning
7. Many-to-many junction tables
8. Audit/timestamp fields
9. Soft delete strategy
10. Migration scripts (SQL/NoSQL)
11. Sample seed data
12. Common query examples
13. Scaling considerations
14. Backup strategy recommendation

How To Use This Prompt

Describe your application requirements, main entities, and expected data volume.

Example Output

          Table: users (id INT PK, email VARCHAR(255) UNIQUE, password_hash VARCHAR(255), created_at TIMESTAMP)...        

Frequently Asked Questions

What is the "Database Schema Designer" prompt used for?

Design an optimized database schema with proper relationships, indexes, and migration scripts.

Which AI models work with this prompt?

This prompt works best with ChatGPT (GPT-4o). You can also try it with other large language models for similar results.

Can I modify this prompt?

Yes! Feel free to copy and customize this prompt to better fit your specific needs. You can change names, industries, tones, or any other variables to personalize the output.

Is this prompt free to use?

Absolutely. All prompts on GetPromptPro are free to copy and use for personal or commercial purposes.