skills.rest
rnavarych
rnavarychCOMMUNITY
Explore all skills by this author →
GitHub

role-database:relational-databases

Configure, tune, and troubleshoot 20 relational SQL database engines.

14|3|Updated Feb 22, 2026
Search Tags:#database#postgresql#sql#oracle#replication#performance tuning#mysql#mssql
One-click install
npx skills add https://github.com/rnavarych/alpha-engineer --skill role-database-relational-databases
Or copy as Structured Prompt for Agent▼
Please help me install this Agent Skill.
Skill: role-database:relational-databases
Source: https://github.com/rnavarych/alpha-engineer/tree/main/plugins/roles/role-database/skills/relational-databases
Command: npx skills add https://github.com/rnavarych/alpha-engineer --skill role-database-relational-databases

SYSTEM DOCUMENTATION & REQUIREMENTS

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

What problem does it solve?

This Skill provides deep operational expertise for configuring, tuning, and troubleshooting 20 different relational SQL database engines in production environments.

Core Features & Use Cases

  • Database Tuning: Optimize performance for PostgreSQL, MySQL, Oracle, MS SQL Server, and more.
  • Operational Guidance: Covers replication, partitioning, indexing, security, and managed cloud options.
  • Troubleshooting: Offers insights into common anti-patterns and diagnostic approaches.
  • Use Case: You need to improve the slow query performance of your PostgreSQL database. Load this Skill and refer to the PostgreSQL tuning and indexing sections to identify and implement necessary optimizations.

Quick Start

Use the role-database:relational-databases skill to tune PostgreSQL VACUUM settings for a high-transaction table.

Frequently Asked Questions about role-database:relational-databases

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

FAQPage Schema
How do I tune PostgreSQL VACUUM settings for high-transaction tables?▼

To tune PostgreSQL VACUUM settings, configure autovacuum parameters based on transaction volume and table size to prevent bloat. This Skill provides operational guidance for optimizing PostgreSQL performance in production environments.

What are the best indexing strategies for optimizing OLTP workloads in MySQL?▼

The best indexing strategies for MySQL OLTP workloads involve creating targeted composite indexes to accelerate high-frequency point queries. This Skill provides indexing best practices to optimize relational database performance for transactional systems.

Does this database tuning guidance cover Oracle and MS SQL Server replication?▼

This database tuning guidance covers replication strategies for Oracle and MS SQL Server, including advanced features like Availability Groups. It supports 20 relational SQL database engines across production configuration and operational troubleshooting.

How do I troubleshoot common SQL performance anti-patterns in production?▼

To troubleshoot SQL performance anti-patterns in production, diagnose slow queries by examining execution plans and identifying improper indexing or partitioning. This Skill offers diagnostic approaches for resolving common relational database issues.

What is the best way to configure partitioning techniques for analytics workloads?▼

The best way to configure partitioning for analytics workloads is implementing range or list partitioning to improve query isolation and maintenance. This Skill addresses partitioning techniques to optimize large relational database tables.

Can I compare managed cloud database services for PostgreSQL and MSSQL here?▼

You can compare managed cloud database services for PostgreSQL and MSSQL using this Skill. It provides managed cloud service comparisons alongside security hardening and performance tuning guidance for relational SQL databases.

Related Skills

Explore More Software Engineering Skills→
Snowflake-LabsSnowflake-Labs
1

oracle-connection

Configure and verify Oracle database connections for schema extraction.

Official
Intermediate
jm199seojm199seo

canary

Monitor live pages for errors and performance regressions after deploys.

Community
Advanced
4lerman4lerman

senior-devops

Automates DevOps workflows including CI/CD pipelines, infrastructure as code, and container deployments with rollback support.

Community
Advanced
novvoonovvoo

clickhouse-io

Optimize ClickHouse schemas, queries, and data ingestion for analytical workloads.

Community
Intermediate