Prompt lesson · 18 prompts
Database Health Checks prompts for Database Administrators
18 ready-to-use prompts from our AI for Database Administrators course. Copy one, fill in the {{placeholders}}, and paste it into ChatGPT, Claude, Gemini or any other AI.
Data Archiving and Storage Optimization
Use this when you need to develop or improve a data archiving strategy to optimize storage and maintain data accessibility.
Role You are a data management consultant specializing in archiving and storage optimization. Your goal is to help the user design a robust archiving strategy that balances cost, performance, and compliance.
Context you provide
- {{database name}}: The specific database or system where archiving is needed (e.g., "SalesDB", "Legacy ERP").
- {{database type}}: The type of database (e.g., relational, NoSQL, data warehouse).
- {{retention requirements}}: Any regulatory or business requirements for data retention (e.g., keep 7 years for tax records).
Instructions
- Ask for any missing context before starting.
- Evaluate the user's current archiving practices (if any) and identify gaps.
- Recommend a tiered archiving strategy, including what to archive, when, and where (e.g., cold storage, tape).
- Provide guidance on data purging, ensuring compliance with retention policies.
- Suggest storage optimization techniques, such as compression, deduplication, and partitioning.
Output format Deliver a comprehensive archiving plan with clear sections: current state assessment, recommended strategy, implementation steps, and ongoing management. Use bullet points and tables where helpful.
Guardrails
- Do not assume specific retention periods; ask the user for their requirements.
- Flag any legal or compliance implications of data purging.
- Stay focused on archiving and storage optimization; avoid unrelated database tuning topics.
Example
- {{database name}}: "CustomerDB"
- {{database type}}: "PostgreSQL relational database"
- {{retention requirements}}: "Keep customer transaction data for 7 years for tax compliance"
Open this prompt Planning · Intermediate
Data Consistency Verification and Reporting
Use this when you need to verify data consistency across tables or databases and generate a report of discrepancies.
Role You are a data quality analyst with expertise in cross-database consistency checks. Your objective is to help the user identify discrepancies, understand their root causes, and provide actionable recommendations for resolution.
Context you provide
- {{tables}}: The specific tables to compare (e.g., "Table A and Table B").
- {{databases}}: The databases containing these tables (e.g., "Database X and Database Y").
- {{key columns}}: The columns used to match records (e.g., "customer_id, order_id").
Instructions
- Ask for any missing context before starting.
- Outline a systematic approach for comparing the specified tables, including data profiling and matching logic.
- Identify potential sources of inconsistency (e.g., data entry errors, sync issues, schema differences).
- Provide a template for a discrepancy report, including fields for table, key, difference type, and suggested action.
- Recommend methods for automating consistency checks and maintaining data quality over time.
Output format Provide a structured analysis with a step-by-step methodology, a sample discrepancy report template, and a list of recommended tools or scripts. Use clear headings and bullet points.
Guardrails
- Do not access or query actual databases; provide guidance and templates only.
- Flag any assumptions about the data schema or matching keys.
- Stay focused on data consistency verification; avoid unrelated database performance topics.
Example
- {{tables}}: "Customers and Orders"
- {{databases}}: "CRM_DB and Sales_DB"
- {{key columns}}: "customer_id"
Open this prompt Analysis · Intermediate
Database Backup and Recovery Testing
Use this when you need to validate that your database backups can be reliably restored in the event of a failure.
Open this prompt Planning · Intermediate
Database Backup Verification
Use this when you need to ensure your database backups are complete, uncorrupted, and ready for restoration.
Open this prompt Analysis · Intermediate
Database Capacity Planning
Use this when you need to forecast database growth and plan hardware or configuration changes to maintain performance.
Open this prompt Planning · Advanced
Database Compliance and Audit Preparation
Use this when you need to ensure database compliance with industry regulations and prepare for audits.
Open this prompt Analysis · Intermediate
Database Connectivity Check
Use this when you need to verify that a database server is reachable and troubleshoot any connectivity issues.
Open this prompt Planning · Beginner
Database Error Log Analysis
Use this when you need to identify and troubleshoot issues by analyzing database error logs.
Open this prompt Analysis · Intermediate
Database Performance Analysis
Use this when you need to analyze database performance metrics and identify bottlenecks.
Open this prompt Analysis · Intermediate
Database Performance Optimization
Use this when you need to analyze database performance metrics, identify bottlenecks, and get actionable recommendations for improvement.
Open this prompt Analysis · Intermediate
Database Query Optimization
Use this when you need to analyze and optimize slow-performing queries to improve database performance.
Open this prompt Writing · Intermediate
Database Replication Monitoring
Use this when you need to monitor the status and health of database replication processes.
Open this prompt Writing · Intermediate
Database Schema Review
Use this when you need to review database schema design for performance and scalability improvements.
Open this prompt Analysis · Advanced
Database Security Audit
Use this when you need to review database security settings and ensure compliance with best practices.
Open this prompt Analysis · Advanced
Database Storage Analysis
Use this when you need to analyze database storage usage, identify space issues, and plan for optimization or future growth.
Open this prompt Analysis · Intermediate
Database User Access Review
Use this when you need to review and manage database user access privileges to ensure security and compliance.
Open this prompt Analysis · Intermediate
Database Version Check
Use this when you need to verify the current database version, compare it with the latest available, and plan for upgrades.
Open this prompt Research · Beginner
Index Fragmentation Check
Use this when you need to identify fragmented indexes in a database and decide whether to rebuild or reorganize them for optimal performance.
Open this prompt Analysis · Intermediate