ysql
yugabyte/yugabytedb-skills · skills.sh
Open source Repository Open in the app JSON README (API)
About
Skill publicada por yugabyte/yugabytedb-skills no skills.sh. Instale com: npx skills add yugabyte/yugabytedb-skills@ysql
Details
- Kind
- Agent skills
- Publisher
- yugabyte
- Origin
- skillssh
- Category
- ferramentas
- Stars
- 8
- Forks
- 7
- Open pull requests
- 2
- Last push
- 2026-10-05T17:37:28Z
- Repository state
- ativo
- Language
- Python
- License
- Apache-2.0
- Added
- 2026-10-07 06:18:42
- Updated
- 2026-10-07 06:18:42
- Origin id
yugabyte/yugabytedb-skills/ysql
README
# YugabyteDB Agent Skills Empower your AI agents and automation systems with native YugabyteDB expertise. This curated collection of structured skills enables developer tools to perform intelligent, production-grade database operations with full contextual awareness. ## Getting Started Install all available skills at once: ```bash npx skills add yugabyte/yugabytedb-skills ``` Or pick only what you need: ```bash # PostgreSQL-compatible YSQL API npx skills add yugabyte/yugabytedb-skills -s ysql # Cassandra-compatible YCQL API npx skills add yugabyte/yugabytedb-skills -s ycql # YugabyteDB Kubernetes Operator npx skills add yugabyte/yugabytedb-skills -s yb-k8s-operator # YugabyteDB Anywhere REST API npx skills add yugabyte/yugabytedb-skills -s yba-api # YugabyteDB Anywhere Terraform provider npx skills add yugabyte/yugabytedb-skills -s yba-terraform # RAG / semantic search with LangChain on YugabyteDB npx skills add yugabyte/yugabytedb-skills -s yb-rag-langchain # YugabyteDB Aeon (managed cloud) REST API npx skills add yugabyte/yugabytedb-skills -s aeon-api # Universe metrics analysis (Prometheus/PromQL, hotspots, CPU, memory, I/O) npx skills add yugabyte/yugabytedb-skills -s yb-metrics-analysis # Broad, whole-universe performance assessment (triage + orchestration) # — install with yb-query-analysis, yb-metrics-analysis and yba-api, which it runs npx skills add yugabyte/yugabytedb-skills -s yb-performance-assessment # YSQL query performance, session activity, and lock contention analysis npx skills add yugabyte/yugabytedb-skills -s yb-query-analysis ``` ## Available Skills |Skill|Description| |-|-| |`ysql`|SQL and application development against YugabyteDB's PostgreSQL-compatible API — covers anti-patterns, schema design (sharding, indexes, geo-distribution), smart drivers, transaction retries, batching, PostgreSQL migration strategies, and production readiness checklists | |`ycql`|YCQL (Cassandra-compatible API) development — covers partition keys, clustering columns, global secondary indexes, prepared statements, batching, TTL management, and memory configuration | |`yb-k8s-operator`|YugabyteDB Kubernetes Operator - deploying and managing YugabyteDB universes on Kubernetes through the YugabyteDB Anywhere or YugabyteDB (OSS) Kubernetes Operators| |`yba-api`|YugabyteDB Anywhere REST API — using the YugabyteDB Anywhere REST API to create, observe, manage and deploy YugabyteDB universes in a range of infrastructure topologies and clouds| |`yba-terraform`|YugabyteDB Anywhere Terraform provider (`yugabyte/yba`) — installing YBA on a VM, registering the first customer, and creating cloud (AWS/GCP/Azure) or on-prem providers, storage configs, universes, backups, schedules and restores, plus the upstream cloud IAM and network discovery those manifests need| |`yb-rag-langchain`|RAG, semantic search, and hybrid (vector + full-text) search on YugabyteDB with LangChain — covers `PGVectorStore` setup, `ybhnsw` / GIN index creation, hybrid search configuration, metadata filtering, and combining relational predicates with vector queries| |`aeon-api`|YugabyteDB Aeon (managed cloud) REST API — scripting and automating cluster lifecycle, database users, network allowlists, backups, VPC peering/private endpoints, and cluster metrics| |`yb-metrics-analysis`|YugabyteDB universe metrics analysis — Prometheus/PromQL-based triage and playbooks for hotspots, CPU, memory, I/O, latency/throughput, connection skew, and tablet limits| |`yb-performance-assessment`|Broad, whole-universe YugabyteDB performance assessment — triage-and-orchestration entry point that runs cross-cutting SQL and infrastructure checks, then dispatches to the specialist skills| |`yb-query-analysis`|YSQL query performance, session activity, and lock contention analysis — including proactive database health assessment and pg_stat_statements/ASH-driven diagnosis| ## Learn More - [YugabyteDB Documentation](https://docs.yugabyte.com/) - [YugabyteDB Blog](https://www.yugabyte.com/blog) - [skills.sh](https://skills.sh/) — The Open Agent Skills Ecosystem ## License This project is licensed under the [Apache License 2.0](https://github.com/yugabyte/yugabytedb-skills/blob/HEAD/LICENSE).