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