admin-tools

Run database health checks, table statistics refreshes, and index rebuilds.

1.5k|222|Updated Jul 4, 2025
One-click install
npx skills add https://github.com/Datus-ai/Datus-agent --skill admin-tools
Or copy as Structured Prompt for Agent
Please help me install this Agent Skill.
Skill: admin-tools
Source: https://github.com/Datus-ai/Datus-agent/tree/main/tests/data/skills/admin-tools
Command: npx skills add https://github.com/Datus-ai/Datus-agent --skill admin-tools

SYSTEM DOCUMENTATION & REQUIREMENTS

What problem does it solve?

Authorized internal teams often need to perform critical database maintenance tasks to ensure system performance and reliability, but manual execution is error-prone and time-consuming.

Core Features & Use Cases

  • Database Health Check: Run full system health assessments to identify performance issues or anomalies.
  • Table Statistics Refresh: Update metadata for query optimizers to ensure accurate execution plans.
  • Index Rebuild: Optimize database performance by rebuilding fragmented indexes. Use case: After a major data pipeline deployment, a data engineer can use this skill to run a health check to catch performance degradation early, or refresh table stats to maintain query efficiency.

Quick Start

Use the admin-tools skill to run a full health check on the production customer database.

Frequently Asked Questions about admin-tools

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

FAQPage Schema
How do I run a database health check on production environments?

You can run a database health check on production environments using restricted, role-based administrative access to identify performance anomalies. This skill provides authorized internal users with controlled workflows to execute critical maintenance tasks safely.

When do I need to refresh table statistics for query optimizers?

Refresh table statistics for query optimizers after major data pipeline deployments to ensure accurate execution plans and maintain query efficiency. This skill updates table metadata for production and staging data environments to prevent performance degradation.

What is the best way to rebuild fragmented indexes in a staging database?

Rebuild fragmented indexes in a staging database through this skill's controlled index rebuild function, which optimizes database performance safely. It provides authorized internal users with restricted, role-based access to prevent unauthorized modifications during maintenance.

Can I use role-based access to secure routine database maintenance workflows?

Yes, you can use role-based access to secure routine database maintenance workflows such as health checks, table statistics refreshes, and index rebuilds. This skill satisfies requirements for restricted administrative operations to prevent unauthorized database modifications across production and staging environments.

Does this admin tool support automated table statistics refreshes and index rebuilds?

Yes, this admin tool supports table statistics refreshes and index rebuilds for production and staging data environments. It provides authorized internal users with controlled access to critical database administration tasks, reducing error-prone and time-consuming manual execution.