SkillsAdd

Source

cockroachlabs/cockroachdb-skills

34 skills · 3.8K combined installs

Skills from this source

#
Skill
Source
8W Activity
Installs
1
cockroachdb-sql Use when writing, generating, or optimizing SQL for CockroachDB, designing CockroachDB schemas, or when the user asks…
cockroachlabs/cockroachdb-skills
142
2
analyzing-range-distribution Analyzes CockroachDB range distribution across tables and indexes using SHOW RANGES to identify range count, size pat…
cockroachlabs/cockroachdb-skills
120
3
auditing-table-statistics Audits optimizer table statistics for staleness, missing coverage, and data quality issues using SHOW STATISTICS. Use…
cockroachlabs/cockroachdb-skills
120
4
designing-application-transactions Guides application developers in designing correct and performant transaction patterns for CockroachDB, covering tran…
cockroachlabs/cockroachdb-skills
119
5
analyzing-schema-change-storage-risk Estimates storage requirements for CockroachDB online schema change backfills using SHOW RANGES WITH DETAILS, KEYS, I…
cockroachlabs/cockroachdb-skills
118
6
benchmarking-transaction-patterns Guides benchmarking and comparing explicit multi-statement transactions versus single-statement CTE transactions in C…
cockroachlabs/cockroachdb-skills
118
7
reviewing-cluster-health Performs a comprehensive health check of a CockroachDB cluster. Gathers deployment context first, then provides tier-…
cockroachlabs/cockroachdb-skills
118
8
profiling-statement-fingerprints Ranks and analyzes statement fingerprints using aggregated SQL statistics from crdb_internal.statement_statistics to …
cockroachlabs/cockroachdb-skills
117
9
profiling-transaction-fingerprints Analyzes transaction fingerprints using aggregated statistics from crdb_internal.transaction_statistics to identify h…
cockroachlabs/cockroachdb-skills
117
10
hardening-user-privileges Hardens CockroachDB user privileges by auditing and tightening role-based access control, reducing admin grants, rest…
cockroachlabs/cockroachdb-skills
116
11
managing-cluster-settings Reviews, audits, and modifies CockroachDB cluster settings. Self-Hosted has full control over all settings and start …
cockroachlabs/cockroachdb-skills
116
12
managing-tls-certificates Manages TLS certificates for CockroachDB clusters including CA certificate configuration, client certificate authenti…
cockroachlabs/cockroachdb-skills
116
13
monitoring-background-jobs Monitors CockroachDB background job health by identifying failed, paused, and long-running jobs using SHOW JOBS and S…
cockroachlabs/cockroachdb-skills
116
14
triaging-live-sql-activity Diagnoses live CockroachDB cluster performance issues by identifying long-running queries, busy sessions, and active …
cockroachlabs/cockroachdb-skills
116
15
performing-cluster-maintenance Manages planned cluster maintenance across all tiers. Self-Hosted covers node drain procedures for OS patching, hardw…
cockroachlabs/cockroachdb-skills
114
16
auditing-cloud-cluster-security Audits the security posture of a CockroachDB cluster (Cloud or self-hosted) across network, authentication, authoriza…
cockroachlabs/cockroachdb-skills
113
17
configuring-audit-logging Configures SQL audit logging on CockroachDB clusters to capture security-relevant events including authentication, pr…
cockroachlabs/cockroachdb-skills
112
18
managing-cluster-capacity Manages CockroachDB cluster capacity across all tiers. Self-Hosted covers node decommissioning for permanent removal …
cockroachlabs/cockroachdb-skills
112
19
configuring-log-export Configures log and metric export for CockroachDB Cloud clusters to external monitoring services including AWS CloudWa…
cockroachlabs/cockroachdb-skills
111
20
designing-multi-region-applications Guides developers in selecting and implementing multi-region patterns for CockroachDB applications, covering active-p…
cockroachlabs/cockroachdb-skills
111
21
molt-fetch Guide for using molt fetch to migrate data from PostgreSQL, MySQL, Oracle, or MSSQL to CockroachDB. Use when running …
cockroachlabs/cockroachdb-skills
111
22
molt-verify Guide for using molt verify to compare source and target databases for schema and row-level consistency after a migra…
cockroachlabs/cockroachdb-skills
111
23
provisioning-cluster-for-production Guides initial CockroachDB cluster provisioning and production deployment. Self-Hosted covers cockroach start/init, K…
cockroachlabs/cockroachdb-skills
111
24
configuring-ip-allowlists Configures and hardens IP allowlists for CockroachDB Cloud clusters to restrict network access to authorized CIDR ran…
cockroachlabs/cockroachdb-skills
110
25
configuring-private-connectivity Configures private network connectivity for CockroachDB Cloud clusters including AWS PrivateLink, GCP Private Service…
cockroachlabs/cockroachdb-skills
109
26
configuring-sso-and-scim Configures SSO authentication and SCIM 2.0 provisioning for CockroachDB across four distinct layers — Cloud Console S…
cockroachlabs/cockroachdb-skills
109
27
enforcing-password-policies Configures and enforces password policies on CockroachDB clusters including minimum length, complexity requirements, …
cockroachlabs/cockroachdb-skills
109
28
managing-certificates-and-encryption Manages TLS certificate and encryption key lifecycle across all tiers. Self-Hosted covers certificate expiry monitori…
cockroachlabs/cockroachdb-skills
109
29
molt-replicator Guide for using the CockroachDB replicator to continuously replicate changes from PostgreSQL, MySQL, or Oracle to Coc…
cockroachlabs/cockroachdb-skills
109
30
enabling-cmek-encryption Enables Customer-Managed Encryption Keys (CMEK) on CockroachDB Cloud clusters with the Advanced plan and Advanced Sec…
cockroachlabs/cockroachdb-skills
108
31
upgrading-cluster-version Guides CockroachDB version upgrades with tier-appropriate procedures. Self-Hosted covers manual rolling binary replac…
cockroachlabs/cockroachdb-skills
107
32
preparing-compliance-documentation Guides preparation of compliance documentation for CockroachDB Cloud deployments, covering SOC 2, PCI DSS, ISO 27001,…
cockroachlabs/cockroachdb-skills
106
33
setting-up-local-cluster Downloads and starts a local CockroachDB cluster for development using the official binary. Use when a developer need…
cockroachlabs/cockroachdb-skills
102
34
auditing-cis-benchmark Audits a self-hosted CockroachDB cluster against the CIS CockroachDB Benchmark v1.0.0 Level 1 controls. Supports two …
cockroachlabs/cockroachdb-skills
69