database

Name: database
Availability: InStock
Author: JansenAnalytics

Automate database provisioning, migrations, backups, and health checks across PostgreSQL, SQLite, and Redis.

5|Updated Apr 8, 2026

Search Tags:#database #postgresql #redis #migration #sqlite #backup

Ready to run

npx skills add https://github.com/JansenAnalytics/claudex --skill database-jansenanalytics

💬 Prompt for ChatGPT / Claude Chat▼

Please help me install this Agent Skill.
Skill: database
Source: https://github.com/JansenAnalytics/claudex/tree/main/skills/database
Command: npx skills add https://github.com/JansenAnalytics/claudex --skill database-jansenanalytics

SYSTEM DOCUMENTATION & REQUIREMENTS

💡 This Skill includes scripts (resource) and references (resource) components.

What problem does it solve?

PostgreSQL, SQLite, and Redis database management tasks are streamlined by automating provisioning, migrations, backups, and maintenance.

Core Features & Use Cases

Provision and migrate schemas across engines
Backup, restore, and health-check databases
Manage users and permissions, monitor performance, and automate routine maintenance

Quick Start

Run a full backup of your PostgreSQL database using the backup.sh script.

Frequently Asked Questions about database

High-intent search queries and answers about installing and using this skill.

FAQPage Schema

How do I automate PostgreSQL backups and migrations across different environments?▼

Automate PostgreSQL backups and migrations using shell scripts and standard database CLIs. It provisions schemas, runs health checks, and applies repeatable maintenance workflows across development, staging, and production environments.

Can I manage SQLite and Redis user permissions with automated scripts?▼

Yes, you can manage SQLite and Redis user permissions with automated routines. The skill implements scripted user management and performance monitoring using shell scripts and standard database CLIs.

What is the best way to run database health checks for PostgreSQL and Redis?▼

Run database health checks for PostgreSQL and Redis using automated shell scripts. The skill executes scripted routines to monitor performance, verify data safety, and automate routine maintenance tasks.

Does this database automation approach work for both SQLite and Redis schema migrations?▼

Yes, this approach works for SQLite and Redis schema migrations. It provisions and migrates schemas across multiple engines using standard database CLIs, ensuring repeatable maintenance workflows.

How do I restore a PostgreSQL database from a backup script?▼

Restore a PostgreSQL database by executing the backup and restore shell scripts. The skill automates backup, restore, and health-check operations to ensure data safety across your environments.

When do I need automated database provisioning for staging and production environments?▼

You need automated database provisioning for staging and production environments when you require repeatable maintenance workflows, schema migrations, and consistent data safety across PostgreSQL, SQLite, and Redis.