Analyze slow queries with EXPLAIN ANALYZE and propose indexing strategies.
npx skills add https://github.com/grasberg/sofia --skill database-admin-grasberg
Please help me install this Agent Skill. Skill: database-admin Source: https://github.com/grasberg/sofia/tree/main/workspace/skills/database-admin Command: npx skills add https://github.com/grasberg/sofia --skill database-admin-grasberg
Diagnose and optimize database performance, reliability, and data integrity across multiple database systems.
Diagnose a slow query in PostgreSQL and propose an index to accelerate it.
High-intent search queries and answers about installing and using this skill.
To diagnose slow queries, use EXPLAIN ANALYZE to evaluate execution plans and apply targeted indexing strategies to resolve performance bottlenecks. This approach isolates query execution issues and guides indexing improvements across PostgreSQL and MySQL.
Planning database replication and PITR requires structured backup procedures and high availability configuration. This Skill provides deployment guidance for replication setups and Point-in-Time Recovery across PostgreSQL, MySQL, MongoDB, and Redis to ensure data reliability.
Yes, you can execute zero-downtime database migrations by designing migration-safe changes and rollback procedures. This Skill guides you through migration readiness planning to ensure data integrity and system availability during structural database modifications.
This database tuning approach works with MongoDB and Redis deployments alongside relational systems like PostgreSQL and MySQL. It diagnoses performance bottlenecks and applies optimization strategies tailored to each specific database environment.
Database query performance often degrades under replication setups due to unanalyzed execution bottlenecks and indexing gaps. Using EXPLAIN ANALYZE-driven tuning identifies these query plan issues and optimizes indexing to maintain performance during high availability operations.
tankpkgOptimize PostgreSQL and MySQL query performance with indexing and tuning strategies.
bdbchAutomate application deployments with CI/CD pipelines and Docker.
MovchanetsPlan and validate database administration workflows for cloud and self-managed environments.
lluppesmsAnalyze SQL execution plans and recommend index optimizations.
