Write a Database Schema Design Review

If you're building an application and need to validate your database design, this ChatGPT prompt can save you from serious performance problems down the road. Database schema design is one of those critical decisions that's easy to overlook when you're focused on getting features shipped. By asking ChatGPT to review your schema, you get an experienced perspective on normalization violations, missing indexes, and potential scaling bottlenecks before they become expensive problems. This prompt works whether you're designing a new database from scratch or inheriting an existing one that's causing query slowdowns.

Using this prompt is straightforward. You simply replace the [application] placeholder with your specific project details. For example, if you're building an e-commerce platform, you'd write "Review a database schema for an e-commerce platform with products, orders, customers, and inventory tracking." The more context you provide about your application's expected scale and usage patterns, the better ChatGPT can tailor its recommendations. You can paste your actual schema definition in SQL, or describe your tables and relationships in plain English if you're still in the planning phase.

When you run this prompt, ChatGPT will analyze your schema and deliver a structured review that covers database normalization principles, which columns should have indexes, and any architectural decisions that might cause problems as your data grows. You'll get specific recommendations rather than generic advice, along with explanations of why each suggestion matters for performance and maintainability.

Here's a pro tip that dramatically improves results: mention your expected data volume and query patterns alongside your schema. Instead of just saying "e-commerce platform," explain that you expect millions of orders and users will frequently search products by category. ChatGPT uses this information to recommend indexes that actually match your real-world access patterns, which is far more valuable than generic indexing suggestions.