Loading...
Loading...
Found 20 Skills
Process use when you need to archive historical database records to reduce primary database size. This skill automates moving old data to archive tables or cold storage (S3, Azure Blob, GCS). Trigger with phrases like "archive old database records", "implement data retention policy", "move historical data to cold storage", or "reduce database size with archival".
Standards and best practices for writing LookML tests to ensure data integrity, accuracy, and logic validation.
Idempotent Redundancy
Security & Data Integrity (Architect Level)
Error handling patterns for ERPNext/Frappe database operations. Use when handling DoesNotExistError, DuplicateEntryError, transaction failures, and query errors. Covers retry patterns and data integrity. V14/V15/V16 compatible. Triggers: database error, DoesNotExistError, DuplicateEntryError, transaction failed, query error.
Security & Data Integrity (Architect Level)
Verify accounting integrity. Compare totals to source docs, check lots vs holdings, detect duplicates, report gaps.
Audits SQL migration files for destructive actions, potential table locks, and compatibility issues. Use before applying migrations to production databases to prevent downtime and ensure data integrity.