Prompt lesson · 19 prompts
Database Compliance and Regulations prompts for Database Administrators
19 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.
Audit Trail Implementation and Monitoring
Use this when you need to set up or improve audit trail logging and monitoring to meet compliance and security requirements.
Role You are a database audit and compliance expert. Your goal is to help me implement a comprehensive audit trail system that logs all critical database activities and supports regulatory compliance.
Context you provide
- {{database_platform}}: The database system in use (e.g., Oracle, SQL Server, MongoDB).
- {{regulations}}: The industry regulations to comply with (e.g., SOX, HIPAA).
- {{suspicious_activities}}: The types of activities that should trigger alerts (e.g., unauthorized access, data deletion).
- {{current_setup}}: Any existing audit logging or monitoring tools.
Instructions
- Ask for missing context before proceeding.
- Recommend a configuration for comprehensive audit logging, including which events to capture (e.g., logins, data changes, schema modifications).
- Provide best practices for reviewing audit trails, including a structured audit schedule.
- Suggest how to set up automated alerts for suspicious activities, specifying indicators to monitor.
- Recommend tools or techniques for analyzing audit trail data to identify compliance issues.
- Ensure the audit trail is tamper-proof and secure.
Output format Provide a structured response with sections: Audit Logging Configuration, Review Best Practices, Alert Setup, Analysis Tools, and Tamper-Proofing. Use bullet points and clear headings. Keep the tone technical and actionable.
Guardrails
- Do not invent specific tool names unless they are well-known; instead, describe features to look for.
- Flag any assumptions about the database platform or regulatory requirements.
- Stay focused on audit trail monitoring; do not expand into broader security.
Example
- {{database_platform}}: "SQL Server"
- {{regulations}}: "SOX"
- {{suspicious_activities}}: "failed logins, bulk data export"
- {{current_setup}}: "no audit logging enabled"
Open this prompt Planning · Intermediate
Backup and Disaster Recovery Strategy
Use this when you need to design or improve backup and disaster recovery plans to ensure data integrity and regulatory compliance.
Role You are a disaster recovery and compliance expert. Your goal is to help me create a comprehensive backup and disaster recovery strategy that ensures data integrity and meets regulatory requirements.
Context you provide
- {{regulatory_requirements}}: The specific regulations to comply with (e.g., GDPR, HIPAA, PCI-DSS).
- {{critical_operations}}: The critical systems and data that must be prioritized for recovery.
- {{current_infrastructure}}: Our existing backup and recovery infrastructure, if any.
- {{downtime_tolerance}}: The maximum acceptable downtime (RTO) and data loss (RPO).
Instructions
- Ask for missing context before proceeding.
- Outline best practices for designing a backup strategy that aligns with the given regulations, including data integrity checks.
- Identify key components of a comprehensive backup and disaster recovery plan (e.g., backup types, storage, retention, failover).
- Provide a testing schedule and methodology to ensure reliability.
- Recommend automated tools and how they can minimize downtime while maintaining compliance.
- Develop a recovery prioritization strategy for critical operations in a disaster scenario.
Output format Provide a structured plan with sections: Regulatory Requirements, Backup Strategy, Disaster Recovery Plan, Testing Schedule, Recommended Tools, and Recovery Prioritization. Use bullet points and clear headings. Keep the tone professional and actionable.
Guardrails
- Do not invent specific tools or costs; suggest categories and criteria for selection.
- Flag any assumptions about our infrastructure or regulatory scope.
- Stay focused on backup and disaster recovery; do not expand into broader business continuity.
Example
- {{regulatory_requirements}}: "HIPAA"
- {{critical_operations}}: "patient records, billing system"
- {{current_infrastructure}}: "nightly backups to tape"
- {{downtime_tolerance}}: "RTO 4 hours, RPO 1 hour"
Open this prompt Planning · Intermediate
Backup and Recovery Testing Guide
Use this when you need to plan or improve backup and recovery testing to ensure data protection and compliance.
Open this prompt Planning · Intermediate
Compliance Reporting
Use this when you need to generate or streamline compliance reports for regulatory audits.
Open this prompt Creating · Intermediate
Configure Database Monitoring and Logging
Use this when you need to set up or improve monitoring and logging to detect unauthorized access or suspicious activities in your database.
Open this prompt Planning · Intermediate
Data Breach Response Planning
Use this when you need to develop or improve a data breach response plan that meets regulatory notification requirements.
Open this prompt Planning · Intermediate
Data Classification and Labeling
Use this when you need to establish or improve a data classification framework to meet data protection regulations.
Open this prompt Planning · Intermediate
Data Masking and Anonymization Plan
Use this when you need to protect sensitive data in databases while maintaining usability and compliance.
Open this prompt Planning · Intermediate
Data Retention Policy Framework
Use this when you need to establish or refine data retention policies to meet legal and regulatory requirements.
Open this prompt Planning · Intermediate
Database Access Control Setup
Use this when you need to implement or improve role-based access control in your database to ensure security and compliance.
Open this prompt Planning · Intermediate
Database Compliance Audit Checklist
Use this when you need to conduct or streamline compliance audits for your databases.
Open this prompt Planning · Intermediate
Database Disaster Recovery Plan
Use this when you need to develop or test a disaster recovery plan for your databases to ensure business continuity and compliance.
Open this prompt Planning · Advanced
Database Encryption Implementation
Use this when you need to implement or strengthen encryption for sensitive data in your database to meet compliance standards.
Open this prompt Planning · Advanced
Design Replication and High Availability
Use this when you need to implement database replication and high availability to ensure data availability and business continuity compliance.
Open this prompt Planning · Advanced
Implement Database Performance Monitoring
Use this when you need to set up or improve database performance monitoring to meet SLAs and compliance standards.
Open this prompt Planning · Intermediate
Optimize Database Performance Tuning
Use this when you need to improve database performance to meet compliance standards and ensure efficient data processing.
Open this prompt Analysis · Advanced
Plan Database Patching and Upgrades
Use this when you need to plan and execute database patching and upgrades to maintain security and compliance.
Open this prompt Planning · Intermediate
Privacy Compliance Strategy
Use this when you need to align data handling practices with privacy regulations.
Open this prompt Planning · Advanced
Secure Data Disposal Procedures
Use this when you need to establish or refine procedures for secure data disposal and destruction to meet regulatory guidelines.
Open this prompt Planning · Intermediate