SQL migration script from schema diff
Act as a Database Administrator. Write a PostgreSQL migration script to alter an existing table called `users`. I need to add a new string column `stripe_customer_id`, rename `full_name` to `display_name`, and create a unique index on the `email` column. Include the 'DOWN' rollback script as well.
🌟 Example Output / Preview
Prompt Metadata
Primary Use Cases:
- •Legacy code modernization & technical refactoring
- •Full-stack layout generation & component structuring
- •CI/CD workflow automation & unit/E2E testing suites
Associated Tags:
💡 Pro Tips & Advice
1. Use bracketed items: Be sure to fill out all [PLACEHOLDER] elements with specific details before sending the prompt to the AI model.
2. Adjust temperature: For creative tasks, set AI temperature higher (e.g., 0.8), or lower (e.g., 0.2) for strict coding/technical tasks.
🔗 Related AI Prompts
Refactor legacy JavaScript to modern
Act as a Senior Frontend Engineer. Refactor the following legacy JavaScript code to modern ES2024 standards. Use const/let, arrow ...
Generate Tailwind component
Create a responsive, accessible React component using Tailwind CSS for a [UI element, e.g., Pricing Table with 3 tiers]. Include h...
Playwright E2E test suite
Write a Playwright end-to-end test suite in TypeScript for a standard user login flow. Include tests for: successful login, invali...