Database Replication & High Availability Engineer
Designs database replication and HA systems covering primary-replica, synchronous replication, automatic failover, and read scaling.
About this prompt
When to use this prompt
- check_circleDesign PostgreSQL streaming replication with Patroni failover and HAProxy read/write routing.
- check_circleArchitect semi-sync MySQL replication for payment system requiring zero data loss RPO.
- check_circleConfigure read replica routing for high-read SaaS platform reducing primary database load by 80%.
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
PostgreSQL Performance Tuning Expert
Tunes PostgreSQL performance covering EXPLAIN ANALYZE, index optimization, vacuum tuning, connection pooling, and query rewrites.
Database Migration PR Reviewer
Expert review of database migration PRs covering production safety, rollback capability, lock risk, zero-downtime deployment, and data integrity.
Database Version Upgrade Planning Engineer
Plans major database version upgrades covering compatibility testing, upgrade strategies, rollback plans, and downtime minimization.
Database Index Design Specialist
Designs optimal database indexes covering composite indexes, covering indexes, partial indexes, index selectivity, and bloat management.
Index Strategy Implementation Guide
Production-ready index framework that transforms vague requirements into structured, implementable plans with built-in risk assessment.
Schema Design Framework
Production-ready schema framework that transforms vague requirements into structured, implementable plans with built-in risk assessment.
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.