skills.rest
kineticadb
kineticadbOFFICIAL
Explore all skills by this author →
Website𝕏@KineticaHQGitHub

kinetica-admin

Monitor Kinetica cluster health, diagnose queries via EXPLAIN plans, and manage security.

4|1|Updated Feb 26, 2026
Search Tags:#monitoring#security#SQL#performance tuning#database administration#kinetica
One-click install
npx skills add https://github.com/kineticadb/agent-skills --skill kinetica-admin
Or copy as Structured Prompt for Agent▼
Please help me install this Agent Skill.
Skill: kinetica-admin
Source: https://github.com/kineticadb/agent-skills/tree/main/plugins/kinetica/skills/kinetica-admin
Command: npx skills add https://github.com/kineticadb/agent-skills --skill kinetica-admin

SYSTEM DOCUMENTATION & REQUIREMENTS

💡 This Skill includes references (resource) components.

What problem does it solve?

This Skill helps users manage, monitor, and optimize Kinetica database clusters by providing knowledge on administration tasks, system tables, and performance tuning.

Core Features & Use Cases

  • Cluster Monitoring: Understand how to check cluster health and identify performance bottlenecks using system tables.
  • Query Analysis: Learn to use EXPLAIN plans to diagnose slow queries and optimize execution.
  • Security & Resource Management: Gain insights into managing users, roles, resource groups, and tier configurations.
  • Use Case: A database administrator needs to troubleshoot a slow-running query. They can use this Skill to query ki_catalog.ki_query_history and analyze the EXPLAIN plan for the problematic query.

Quick Start

Use the kinetica-admin skill to find the top 5 tables by size in the database.

Frequently Asked Questions about kinetica-admin

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

FAQPage Schema
How do I check Kinetica cluster health and identify performance bottlenecks?▼

To check cluster health, query Kinetica system tables to monitor cluster status and identify performance bottlenecks. This approach provides direct visibility into database operations and resource usage metrics.

How do I use EXPLAIN plans to diagnose slow queries in a Kinetica database?▼

Use EXPLAIN plans to diagnose slow queries by analyzing execution paths in your Kinetica database. Query ki_catalog.ki_query_history to retrieve query history and inspect the EXPLAIN plan for problematic SQL statements.

How do I manage users, roles, and resource groups in Kinetica?▼

Manage users, roles, and resource groups in Kinetica through the database administration security framework. This includes configuring tier configurations and assigning resource groups to control access and allocate system resources effectively.

What is the best way to find the top 5 tables by size in a Kinetica database?▼

The best way to find the top 5 tables by size is to query Kinetica system tables. This administrative task leverages built-in metadata to quickly list database objects ranked by their storage footprint.

Can I optimize Kinetica database deployments by tuning SQL performance?▼

Yes, you can optimize Kinetica deployments by tuning SQL performance. Analyze EXPLAIN plans and query ki_catalog.ki_query_history to diagnose slow execution, identify bottlenecks, and refine your SQL queries for better cluster efficiency.

Related Skills

Explore More Data & Analytics Skills→
interflownexinterflownex
2

alloydb-postgres-data

Access AlloyDB PostgreSQL metadata and execute custom SQL queries.

Community
Intermediate
devendrapratapsinghdevendrapratapsingh
1

k8s

Manage, tune, secure, and debug Kubernetes clusters.

Community
Advanced
AltinityAltinity
16

altinity-expert-clickhouse-metrics

Monitor ClickHouse metrics, events, and asynchronous metrics via SQL checks.

Official
Advanced
MarioDeFelipeMarioDeFelipe
25

datasphere-admin

Manage SAP Datasphere spaces, users, roles, security, monitoring, and transport operations.

Community
Advanced