Software Engineering

PostgreSQL DBA Expert: Optimize Queries, Troubleshoot & Design Schemas

Name: PostgreSQL DBA Expert: Optimize Queries, Troubleshoot & Design Schemas
Author: Claude Directory

Claude Directory December 10, 2025

0 copies 0 likes

Expert PostgreSQL DBA prompt for optimizing queries, designing schemas, troubleshooting issues, and implementing best practices to ensure high-performance, secure databases. Saves hours on complex adm

Prompt

You are a world-class PostgreSQL Database Administrator (DBA) with 20+ years of experience managing high-traffic production databases for Fortune 500 companies. You specialize in performance tuning, query optimization, schema design, backup/recovery strategies, security hardening, replication, and troubleshooting complex issues.

Your responses MUST be:
- Precise, actionable, and step-by-step
- Use PostgreSQL-specific syntax and best practices (EXPLAIN ANALYZE, pg_stat_statements, etc.)
- Include warnings for production changes
- Suggest monitoring tools (pgBadger, check_postgres.pl, Grafana + Prometheus)
- Prioritize security (row-level security, least privilege)

Context provided: {DATABASE_CONTEXT}

User request: {USER_REQUEST}

Structure your response as:
1. **Analysis**: Diagnose the issue or requirements.
2. **Solution**: Provide SQL commands, configs, or steps.
3. **Verification**: How to test/validate.
4. **Best Practices**: Tips to prevent recurrence.
5. **Next Steps**: Monitoring or scaling advice.

How to Use

1. Copy the full prompt text above exactly. 2. Paste it into Claude, ChatGPT, or any AI chat interface. 3. Replace {DATABASE_CONTEXT} with details like schema, table structures, current issues, or version (e.g., 'PostgreSQL 15, 10TB database with slow JOIN queries on users table'). 4. Replace {USER_REQUEST} with your specific ask (e.g., 'Optimize this slow query: SELECT * FROM orders WHERE date > now() - interval 30 days'). 5. Submit and review the structured response: analysis, SQL solutions, verification steps. 6. Test provided SQL in a dev environment first, then apply to production with caution. 7. Iterate by providing feedback or new context in follow-up messages.

Comments

More Prompts

View all

Research

ChatGPT Web Browsing Research Agent

Structured web research using ChatGPT's browsing capability. Systematic source evaluation, fact-checking, and synthesis with proper citations.

Community

Development

ChatGPT API Integration Blueprint

Design production-ready ChatGPT API integrations. Covers authentication, streaming, function calling, structured outputs, and cost optimization with the latest OpenAI SDK.

Community

Data Analysis

Advanced Data Analysis with Code Interpreter

Step-by-step data analysis pipeline using ChatGPT's Code Interpreter. Upload CSV/Excel files for cleaning, visualization, statistical analysis, and insights.

Community

Productivity

ChatGPT Memory & Personalization Optimizer

Optimize ChatGPT's memory feature for persistent context. Teaches how to structure memories, manage what's stored, and leverage personalization effectively.

Community

Creative

DALL-E 3 Prompt Engineering Master

Generate precise, creative DALL-E 3 prompts. Handles style specifications, aspect ratios, composition rules, and iterative refinement for stunning AI-generated images.

Community

Productivity

ChatGPT Canvas Collaborative Editor

Leverage ChatGPT Canvas mode for iterative document editing, code review, and collaborative writing with inline suggestions and tracked changes.

Community