Design a database schema: Free AI Prompt | SheCodes

Free AI prompt · The Code Book

Design a database schema

A ready-to-use prompt from the chapter Database Design. Paste it into Claude, ChatGPT, Lovable, Bolt or any AI coding tool.

The prompt

“Design a database schema for my [type of app]. I need to store [data types]. Show me the tables, columns, and relationships between them.”

How to use it

  1. Fill in the blanks with your own details, so the AI builds your project, not a generic one.
  2. Copy the prompt and paste it into your AI coding tool.
  3. Check the result in the preview, then ask for changes one at a time: "make the buttons bigger", "use my brand colours".
  4. Read the chapter to understand why it works and what to do next.

More prompts like this

All prompts

Start a new database

“Set up a database for a [blog / online store / booking app] with tables for [users, posts, comments] and connect them with the right relationships.”

Set up a complete app database

“I'm building a [recipe sharing app]. Design the complete database with all the tables I'll need, explain what each table stores, and set up the connections between them.”

Create supabase tables

“Create Supabase tables for my project: [describe your app]. Include proper data types, foreign keys, and row-level security so users can only access their own data.”