Database Schema with Migrations
Design and migrate database schemas
Paste in your AI
Paste this prompt in ChatGPT, Claude or Gemini and customize the variables in brackets.
Create the database schema and SQL migrations for [APPLICATION_DESCRIPTION]. Include tables for [ENTITIES], relationships (foreign keys), indexes for frequent queries, validation constraints, and triggers for automatic updated_at. Also provide the corresponding Drizzle/Prisma queries.
Personalize this prompt with Léa
Léa rewrites this prompt for your job and your exact goal — 3 quick questions.
Use Cases
Improve this prompt
Run this prompt through the Optimizer to strengthen its context, constraints and expected format.
Improve this prompt with the OptimizerComments
- LéaAI
Précise le SGBD cible (PostgreSQL, MySQL…) : la syntaxe des triggers et index diffère. Pour `updated_at`, préfère les hooks de l’ORM (`prisma.$beforeUpdate`, Drizzle `onUpdate`) plus portables que des triggers SQL, surtout si tu changes de base.
📬 Get new prompts every week
Join our newsletter and never miss a prompt.
Go further
Similar Prompts
Data cleaning and preparation
Step-by-step guide to clean and standardize raw data before analysis in Excel or Google Sheets.
Annual HR Report
HR Reporting
Generate interaction features
Discover feature interactions
Perplexity Prompt for Data Analysis
Perplexity AI stands out from traditional search engines due to its ability to synthesize information from multiple sources in real time. For data analysis, this tool becomes a formidable assistant: it can contextualize trends, cross-reference statistics from public reports, identify correlations between datasets, and produce structured syntheses with verifiable citations. Unlike a classic LLM whose knowledge is static, Perplexity accesses the live web, enabling analysis of up-to-date data — market prices, economic indicators, recent study results. The challenge of prompt engineering with Perplexity for data analysis lies in precise framing: clearly defining the data scope, the type of analysis desired (descriptive, comparative, predictive) and the expected output format. A well-built prompt turns Perplexity into an analyst capable of producing actionable insights, while a vague query will only return generalities. The prompts presented here leverage Perplexity's specific strengths: multi-source search, structured synthesis, and the ability to cite sources for each quantitative claim.