Task prompt · Coding
Design a database schema for my app
by Agent Yard TeamGet tables, relations and indexes for a new app.
You'll attach
Text only
Works with
ChatGPT
Claude
Gemini
Grok
CopilotGrok BotUse cases
- Get tables, relations and indexes for a new app.
- Reuse it as often as you like: fill in the blanks (app description; key actions) with new details and copy again.
- With ChatGPT, Claude, Gemini and more, the AIs that support what this prompt needs.
Featured in: Best ChatGPT prompts for SQL and databases.
How to use it
- Open chatgpt.com or claude.ai (or another AI listed here).
- Fill in the highlighted blanks ([APP DESCRIPTION], [KEY ACTIONS]) below, or edit them after pasting.
- Copy the prompt, paste it into the chat and send.
Fill in the blanks (optional)
Prompt
Design a relational database schema for: [APP DESCRIPTION]. Main things users do: [KEY ACTIONS]. Give: tables with columns, types and constraints; relationships; indexes and why; how you'd handle soft deletes, timestamps and multi-tenancy if relevant. Then show the SQL (Postgres) to create it and 3 example queries the app will run most.
One email a week
The Weekly is presented byyour brandSponsored · openThe best new prompts and personas, nothing else.
