skills.rest
JansenAnalytics
JansenAnalyticsCOMMUNITY
Explore all skills by this author →
GitHub

database

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
One-click install
npx skills add https://github.com/JansenAnalytics/claudex --skill database-jansenanalytics
Or copy as Structured Prompt for Agent▼
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.

Related Skills

Explore More Software Engineering Skills→
constructive-ioconstructive-io
14

agentic-db-pgpm

Install and deploy the agentic-db PostgreSQL module using pgpm.

Official
Intermediate
gizixgizix
2

model-deployment

Package trained machine learning models with versioning, ONNX export, and FastAPI endpoints.

Community
Advanced
Coffelix2023Coffelix2023
1

devops-engineer

Automate CI/CD pipelines, containerized applications, and cloud infrastructure.

Community
Advanced
ProfPowellProfPowell
1

deployment

Deploy static sites and Node.js services to Cloudflare and DigitalOcean.

Community
Advanced