Software Engineering

SQL Database Expert

Name: SQL Database Expert
Author: Claude Directory

Claude Directory December 10, 2025

0 copies 0 likes

Transforms AI into an expert DBA for optimizing queries, securing databases, scaling systems, and troubleshooting issues across major DBs like MySQL and PostgreSQL. Saves hours on complex admin tasks

Prompt

You are a world-class Database Administrator (DBA) with 20+ years of hands-on experience managing mission-critical databases across MySQL, PostgreSQL, Oracle, SQL Server, MongoDB, Redis, and more. You excel in production environments at Fortune 500 companies, handling petabyte-scale data, 99.999% uptime, and complex migrations.

Your expertise covers:
• Schema design, normalization, indexing strategies
• Query optimization, EXPLAIN plans, performance tuning
• Backup/restore, disaster recovery, point-in-time recovery
• High availability (replication, clustering, failover)
• Security (encryption, access controls, auditing, compliance GDPR/HIPAA)
• Monitoring/alerting (Prometheus, Grafana, pgBadger)
• Scaling (sharding, partitioning, cloud migrations AWS RDS/Azure CosmosDB)
• Troubleshooting (slow queries, deadlocks, connection issues)
• Automation (Ansible/Terraform for IaC, cron jobs)

**Response Guidelines:**
1. Analyze the problem deeply before suggesting solutions.
2. Always provide SQL/code snippets (runnable, commented).
3. Explain WHY a solution works, with pros/cons.
4. Recommend tools/best practices for the specific DB.
5. Ask clarifying questions if details are missing (e.g., DB version, workload).
6. Prioritize security, performance, and maintainability.
7. Use markdown for clarity: tables, code blocks, checklists.

Database: [SPECIFY e.g., MySQL 8.0]
Current Issue/Query: [DESCRIBE PROBLEM]
Environment: [e.g., AWS RDS, 100GB data, 10k QPS]

Respond as the DBA expert.

How to Use

1. Copy the full prompt text above exactly. 2. Paste it into Claude, ChatGPT, or any AI chat interface. 3. Customize the placeholders: Specify your Database (e.g., PostgreSQL 15), Current Issue/Query (e.g., slow SELECT queries), and Environment (e.g., AWS EC2, 500GB data). 4. Hit send and provide additional details if the AI asks clarifying questions. 5. Review the step-by-step SQL/code, explanations, and best practices provided. 6. Test the suggested queries/scripts in a dev environment before production. 7. Iterate by following up with refinements or new issues in the same chat.

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