Prompt lesson · 19 prompts
Database Management Tips prompts for Systems Administrators
19 ready-to-use prompts from our AI for Systems Administrators course. Copy one, fill in the {{placeholders}}, and paste it into ChatGPT, Claude, Gemini or any other AI.
Automate Routine Database Tasks
Use this when you want to streamline database operations by identifying and implementing automation for routine tasks.
Role You are a database automation expert. Your goal is to help me identify and implement automation solutions for routine database tasks to improve efficiency and reduce manual effort.
Context you provide
- {{database_type}}: The type of database (e.g., PostgreSQL, MySQL, Oracle).
- {{specific_application}}: The application or system the database supports, if relevant.
- {{current_tasks}}: The routine tasks you want to automate (e.g., backups, performance monitoring).
- {{existing_tools}}: Any automation tools or scripts you already use, if any.
Instructions
- Ask me for any missing context before starting.
- Based on the provided database type and tasks, recommend specific automation tools and techniques, considering both open-source and commercial options.
- Provide strategies for integrating these tools with existing workflows, including step-by-step guidance.
- Highlight common challenges and how to mitigate them.
- Suggest metrics to measure the effectiveness of the automation.
Output format Provide a structured response with sections for recommended tools, integration steps, challenges, and evaluation metrics. Use bullet points for clarity. Keep the tone professional and practical.
Guardrails
- Do not invent tool names or features; if unsure, state assumptions.
- Keep recommendations relevant to the specified database type and tasks.
- Avoid generic advice; tailor to the provided context.
Example
- {{database_type}}: PostgreSQL, {{specific_application}}: e-commerce platform, {{current_tasks}}: backups and performance monitoring, {{existing_tools}}: pgAgent.
Open this prompt Automation · Intermediate
Capacity Planning
Use this when you need to analyze historical data growth and resource utilization to predict future capacity needs for a database or application.
Role — You are a systems architecture and capacity planning expert. Your goal is to help analyze data growth patterns and resource utilization to create a robust capacity plan.
Context you provide —
- {{database_type}}: The type of database (e.g., PostgreSQL, MySQL, MongoDB).
- {{specific_application}}: The name or description of the application using the database.
- {{current_metrics}}: Any current metrics or data points the user has (e.g., storage size, query volume, CPU usage).
Instructions —
- If the context is incomplete, ask the user for the missing information.
- Analyze the provided historical data growth patterns and resource utilization trends to identify key drivers of capacity needs.
- Provide a step-by-step methodology for predicting future capacity requirements over the next year, including relevant formulas or models.
- Recommend specific scaling options (e.g., vertical, horizontal, cloud-based) based on the analysis and the user's application.
- Outline a monitoring plan to track capacity usage and trigger scaling actions.
Output format — A structured plan with sections for analysis, prediction methodology, scaling recommendations, and monitoring plan. Use bullet points and tables where appropriate. The tone should be practical and strategic.
Guardrails —
- Do not invent metrics; base all analysis on the user's provided data.
- Flag any assumptions about growth rates or usage patterns.
- Stay focused on capacity planning; do not provide general database tuning advice unless directly relevant.
Example — Database type: PostgreSQL; Specific application: Customer portal; Current metrics: 500GB storage, 10k queries/hour.
Follow-ups —
- How can I use historical data to create a more accurate growth forecast?
- What are the cost implications of the recommended scaling options?
- Can you provide a template for a capacity monitoring dashboard?
Open this prompt Planning · Intermediate
Create Effective Database Documentation
Use this when you need to document database schemas, configurations, and procedures to improve team collaboration and knowledge sharing.
Open this prompt Creating · Beginner
Data Archiving and Purging
Use this when you need to develop strategies for archiving or purging old data to improve database performance and reduce storage costs while maintaining compliance.
Open this prompt Planning · Intermediate
Database Monitoring and Alerting Plan
Use this when you need monitoring tools, metrics, alert thresholds, and automation techniques for keeping a database environment healthy.
Open this prompt Planning · Intermediate
Database Monitoring and Alerting Setup
Use this when you need guidance on setting up monitoring and alerting for your database to proactively identify and resolve issues.
Open this prompt Planning · Intermediate
Database Security Best Practices
Use this when you need actionable, prioritized security recommendations for a specific database type, covering authentication, access control, encryption, and auditing.
Open this prompt Analysis · Intermediate
Database Troubleshooting and Debugging
Use this when you need to diagnose and resolve database performance issues, deadlocks, or errors.
Open this prompt Analysis · Intermediate
Database Version Control Implementation
Use this when you need to implement or improve version control for database schemas and changes.
Open this prompt Planning · Intermediate
Design Database Backup and Recovery
Use this when you need to establish or improve a database backup and recovery plan to ensure data integrity and availability.
Open this prompt Planning · Intermediate
Design Efficient Database Schema
Use this when you need to design or normalize a database schema for a new or existing application to ensure data integrity and performance.
Open this prompt Writing · Intermediate
Design Replication and High Availability
Use this when you need to plan or implement database replication and high availability to ensure data redundancy and minimize downtime.
Open this prompt Planning · Intermediate
Design Scalable Database Schema
Use this when you need to design a database schema that is both efficient and scalable, especially for applications with high user-generated content.
Open this prompt Writing · Advanced
High Availability and Disaster Recovery Design
Use this when you need to design or improve high availability and disaster recovery for your systems.
Open this prompt Planning · Advanced
Implement Database Security Best Practices
Use this when you need to secure your database through access controls, encryption, and vulnerability mitigation.
Open this prompt Planning · Intermediate
Optimize Database Indexing Strategies
Use this when you need to improve query performance by selecting and implementing effective indexing strategies.
Open this prompt Analysis · Advanced
Optimize Database Performance
Use this when you need to analyze and improve the performance of your database through query tuning, indexing, and configuration adjustments.
Open this prompt Analysis · Intermediate
Plan Database Capacity Growth
Use this when you need to forecast database growth and plan for scalability to avoid performance issues.
Open this prompt Planning · Intermediate
Tune Database Performance Effectively
Use this when you need to optimize database performance through query analysis, indexing, and configuration adjustments.
Open this prompt Analysis · Advanced