kinetica-admin

Name: kinetica-admin
Availability: InStock
Author: Kinetica

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

Ready to run

npx skills add https://github.com/kineticadb/agent-skills --skill kinetica-admin

💬 Prompt for ChatGPT / Claude Chat▼

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.