Database Migration Strategy Engineer
Designs zero-downtime database migrations covering expand-contract, online schema change, backward compatibility, and rollback.
About this prompt
When to use this prompt
- check_circlePlan zero-downtime column rename using expand-contract pattern on 500M row production table.
- check_circleDesign concurrent index creation for PostgreSQL table with 24/7 traffic and no maintenance window.
- check_circleExecute NOT NULL constraint addition with batched backfill on live production table.
Latest Insights
Stay ahead with the latest in prompt engineering.
ArticleHow to Write System Prompts That Actually Work
System prompts set the rules of the game for every AI interaction. This hands-on guide shows you exactly how to structure them for reliability and consistency.
ArticleClaude vs GPT-4o: Which Model Fits Your Use Case?
Choosing between Claude and GPT-4o is less about which is "better" and more about which fits your specific task. Here is a practical breakdown.
ArticleHow Our Design Team Cut Brief-Writing Time by 70% with AI
A real-world case study on how a 12-person design team at a product agency standardised their creative brief process using prompt templates on PromptShip.
ArticleWhy AI Hallucinations Happen (and How to Reduce Them)
Hallucinations are not bugs — they are a fundamental property of how language models work. Understanding why they happen is the first step to minimising them.
ArticleThe State of AI Coding Assistants in 2026
From autocomplete to autonomous agents — AI coding tools have changed dramatically. Here is where things stand and what to expect next.
ArticleFrom Idea to Shipped Prompt: A Solo Founder's AI Workflow
One founder. No team. A dozen AI-powered tools and a tight prompt library. Here is the workflow that runs a bootstrapped SaaS doing $15k MRR.
Recommended Prompts
Database Migration PR Reviewer
Expert review of database migration PRs covering production safety, rollback capability, lock risk, zero-downtime deployment, and data integrity.
Database DevOps & Infrastructure-as-Code Engineer
Automates database infrastructure using Terraform, Ansible, and migration tooling covering provisioning, configuration, and schema automation.
Database Query & ORM Code Reviewer
Database expert review of SQL queries, ORM usage, indexing strategy, transaction management, and query performance optimization.
PostgreSQL Performance Tuning Expert
Tunes PostgreSQL performance covering EXPLAIN ANALYZE, index optimization, vacuum tuning, connection pooling, and query rewrites.
Capacity Planning Assessment
Deep-dive capacity prompt engineered for database administration professionals who need concrete recommendations backed by real-world trade-off analysis.
Database Cloud Assessment
Structured database analysis engine — takes your specific context and constraints and delivers an expert-level action plan you can execute immediately.
Token Counter
Real-time tokenizer for GPT & Claude.
Cost Tracking
Analytics for model expenditure.
API Endpoints
Deploy prompts as managed endpoints.
Auto-Eval
Quality scoring using similarity benchmarks.