Postgresql Backup
Automates PostgreSQL database backups to secure your data with scheduled snapshots and retention policies.
Install on your platform
We auto-selected Claude Code based on this skill’s supported platforms.
Run in terminal (recommended)
claude mcp add postgresql-backup npx -- -y @trustedskills/postgresql-backup
Or manually add to ~/.claude/settings.json
{
"mcpServers": {
"postgresql-backup": {
"command": "npx",
"args": [
"-y",
"@trustedskills/postgresql-backup"
]
}
}
}Requires Claude Code (claude CLI). Run claude --version to verify your install.
About This Skill
What it does
This skill allows AI agents to create backups of PostgreSQL databases. It can perform full or incremental backups, and specify backup locations for storage. The agent can also restore from these backups when needed, ensuring data recovery capabilities.
When to use it
- Scheduled Data Protection: Automate regular database backups as part of a disaster recovery plan.
- Migration Preparation: Create a backup before performing significant database schema changes or upgrades.
- Development/Testing Environments: Quickly restore databases from backups for testing and development purposes.
- Data Recovery: Recover data after accidental deletions or corruption within the PostgreSQL database.
Key capabilities
- Full Database Backups
- Incremental Backups
- Backup Location Specification
- Database Restoration
Example prompts
- "Create a full backup of the 'production_db' database and store it in '/mnt/backups'."
- "Perform an incremental backup of 'development_db' since the last full backup."
- “Restore the latest backup of ‘staging_db’ to a new database named ‘staging_db_recovered’.”
Tips & gotchas
- Ensure the AI agent has appropriate permissions (read/write) on both the PostgreSQL server and the specified backup location.
- Large databases may require significant time and resources for backups; plan accordingly.
Tags
TrustedSkills Verification
Unlike other registries that point to live repositories, TrustedSkills pins every skill to a verified commit hash. This protects you from malicious updates — what you install today is exactly what was reviewed and verified.
Security Audits
| Gen Agent Trust Hub | Pass |
| Socket | Pass |
| Snyk | Pass |
🌐 Community
Passed automated security scans.