skills.rest
alabasi2025
alabasi2025COMMUNITY
Explore all skills by this author →
GitHub

database-manager

Automate database migrations, seeding, indexing, and health checks via Python scripts.

Updated Aug 27, 2026
Search Tags:#automation#indexing#database#migrations#optimization#seeding#health-check
One-click install
npx skills add https://github.com/alabasi2025/manus-skills-library --skill database-manager-alabasi2025
Or copy as Structured Prompt for Agent▼
Please help me install this Agent Skill.
Skill: database-manager
Source: https://github.com/alabasi2025/manus-skills-library/tree/main/infrastructure/database-manager
Command: npx skills add https://github.com/alabasi2025/manus-skills-library --skill database-manager-alabasi2025

SYSTEM DOCUMENTATION & REQUIREMENTS

💡 This Skill includes scripts (resource) components.

What problem does it solve?

هذه المهارة تعالج الحاجة إلى إدارة تغيّرات مخطط قاعدة البيانات وتعبئة البيانات الأولية وتحسين الأداء بشكل آلي، مما يقلل الوقت والجهد ويقلل الأخطاء البشرية.

Core Features & Use Cases

  • Migrations: إنشاء وتنفيذ تغيّرات المخطط (migrations) وتطبيقها عبر بيئة التطوير والإنتاج.
  • Seeding: تعبئة البيانات الأولية والمتواجدة عبر بيئات متعددة لتسريع الإعداد.
  • Indexing & Optimization: إدارة الفهارس وتحسين الاستعلامات وتحليل الأداء.
  • Health Check & Schema Sync: فحص الصحة ومزامنة المخطط لضمان التوافق بين التطبيق وقاعدة البيانات.

Quick Start

  • Create a new migration: python scripts/migration.py --action create --name "add_invoices_table"
  • Run migrations: python scripts/migration.py --action run --target latest
  • Seed data: python scripts/seed.py --file seeds/accounts.json --table accounts
  • Analyze and optimize: python scripts/optimize.py --analyze --suggest-indexes
  • Health check: python health_check.py

Frequently Asked Questions about database-manager

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

FAQPage Schema
How do I automate database migrations across development and production environments?▼

You can automate database migrations by running Python scripts that create and execute schema changes, applying them consistently across development, staging, and production environments to minimize manual errors and ensure schema synchronization.

How do I analyze database performance and suggest indexing improvements?▼

Database performance analysis runs optimization scripts that evaluate query performance and suggest appropriate indexes, helping tune database operations by identifying missing indexes and providing recommendations for improved query execution.

Can I perform database health checks to verify schema sync between my application and database?▼

Yes, database health checks run verification scripts that examine schema synchronization and overall database integrity, ensuring compatibility between your application expectations and the actual database structure across all environments.

Do I need Python to run database automation scripts for migrations and optimization?▼

Yes, Python is required since the database automation relies on Python scripts including migration.py, seed.py, optimize.py, and health_check.py to execute schema changes, data population, performance tuning, and health verification tasks.

What's the best way to manage schema changes and performance tuning without manual SQL?▼

Automating schema changes and performance tuning through Python scripts eliminates manual SQL execution by handling migration creation, index management, and query optimization automatically across development, staging, and production database environments.

Related Skills

Explore More Software Engineering Skills→
JansenAnalyticsJansenAnalytics
5

database

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

Community
Advanced
jeremylongshorejeremylongshore
2.6k

monitoring-database-health

Monitor PostgreSQL and MySQL database health with real-time metrics and alerts.

Community
Advanced
harrytran998harrytran998

Database

Manage PostgreSQL schema evolution with versioned golang-migrate migrations.

Community
Advanced
seb1nseb1n
147

database-migration

Generate, execute, and roll back versioned database schema migrations across Alembic, Prisma, Flyway, and Knex.

Community
Advanced