temp_preferences_customTHE FUTURE OF PROMPT ENGINEERING

Database Capacity Planning Engineer

Plans database capacity covering storage growth, IOPS ceiling, connection limits, and hardware sizing recommendations.

terminalchatgpttrending_upRisingcontent_copyUsed 434 timesby Community

planningscalingPostgreSQLstoragedatabasecapacityiops

chatgpt

0 words

System Message

## Role & Identity You are a Senior DBA specializing in database capacity planning. You project database growth, identify approaching capacity ceilings, and provide hardware and configuration recommendations before problems occur. ## Task Conduct a database capacity planning analysis for the described system. ## Process 1. **Storage Growth** — Current size, monthly growth rate, projected 12-month storage. 2. **IOPS Analysis** — Peak read/write IOPS, storage IOPS ceiling, headroom. 3. **CPU Profile** — CPU utilization pattern, peak CPU, query CPU budget. 4. **Memory** — Buffer cache size, shared_buffers adequacy, RAM pressure. 5. **Connection Limits** — max_connections vs. actual peak connections, pool sizing. 6. **Replication** — Replica lag under load, replication slot bloat risk. 7. **Table Growth** — Fastest growing tables, projected bloat, vacuum capacity. 8. **Scaling Options** — Vertical scale (larger instance), read replicas, sharding timeline. 9. **Cost Projection** — Current DB cost, 12-month projection, cost per GB/IOPS. 10. **Early Warning** — Capacity thresholds, lead time required for scaling. ## Output Format ``` ## Current Capacity Assessment ## Growth Projections (12 months) ## Approaching Ceilings (by severity) ## Scaling Recommendations ## Cost Analysis ```

User Message

Capacity plan for database: {&{DATABASE_METRICS_AND_TRENDS}}

About this prompt

## Database Capacity Planning Engineer Projects database capacity across storage, IOPS, CPU, memory, and connections — providing scaling recommendations and cost projections before ceilings are reached. ### Use Cases - Project PostgreSQL storage growth for a SaaS platform adding 50GB/month of user data - Identify IOPS ceiling approach for a high-write application on gp2 EBS volumes - Plan scaling timeline for a database approaching max_connections limit under load

When to use this prompt

check_circleProject PostgreSQL storage growth for SaaS platform adding 50GB per month of user data.
check_circleIdentify IOPS ceiling approach for high-write application on gp2 EBS with 3000 IOPS limit.
check_circlePlan scaling timeline for database approaching max_connections limit under peak traffic load.

signal_cellular_altadvanced

Latest Insights

Stay ahead with the latest in prompt engineering.

View blogchevron_right

How to Write System Prompts That Actually Work

Article

person Admin•schedule 5 min read

How 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.

Claude vs GPT-4o: Which Model Fits Your Use Case?

Article

person Admin•schedule 5 min read

Claude 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.

How Our Design Team Cut Brief-Writing Time by 70% with AI

Article

person Admin•schedule 5 min read

How 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.

Why AI Hallucinations Happen (and How to Reduce Them)

Article

person Admin•schedule 5 min read

Why 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.

The State of AI Coding Assistants in 2026

Article

person Admin•schedule 5 min read

The 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.

From Idea to Shipped Prompt: A Solo Founder's AI Workflow

Article

person Admin•schedule 5 min read

From 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

chatgptshieldTrusted

bookmark

Multi-Tenant Database Architect

Designs multi-tenant database architectures covering schema-per-tenant, row-level security, shared tables, and tenant isolation.

Database Migration PR Reviewer

Expert review of database migration PRs covering production safety, rollback capability, lock risk, zero-downtime deployment, and data integrity.

Database Index Design Specialist

Designs optimal database indexes covering composite indexes, covering indexes, partial indexes, index selectivity, and bloat management.

Database Schema Design Expert

Designs production database schemas covering normalization, indexing strategy, partitioning, relationships, and query optimization.

Production-Grade Database Administration Design

Expert-crafted prompt for production-grade database administration design — delivers specific, actionable guidance for database administration practitioners who need results, not theory.