database-operations-skills

Plugin database-operations-skills from marketplace ops-engineering-skills in selvarajmurugesan90/ops-engineering-skills. Commands read from the repo's manifest — 1 month ago.

Skills (23)

• arangodb-multi-model-database-operations

  Covers operating ArangoDB, a multi-model database combining document, graph, and key-value collections in a single engine with a unified query language (AQL): collection type selection, graph traversal via AQL, and cluster configuration (coordinators, DB-servers, agency). Use when the user asks to "

• cassandra-wide-column-database-operations

  Covers Apache Cassandra ring topology and token/partition design, tunable consistency levels (ONE, QUORUM, ALL, LOCAL_QUORUM), compaction strategy selection (SizeTiered, Leveled, TimeWindow), and tombstone/GC-grace management. Use when the user asks to "design a Cassandra partition key," "choose a C

• clickhouse-analytical-database-operations

  Covers operating ClickHouse, the leading open-source OLAP columnar database: MergeTree engine family selection (MergeTree, ReplacingMergeTree, AggregatingMergeTree, SummingMergeTree), sharding and replication topology via ReplicatedMergeTree and Distributed tables, and materialized views for streami

• cloud-data-warehouse-operations-snowflake-bigquery-redshift

  Comparative operations guide for the three dominant managed cloud data warehouses: Snowflake virtual warehouse sizing and multi-cluster scaling, BigQuery slot allocation and on-demand vs. capacity pricing, and Redshift cluster/RA3 node sizing and workload management (WLM) — plus cost-control and que

• database-backup-and-restore-strategies

  Cross-database backup tooling and restore-testing discipline: pg_dump/pg_basebackup for PostgreSQL, mysqldump/Percona XtraBackup for MySQL/MariaDB, and mongodump/mongorestore for MongoDB — logical vs. physical backup trade-offs, point-in-time recovery, and why an untested restore is not a real backu

• database-connection-pooling-strategies

  Cross-database connection pooling patterns and tooling: PgBouncer for PostgreSQL, ProxySQL for MySQL/MariaDB, and the shared design questions (transaction vs. session vs. statement pooling modes, backend pool sizing, failover-aware routing) that apply regardless of the underlying database engine. Us

• database-schema-migration-with-liquibase-and-flyway

  Covers version-controlled schema migration tooling (Liquibase changesets/changelogs, Flyway versioned/repeatable migrations), forward-only vs. reversible migration design, safe patterns for backward-compatible rolling deploys, and testing migrations in CI before they reach production. Use when the u

• elasticsearch-opensearch-cluster-operations

  Covers Elasticsearch/OpenSearch shard and index lifecycle management (ILM/ISM: hot-warm-cold-delete tiers, rollover), cluster health triage (yellow/red status root-causing), and reindexing (mapping changes, zero-downtime cutover via aliases). Use when the user asks to "why is my Elasticsearch/OpenSe

• elasticsearch-opensearch-configuration-validation

  Validates proposed Elasticsearch/OpenSearch index mapping, shard count/ replica allocation, and ILM/ISM policy settings before production indexing begins — checking primary shard count against expected data volume and node count, mapping field types against real query patterns, and replica/allocatio

• liquibase-advanced-changelog-management-and-rollback-strategies

  Deep-dive Liquibase changelog management beyond basic changesets: contexts and labels for environment-specific targeting, custom rollback definitions for changes Liquibase can't auto-generate, and changelog organization/best practices for large, long-lived projects with many contributors. Use when t

• mongodb-configuration-validation

  Validates proposed MongoDB replica set configuration, sharding setup, and index changes before production rollout — checking voting-member quorum math, shard key cardinality against real data, and index build impact. Use when the user asks to "review this MongoDB replica set config," "validate a sha

• mongodb-operations-and-scaling

  Covers MongoDB replica set operations, sharding design (shard key selection, chunk balancing), index tuning, and routine operational maintenance (compaction, oplog sizing, election tuning). Use when the user asks to "set up MongoDB sharding," "pick a shard key," "why is this MongoDB query slow," "re

• mysql-mariadb-configuration-validation

  Validates proposed my.cnf changes, replication topology, and connection limits before they are applied to a production MySQL/MariaDB instance — catching dynamic-vs-static variables applied with the wrong scope, GTID-mode mismatches across a replication topology, and connection/ thread-pool overcommi

• mysql-mariadb-high-availability-and-replication

  Covers multi-master synchronous clustering for MySQL/MariaDB: Galera Cluster (MariaDB Galera / Percona XtraDB Cluster), MySQL Group Replication and InnoDB Cluster, quorum and split-brain prevention, and choosing between multi-master clustering and simple primary-replica topologies. Use when the user

• mysql-mariadb-operations-and-performance-tuning

  Covers day-2 MySQL/MariaDB operations: async, semi-sync, and GTID-based replication, InnoDB buffer pool sizing and I/O tuning, index and query optimization with EXPLAIN, and MariaDB-specific storage engine choices (InnoDB vs. Aria vs. ColumnStore/MyRocks). Use when the user asks to "tune MySQL perfo

• neo4j-graph-database-operations

  Covers operating Neo4j: Cypher query fundamentals for operational diagnosis, causal clustering for HA and read scaling, and index/ constraint management (property indexes, full-text indexes, uniqueness constraints). Use when the user asks to "write a Cypher query for this graph traversal," "set up a

• postgresql-configuration-validation

  Validates proposed postgresql.conf changes, replication configuration, and connection-limit math before they are applied to a production PostgreSQL instance — catching restart-required settings applied as reload-only, connection-count overcommit against PgBouncer pools, and unsafe replication parame

• postgresql-high-availability-and-failover

  Designs PostgreSQL high-availability topologies with Patroni-managed automatic failover or manual streaming-replication failover, covers split-brain prevention (fencing, watchdog, consensus store quorum), and how to safely test failover without turning a drill into an outage. Use when the user asks

• postgresql-operations-and-performance-tuning

  Covers day-2 PostgreSQL operations: streaming and logical replication, vacuum/autovacuum tuning and bloat remediation, connection pooling with PgBouncer, query performance tuning (EXPLAIN ANALYZE, indexing, planner statistics), and major-version upgrade strategy (pg_upgrade vs. logical replication c

• redis-caching-strategy-and-invalidation-patterns

  Covers application-facing caching design on top of Redis: cache-aside vs. write-through vs. write-behind, TTL strategy (fixed, sliding, jittered), cache invalidation patterns (explicit delete, versioned keys, pub/sub fan-out) and their specific failure modes (stale reads, thundering herd, cache stam

• redis-configuration-validation

  Validates proposed Redis maxmemory/eviction-policy settings, persistence configuration (RDB/AOF), and Redis Cluster topology before they are relied on in production — checking eviction policy against actual data classification, replica placement against failure domains, and quorum/majority math for

• redis-operations-and-cluster-management

  Covers Redis persistence (RDB snapshots, AOF with rewrite), Redis Cluster topology (hash slots, resharding, replica failover), Sentinel- based HA for non-clustered deployments, and memory management (maxmemory, eviction policy interaction with persistence and replication). Use when the user asks to

• timescaledb-time-series-operations-and-configuration

  Covers TimescaleDB as a PostgreSQL extension for time-series workloads: hypertable creation and chunk-interval sizing, continuous aggregates for pre-computed rollups, and retention/compression policies. Use when the user asks to "set up a TimescaleDB hypertable," "size chunk intervals," "create a co

Similar plugins