db-admin

Manage database administration tasks for PostgreSQL, MySQL, Redis, and SQLite.

Updated May 9, 2026
One-click install
npx skills add https://github.com/LeandroBenjaminL/lend-ai --skill db-admin-leandrobenjaminl
Or copy as Structured Prompt for Agent
Please help me install this Agent Skill.
Skill: db-admin
Source: https://github.com/LeandroBenjaminL/lend-ai/tree/main/skills/db-admin
Command: npx skills add https://github.com/LeandroBenjaminL/lend-ai --skill db-admin-leandrobenjaminl

SYSTEM DOCUMENTATION & REQUIREMENTS

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

What problem does it solve?

Streamline database administration tasks such as schema design, performance optimization, and backup management with ease.

Core Features & Use Cases

  • Database Administration: Handle PostgreSQL, MySQL, Redis, and SQLite databases.
  • Schema and Index Management: Design efficient schemas and manage indexes for optimal performance.
  • Performance Optimization: Analyze and optimize slow queries and database configurations.
  • Backup and Replication: Set up and manage database backups and replication for high availability.
  • Use Case: When you need to optimize a database schema, resolve performance issues, or configure a replication setup.

Quick Start

Execute the db-admin skill to perform a database backup and check for performance bottlenecks.

Frequently Asked Questions about db-admin

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

FAQPage Schema
How do I optimize slow queries and database configurations for PostgreSQL and MySQL?

Database performance optimization is achieved by analyzing slow queries and tuning database configurations. This skill supports PostgreSQL and MySQL to resolve performance bottlenecks and ensure optimal query execution.

What's the best way to set up database replication and backup management for high availability?

Database replication and backup management are configured to establish high availability. This skill manages the backup and replication setup processes for supported databases to ensure data recoverability.

Can I design efficient database schemas and manage indexes for SQLite and Redis?

Schema design and index management are supported for SQLite and Redis databases. You can design efficient schemas and manage indexes to maintain database integrity and achieve optimal performance.

Do I need specific database management tools to execute schema design and backup scripts?

Specific database management tools and scripts are required to execute administration tasks. The skill requires these external dependencies to perform schema design, performance optimization, and backup operations effectively.

Why does database administration fail without proper backup and replication configuration?

Database administration requires proper backup and replication configuration to ensure data integrity and recoverability. Without these configurations, high availability is compromised and data loss risks increase significantly.