Build my prompt

Text & chat prompt

Design a database schema

Design a database schema: a free, copy-paste prompt for ChatGPT, Gemini and Claude. Paste the prompt and replace each [BRACKETED] field with your own details.

Text & chatChatGPTGeminiClaude

The prompt

Design a database schema for [APPLICATION].

Database: [POSTGRESQL / MYSQL / OTHER]
Main entities and rules: [DESCRIBE]
Most common queries: [QUERIES]
Expected size: [SCALE]

Provide the tables with columns, types, primary and foreign keys, indexes, constraints and a short explanation of key design choices. Point out any trade-offs and future changes to consider.
Copy & open ChatGPTCopy & open GeminiCopy & open Claude Customise in the builder

Pro tip: Describe your top five queries up front so the schema is built for how you will use it.

How to use this prompt

  1. Open ChatGPT and start a new chat.
  2. Paste the prompt.
  3. Replace each [BRACKETED] field with your real details and paste in your own text where asked.
  4. Reply with follow-ups such as "make it shorter" or "make it sound more like me".

Prompt at a glance

Category
Text & chat
Works with
ChatGPT · Gemini · Claude
Length
53 words
Fields to fill in
APPLICATION, POSTGRESQL / MYSQL / OTHER, DESCRIBE, QUERIES, SCALE
Last updated

Frequently asked questions

Which AI tools work with this prompt?

It is written for ChatGPT, Gemini and Claude. Paste it into your preferred tool and adjust the wording if the result is off.

What do I need to fill in?

Replace these fields before you send it: APPLICATION, POSTGRESQL / MYSQL / OTHER, DESCRIBE, QUERIES, SCALE. Each field shows an example in the prompt.

Should I paste private information into the prompt?

Only what the task needs. Remove names, contact details and other sensitive data before pasting a resume or document into any AI tool.

More chat & writing prompts

Before and after example: Rewrite resume points (ATS-friendly) Text & chat · TrendingRewrite resume points (ATS-friendly)ChatGPT · Gemini · Claude Text & chat · TrendingMock interview practice (one question at a time)ChatGPT · Gemini · Claude Text & chat · TrendingResearch a company before your interviewChatGPT · Gemini · Claude Text & chat · TrendingViral Reel / Shorts script with a hookChatGPT · Gemini · Claude

See all 373 chat & writing prompts →